| 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: | |
| 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 |
[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?
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)