MySQL Bugs: #28657: ODBC Connector returns FALSE on SQLGetTypeInfo with DATETIME (wxWindows latest)

Bug #28657	ODBC Connector returns FALSE on SQLGetTypeInfo with DATETIME (wxWindows latest)
Submitted:	24 May 2007 16:38	Modified:	26 Jul 2007 16:25
Reporter:	Christian Dankbar
Status:	Closed
Category:	Connector/ODBC	Severity:	S2 (Serious)
Version:	3.51 & 5.0	OS:	Microsoft Windows (Win2000/XP)
Assigned to:	Jim Winstead	Target Version:
Tags:	ODBC, datetime, wxWindows, wxWidgets

Description:
When using wxWidgets as ODBC connection library for Win32/Linux applications and trying
to connect to a myODBC database, the connection always fails. When debugging the library
connection function, it seems that the myODBC connector returns FALSE for DATETIME when
supported data types are polled by the library implementation prior to connection.

How to repeat:
Win32 (2000/XP): set up a ODBC data source using MySQL and latest myODBC connector,
download the latest wxWidgets (http://www.wxwidgets.org/downloads/ - 2.8.4 is latest
stable as of 24. May 2007, "wxMSW" is the name of the Win32 version), compile the
DBBrowse demo application (located in the subfolder "demos") and run/debug it. It will
fail in the function call "Open()" of the class "wxDb" when testing for the supported
datatypes: the call "getDataTypeInfo(SQL_DATETIME,typeInfDate)" does not return
SQL_SUCCESS.
FYI: The Win32 function used is "SQLGetTypeInfo()" from the "Microsoft Platform SDK for
Windows Server R2"

Suggested fix:
Make the ODBC connector returning SQL_SUCCESS for such a datatype info request.

Can you include an ODBC trace log?

I can confirm this for the 3.51 series, because we use SQL_TIMESTAMP for the DATETIME type
for some reason. We'll have to investigate to figure out why.

I haven't checked what the 5.0 driver does.

The 5.0 (I tested version 5.00.11 beta) shows the same behavior.

Fix results for date/time types, and check SQL_DATA_TYPE in addition to DATA_TYPE

Attachment: bug28657.patch (text/plain), 4.42 KiB.

A note has been added to the 3.51.18 changelog: 

DATETIME column types would return FALSE in place of SQL_SUCCESS when requesting the
column type information.