Bug #81508 Type in meta data for "cast('a' as char(100))" is VAR_STRING

• Submitted: 19 May 2016 13:22
• Modified: 20 May 2016 8:47
• Reporter: Su Dylan
• Status: Verified
• Category: MySQL Server: DML
• Severity: S3 (Non-critical)
• Version: 5.7.8, 5.7.12, 5.6.30
• OS: Any
• CPU Architecture: Any

[19 May 2016 13:22] Su Dylan

Description:
Output:
=====
mysql> select cast('a' as char(100));
Field   1:  `cast('a' as char(100))`
Catalog:    `def`
Database:   ``
Table:      ``
Org_table:  ``
Type:       VAR_STRING
Collation:  ? (45)
Length:     400
Max_length: 1
Decimals:   31
Flags:

+------------------------+
| cast('a' as char(100)) |
+------------------------+
| a                      |
+------------------------+
1 row in set (0.01 sec)

Problem:
=====
STRING is expected.

How to repeat:
select cast('a' as char(100));

Suggested fix:
STRING is expected in meta data for "cast('a' as char(100))".

[20 May 2016 8:47] MySQL Verification Team

Hello Su Dylan,

Thank you for the report and test case.

Thanks,
Umesh

[20 May 2016 8:49] MySQL Verification Team

Also, seen with 5.6.30 build.