Bug #2796 SQLColumns() call. returns a static array of types
Submitted: 14 Feb 2004 12:01 Modified: 29 May 2013 13:26
Reporter: SINISA MILIVOJEVIC Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.51 OS:Any (Any)
Assigned to: CPU Architecture:Any

[14 Feb 2004 12:01] SINISA MILIVOJEVIC
Description:
In a nutshell, the problem with the ODBC driver  is around
the SQLColumns() call. The data returns from a static array of types.  This information should be dynamic and read from the connected
database. You may want to cache this information on a per connection basis
for performance reasons but that is probably not necessary.

How to repeat:
See above
[26 Feb 2004 10:28] Peter Harvey
SQLColumns() should return information about table columns etc - including its data types. It probably should not cache this information.

SQLColumns() should return this information in a result set. 

My understanding is that MyODBC -> SQLColumns() does this. 

Perhaps you could provide more information about the problem.
[29 May 2013 13:26] Bogdan Degtyariov
Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/