MySQL Bugs: #10436: Need updated error message for VARBINARY->BLOB change

Bug #10436	Need updated error message for VARBINARY->BLOB change
Submitted:	7 May 2005 15:10	Modified:	13 May 2005 16:49
Reporter:	Trudy Pelzer	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:		OS:
Assigned to:	Jim Winstead	CPU Architecture:	Any

Description:
See bug#8296.

When I try to create a table with a VARBINARY column greater
than 65535, the server changes the data type to BLOB and
generates this warning:
ERROR 1246 Converting column '<column name>' from VARCHAR to BLOB

The correct text for the error message is:
Converting column '<column name>' from VARBINARY to BLOB

How to repeat:
mysql> create table t1 (col1 varbinary(65536));
Query OK, 0 rows affected, 1 warning (0.01 sec)

mysql> show warnings;
+-------+------+-----------------------------------------------+
| Level | Code | Message                                       |
+-------+------+-----------------------------------------------+
| Note  | 1246 | Converting column 'col1' from VARCHAR to BLOB |
+-------+------+-----------------------------------------------+
1 row in set (0.00 sec)
-- The error text should reflect that the change is from VARBINARY
rather than from VARCHAR

Verified on 5.0 BK source Linux.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/24684

This was already fixed by another patch by Ramil.