summaryrefslogtreecommitdiff
path: root/mysql-test/r/lowercase_table2.result
diff options
context:
space:
mode:
authorunknown <gluh@eagle.intranet.mysql.r18.ru>2006-06-06 11:25:31 +0500
committerunknown <gluh@eagle.intranet.mysql.r18.ru>2006-06-06 11:25:31 +0500
commit6c431a5ecdd3f1f94de650217877b9c9b2d9a7ac (patch)
tree064a35299004f4444c304c020aa29bc9c73d04a2 /mysql-test/r/lowercase_table2.result
parent6a46bf820d3cef208d4bd5986def30a967bd7710 (diff)
downloadmariadb-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.result9
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;