Problems Selecting Data Dictionary Tables Using DG4ODBC And MySQL 5.1.8 ODBC Driver (Doc ID 1338690.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

A connection to MySQL works successfully using Database Gateway for ODBC (DG4ODBC) 11.2.0.1 or 11.2.0.2 on Windows and the MySQL 5.1.8 ODBC driver.
However, a select from data dictionary tables such as all_tables, all_objects only returns 1 row instead of the corrrect data for all the tables in the MySQL database.
For example -


SQL> select table_name from user_tables@mysql ;

TABLE_NAME
------------------------------
administrative_table



but there are 23 tables in the MySQL database.
A describe will only return the first column of the table -


SQL> desc "administrative_table"@mysql ;
Name Null? Type
----------------------------------------- --------
----------------------------

column_1 NOT NULL NVARCHAR2(1)



when it has many more.
A select from the table only returns the first column -


select * from "administrative_table"@mysql ;

co
--
O
O
...
...
O
X

7891 rows selected.


The problem does not happen with the MySQL ODBC driver 5.1.6 or 3.51.

Changes

Update from MySQL ODBC driver 5.1.6 or 3.5.1 to 5.1.8.

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