diff options
author | gluh@eagle.intranet.mysql.r18.ru <> | 2006-06-06 11:25:31 +0500 |
---|---|---|
committer | gluh@eagle.intranet.mysql.r18.ru <> | 2006-06-06 11:25:31 +0500 |
commit | 03d8717ac8d0d2638df76a51228050ad79a17ec8 (patch) | |
tree | 064a35299004f4444c304c020aa29bc9c73d04a2 /mysql-test/r/lowercase_table2.result | |
parent | 194c447b1b183a2823e1cb28cfd9a563aa83c5c2 (diff) | |
download | mariadb-git-03d8717ac8d0d2638df76a51228050ad79a17ec8.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.
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; |