MySQL Bugs: #40678: SQLTablesW returns incorrect results

Bug #40678	SQLTablesW returns incorrect results
Submitted:	12 Nov 2008 21:21	Modified:	14 Nov 2008 17:24
Reporter:	John Water	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	5.1.5	OS:	Windows (Win-XP)
Assigned to:		CPU Architecture:	Any
Tags:	SQLTablesW

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
The following ODBC function call

SQLTablesW( stmt, (SQLWCHAR *)database, SQL_NTS,NULL, SQL_NTS,NULL, SQL_NTS, NULL, SQL_NTS );

should return all the tables in the given database.  However, with MySQL, ODBC driver 5.1.5, this function call will return

Table Catalog: my_database
Table Schema:  <NULL>
Table Name:    <NULL>
Table Type:    <NULL>
Remarks:       <NULL>

How to repeat:
A simple repro will be attached.  The command line would be
odbcbug "dsn=...;uid=...;pwd=..."

This was fixed from bug#39561. The fix will be included in the next release (5.1.6). Please feel free to test a snapshot before the next version is released.

http://downloads.mysql.com/snapshots.php