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