MySQL Bugs: #54171: SQLColumns does not return value for column comment

Bug #54171	SQLColumns does not return value for column comment
Submitted:	2 Jun 2010 8:24	Modified:	2 Jun 2010 9:04
Reporter:	maria yuin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	5.01.06.00	OS:	Windows
Assigned to:		CPU Architecture:	Any
Tags:	column comment, ODBC, SQLColumns

Description:
I have a COMMENT defined on a table column.  When I make a SQLColumns call on the table and try to retrieve the information on the column, the "commend" or Remark as MSDN calls it, is returned as an empty string.  How do I retrieve the comment defined on a table column?

How to repeat:
Create a table with a column with a comment.
By using a program, make a SQLColumns on the table and retrieve the column information.
Notice that the "remark" information is an empty string.

Hi Maria and thanks for your report.

The patch is already pushed into 3.51 branch (and will be pushed in 5.1 too soon) as a part of fix for Bug#31067.

Ah, one more comment; fix for Bug#31067 will deal with this only for MySQL server versions that have I__S. It is not possible to implement this properly for older server versions (i.e. no I__S).

Hi - it's not clear to me how the bug 31067 is related to the issue I reported about getting column description. Could you please elaborate?

Also, I didn't understand what you meant by server version I_S.  Could you confirm that this is an issue on the server side and not ODBC driver?  And what do you mean by version I_S?  Thanks.

Maria

Maria,

You are absolutely correct - bugs are not related. But the patch for Bug#31067 also contains new version of SQLColumns exploiting I_S. And it will fix the problem you reported too.