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?

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.