Select From ALL_TABLES, ALL_USERS, ALL_OBJECTS Returns Invalid Results Using DG4ODBC to MySQL
(Doc ID 1072510.1)
Last updated on FEBRUARY 05, 2019
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
*** THIS PROBLEM IS FIXED IN 126.96.36.199 VERSION OF DG4ODBC ******
The configuration is Oracle RDBMS 10.2.0.4 on Sun Solaris 2.10 connecting to MYSQL 5.1 using DG4ODBC 11.2.
The MySQL version is 5.1.36, and the MySql ODBC driver version is 5.1.5.
Select count(*) from the following tables -
returns a count of 1.
This is incorrect as internal test shows that ALL_TABLES should return a count of 28.
This issue is fixed in 188.8.131.52
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document