Bug #74146 | querying the new data dictionary is case sensitive | ||
---|---|---|---|
Submitted: | 30 Sep 2014 0:19 | Modified: | 18 May 2016 18:07 |
Reporter: | Giuseppe Maxia (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S2 (Serious) |
Version: | 5.7.5 DD labs | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | data dictionary, usability |
[30 Sep 2014 0:19]
Giuseppe Maxia
[30 Sep 2014 8:13]
MySQL Verification Team
Hello Giuseppe Maxia, Thank you for the report and test case. Thanks, Umesh
[30 Sep 2014 8:14]
MySQL Verification Team
// 5.7.5-labs-dd mysql> show variables like '%version%'; +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ | innodb_version | 5.7.5 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.7.5-labs-dd-log | | version_comment | MySQL Community Server (GPL) | | version_compile_machine | x86_64 | | version_compile_os | linux-el6 | +-------------------------+------------------------------+ 7 rows in set (0.00 sec) mysql> select count(*) from information_schema . tables where engine='innodb'; +----------+ | count(*) | +----------+ | 0 | +----------+ 1 row in set (0.01 sec) mysql> select count(*) from information_schema . tables where engine='InnoDB'; +----------+ | count(*) | +----------+ | 42 | +----------+ 1 row in set (0.01 sec) // 5.7.6-m16-enterprise-commercial-advanced mysql> show variables like '%version%'; +-------------------------+---------------------------------------------------------+ | Variable_name | Value | +-------------------------+---------------------------------------------------------+ | innodb_version | 5.7.6 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.7.6-m16-enterprise-commercial-advanced | | version_comment | MySQL Enterprise Server - Advanced Edition (Commercial) | | version_compile_machine | x86_64 | | version_compile_os | Linux | +-------------------------+---------------------------------------------------------+ 7 rows in set (0.00 sec) mysql> select count(*) from information_schema . tables where engine='innodb'; +----------+ | count(*) | +----------+ | 19 | +----------+ 1 row in set (0.01 sec) mysql> select count(*) from information_schema . tables where engine='InnoDB'; +----------+ | count(*) | +----------+ | 19 | +----------+ 1 row in set (0.01 sec)
[18 May 2016 18:07]
Erlend Dahl
Recently fixed in 5.8.0.