Bug #14492 DESCRIBE reports wrong field_type in libMySQL.dll
Submitted: 30 Oct 2005 19:31 Modified: 8 Nov 2005 14:13
Reporter: MySQL-Front Team Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:5.0.15 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[30 Oct 2005 19:31] MySQL-Front Team 
Description:
DESCRIBE `mysql`.`user`;

libMySQL.dll reports for the column `Type` as field_type MYSQL_TYPE_BLOB.

CREATE TABLE `test` (
  `test_field` varbinary(65000) default NULL
) ENGINE=MyISAM;

SELECT `test_field` FROM `test`;

libMySQL.dll reports for the column `test_field` as field_type MYSQL_TYPE_VAR_STRING.

Why is this different? I think it should be the same...

How to repeat:
DESCRIBE `mysql`.`user`;

CREATE TABLE `test` (
  `test_field` varbinary(65000) default NULL
) ENGINE=MyISAM;

SELECT `test_field` FROM `test`;
[8 Nov 2005 14:12] MySQL-Front Team 
The developers are not interessed about our bug messages.
[8 Nov 2005 14:13] MySQL-Front Team 
The developers are not interessed about our bug messages.