Bug #34023 Views: column name length = 0 if binary non-latin
Submitted: 23 Jan 2008 22:07 Modified: 25 Jan 2008 11:17
Reporter: Peter Gulutzan Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Views Severity:S3 (Non-critical)
Version:5.0, 5.1 BK,6.0.5-alpha-debug OS:Linux (SUSE 10 / 64-bit)
Assigned to: Assigned Account CPU Architecture:Any

[23 Jan 2008 22:07] Peter Gulutzan
Description:
I create a view with a select list that:
contains _binary
contains string literals with non-latin1 characters
contains no AS clauses.

I look at information_schema.columns, and see
that the first column name for this view is ''.

How to repeat:
mysql> CREATE VIEW v1 AS SELECT _binary 'привет', _binary 'привет';
Query OK, 0 rows affected (0.00 sec)

mysql> select length(column_name) from information_schema.columns
    -> where table_name = 'v1';
+---------------------+
| length(column_name) |
+---------------------+
|                   0 |
|                   7 |
+---------------------+
2 rows in set (0.01 sec)
[25 Jan 2008 11:17] Sveta Smirnova
Thank you for the report.

Verified as described.
[23 Jan 2019 18:46] Hartmut Holzgraefe
I can reproduce this with 5.0, but it already seems to have been fixed since 5.1, and so should be closed for good at this point?