3.51.17 error 1064 - can't get field metadata due to syntax error in SQL query

------=_NextPart_000_00A5_01C7C9FF.66F03450
Content-Type: text/plain;
charset="koi8-r"
Content-Transfer-Encoding: quoted-printable

mysql-connector-odbc-3.51.17r581/driver/catalog.c

------------------------------------------------------------ -------------=
------------------------------------------------------------ -------------=
----------

/* Build a SELECT ... LIMIT 0 to get the field metadata. */
if (!(select=3D (char *)my_malloc(sizeof(char) * =
(ulong)result->row_count *
(NAME_LEN + 1) + NAME_LEN * 2,
MYF(0))))
{
set_mem_error(mysql);
return NULL;
}

to=3D strxmov(select, "SELECT `", NullS);
while ((row=3D mysql_fetch_row(result)))
{
lengths=3D mysql_fetch_lengths(result);
to+=3D mysql_real_escape_string(mysql, to, row[0], lengths[0]);
to=3D strmov(to, "`,");
}
*(--to)=3D '\0';

to=3D strmov(to, " FROM `");
if (cbCatalog)
{
to+=3D mysql_real_escape_string(mysql, to, (char *)szCatalog, =
cbCatalog);
to=3D strmov(to, "`.`");
}

to+=3D mysql_real_escape_string(mysql, to, (char *)szTable, =
cbTable);
to=3D strmov(to, "` LIMIT 0");
=
------------------------------------------------------------ -------------=
------------------------------------------------------------ -------------=
-----------

I think line 772 must be

strmov(to, "`,`");

------=_NextPart_000_00A5_01C7C9FF.66F03450--
AVL [ Do, 19 Juli 2007 10:21 ] [ ID #1772993 ]

Re: 3.51.17 error 1064 - can't get field metadata due to syntax error in SQL query

This is Bug #29888, and there is a patch for the bug attached. This will
be fixed in 3.51.18.

http://bugs.mysql.com/29888

Jim Winstead
MySQL Inc.

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Jim Winstead [ Fr, 20 Juli 2007 02:56 ] [ ID #1774040 ]
Datenbanken » gmane.comp.db.mysql.odbc » 3.51.17 error 1064 - can't get field metadata due to syntax error in SQL query

Vorheriges Thema: Classic ASP ODBC 3.51 UTF8 problem
Nächstes Thema: UTF-8