diff options
| author | unknown <jimw@mysql.com> | 2005-06-08 14:35:16 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-06-08 14:35:16 -0700 |
| commit | c23ef5e1f301c7184ba4c66352569402012d2569 (patch) | |
| tree | 167537cdfcffd9e103b5cf1e3f1839cf2bdc6f9f /mysql-test/r/lowercase_table2.result | |
| parent | 777899a6f568105ab6242516300acd937a9785ec (diff) | |
| download | mariadb-git-c23ef5e1f301c7184ba4c66352569402012d2569.tar.gz | |
Fix problem with handling of lower_case_table_name == 2 when
the case in the FROM and WHERE clauses didn't agree. (Bug #9500)
mysql-test/r/lowercase_table2.result:
Update results
mysql-test/t/lowercase_table2.test:
Fix 'DROP TABLE' to not drop tables with the same name.
sql/mysqld.cc:
Move initialization of table_alias_charset to after we
have decided what lower_case_table_names should be.
Diffstat (limited to 'mysql-test/r/lowercase_table2.result')
| -rw-r--r-- | mysql-test/r/lowercase_table2.result | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/mysql-test/r/lowercase_table2.result b/mysql-test/r/lowercase_table2.result index 1015990df9a..db833bcd970 100644 --- a/mysql-test/r/lowercase_table2.result +++ b/mysql-test/r/lowercase_table2.result @@ -1,4 +1,4 @@ -DROP TABLE IF EXISTS t1,t2,T1,T2,t3,T3; +DROP TABLE IF EXISTS t1,t2,t3; DROP DATABASE IF EXISTS `TEST_$1`; DROP DATABASE IF EXISTS `test_$1`; CREATE TABLE T1 (a int); @@ -159,3 +159,8 @@ select * from myUC; i use test; drop database mysqltest_LC2; +create table t2aA (col1 int); +create table t1Aa (col1 int); +select t1Aa.col1 from t1aA,t2Aa where t1Aa.col1 = t2aA.col1; +col1 +drop table t2aA, t1Aa; |