Bug #94235 MySQL Connector 8 uses depreciated 'COM_FIELD_LIST’
Submitted: 7 Feb 2019 9:50 Modified: 13 Mar 2019 0:24
Reporter: Ross Beer Email Updates:
Status: Verified Impact on me:
None 
Category:Connector / ODBC Severity:S5 (Performance)
Version:8 OS:Linux
Assigned to: CPU Architecture:Any

[7 Feb 2019 9:50] Ross Beer
Description:
MySQL Connector 8 uses the depreciated 'COM_FIELD_LIST' which leads to the following error on some servers:

[ODBC][72496][1549465961.691261][SQLColumns.c][215]
      Entry:
      Statement = 0x2b96b40594c0
      Catalog Name = [NULL]
      Schema Name = [NULL]
      Table Name = [table1][length = 11 (SQL_NTS)]
      Column Name = [%][length = 1 (SQL_NTS)]
[ODBC][72496][1549465961.692184][SQLColumns.c][426]
      Exit:[SQL_ERROR]
      DIAG [HY000] [MySQL][ODBC 5.3(w) Driver][mysqld-5.5.62]Command not supported

How to repeat:
When using ProxySQL to load balance MySQL Server instances an error is thrown due to the use of the depreciated 'COM_FIELD_LIST’ in the MySQL ODBC Connector

Suggested fix:
As per the following link, alternate methods of getting column data should be used:

https://dev.mysql.com/doc/internals/en/com-field-list.html
[13 Mar 2019 0:24] Miguel Solorzano
Thank you for the bug report.

https://dev.mysql.com/worklog/task/?id=8754