Bug #8198 mysql_list_dbcolumns() and inset_fields() fetch entire table
Submitted: 29 Jan 2005 23:04 Modified: 9 Mar 2005 4:08
Reporter: Dean Ellis
Status: Closed
Category:Connector/ODBC Severity:S3 (Non-critical)
Version:3.51.10 OS:
Assigned to: Target Version:

[29 Jan 2005 23:04] Dean Ellis 
Description:
The mysql_list_dbcolumns() and insert_fields() functions unnecessarily retrieve all rows
from a table.

How to repeat:
Call SQLColumns(), or just look at catalog.c (mysql_list_dbcolumns) and cursor.c
(insert_fields).

Suggested fix:
Add LIMIT 1 (or LIMIT 0) clauses to the statements these functions are generating.
[14 Feb 2005 18:09] Dean Ellis 
Fixed in 3.51.11.
[9 Mar 2005 4:08] Paul DuBois 
Noted in MyODBC 3.51.11 changelog.