Bug #34023 Views: column name length = 0 if binary non-latin
Submitted: 23 Jan 2008 23:07 Modified: 25 Jan 2008 12:17
Reporter: Peter Gulutzan
Status: Verified
Category: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: Evgeny Potemkin Target Version:
Triage: Triaged: D2 (Serious) / R3 (Medium) / E3 (Medium)

[23 Jan 2008 23: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 12:17] Sveta Smirnova 
Thank you for the report.

Verified as described.