Bug #64307 SQLForeigKeys with NO_I_S option is broken for latest server versions
Submitted: 13 Feb 2012 9:27 Modified: 21 Nov 2013 14:05
Reporter: Lawrenty Novitsky Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version: OS:Any
Assigned to: Lawrenty Novitsky CPU Architecture:Any

[13 Feb 2012 9:27] Lawrenty Novitsky 
Description:
Starting from certain server version SQLForeignKeys will not work if NO_I_S option connection option is selected.

How to repeat:
Run any test calling SQLForeignKeys against DSN with "Don't use information_schema for metadata" option selected(or OPTION with 1 << 30 bit set).

Suggested fix:
Driver should always use I_S for SQLForeignKeys calls for such server versions.
[21 Nov 2013 14:04] Hemant Dangi 
The patch was pushed into the
5.1 tree revision 1126
5.2 tree revision 1192
5.3 tree revision 1222
[21 Nov 2013 14:05] Hemant Dangi 
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html
[22 Nov 2013 23:31] Daniel So 
Added the following entry into the Connector/ODBC 5.1.14, 5.2.7, and 5.3.1 changelogs:

"From Connector/ODBC version 5.2.2 onwards, the function SQLForeignKeys() did not work if the connection option NO_INFORMATION_SCHEMA was set."