diff options
author | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2006-06-06 11:25:31 +0500 |
---|---|---|
committer | unknown <gluh@eagle.intranet.mysql.r18.ru> | 2006-06-06 11:25:31 +0500 |
commit | 6c431a5ecdd3f1f94de650217877b9c9b2d9a7ac (patch) | |
tree | 064a35299004f4444c304c020aa29bc9c73d04a2 /mysql-test/r/lowercase_table2.result | |
parent | 6a46bf820d3cef208d4bd5986def30a967bd7710 (diff) | |
download | mariadb-git-6c431a5ecdd3f1f94de650217877b9c9b2d9a7ac.tar.gz |
Bug#17661 information_schema.SCHEMATA returns uppercase with lower_case_table_names = 1
fix: return db name for I_S.TABLES(and others) in original letter case.
if mysql starts with lower_case_table_names=1 | 2 then original db name is converted
to lower case(for I_S tables). It happens when we perform add_table_to_list.
to avoid this we make a copy of original db name and use the copy hereafter.
mysql-test/r/lowercase_table2.result:
Bug#17661 information_schema.SCHEMATA returns uppercase with lower_case_table_names = 1
test case
mysql-test/t/lowercase_table2.test:
Bug#17661 information_schema.SCHEMATA returns uppercase with lower_case_table_names = 1
test case
Diffstat (limited to 'mysql-test/r/lowercase_table2.result')
-rw-r--r-- | mysql-test/r/lowercase_table2.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/lowercase_table2.result b/mysql-test/r/lowercase_table2.result index 44235cbf900..e369fb7e482 100644 --- a/mysql-test/r/lowercase_table2.result +++ b/mysql-test/r/lowercase_table2.result @@ -165,3 +165,12 @@ create table t1Aa (col1 int); select t1Aa.col1 from t1aA,t2Aa where t1Aa.col1 = t2aA.col1; col1 drop table t2aA, t1Aa; +create database mysqltest_LC2; +use mysqltest_LC2; +create table myUC (i int); +select TABLE_SCHEMA,TABLE_NAME FROM information_schema.TABLES +where TABLE_SCHEMA ='mysqltest_LC2'; +TABLE_SCHEMA TABLE_NAME +mysqltest_LC2 myUC +use test; +drop database mysqltest_LC2; |