Bug #29303 Metadata of user variables varies between 5.0 and 5.1

• Submitted: 22 Jun 2007 14:39
• Modified: 13 Jul 2007 21:01
• Reporter: Andrey Hristov
• Status: Won't fix
• Category: MySQL Server: General
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any
• Tags: bfsm_2007_06_28

[22 Jun 2007 14:39] Andrey Hristov

Description:
Type is VAR_STRING in 5.0.46 and LONG_BLOB in 5.1.20

Server version: 5.0.46-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set @dummy="value";
Query OK, 0 rows affected (0.00 sec)

mysql> select @dummy;
Field   1:  `@dummy`
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       VAR_STRING
Collation:  latin1_swedish_ci (8)
Length:     8192
Max_length: 5
Decimals:   31
Flags:

--------------------------------
Server version: 5.1.20-beta-valgrind-max-debug-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> set @dummy="value";
Query OK, 0 rows affected (0.00 sec)

mysql> select @dummy;
Field   1:  `@dummy`
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       LONG_BLOB
Collation:  latin1_swedish_ci (8)
Length:     16777216
Max_length: 5
Decimals:   31
Flags:

How to repeat:
> mysql --column-type-info

set @dummy = "abc";
selecy @dummy

[22 Jun 2007 14:44] MySQL Verification Team

Thank you for the bug report.