Select From ALL_TABLES, ALL_USERS, ALL_OBJECTS Returns Invalid Results Using DG4ODBC to MySQL
Last updated on AUGUST 02, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 184.108.40.206
Information in this document applies to any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms