Select From ALL_TABLES, ALL_USERS, ALL_OBJECTS Returns Invalid Results Using DG4ODBC to MySQL (Doc ID 1072510.1)

Last updated on AUGUST 02, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

*** THIS PROBLEM IS FIXED IN 11.2.0.2 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 -
ALL_TABLES
ALL_USERS
ALL_OBJECTS

returns a count of 1.
This is incorrect as internal test shows that ALL_TABLES should return a count of 28.

Changes

This issue is fixed in 11.2.0.2

Cause

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