diff options
| author | jimw@mysql.com <> | 2005-06-08 14:35:16 -0700 |
|---|---|---|
| committer | jimw@mysql.com <> | 2005-06-08 14:35:16 -0700 |
| commit | 495ee34be0e240947ad42b3809f35ff4797590e7 (patch) | |
| tree | 167537cdfcffd9e103b5cf1e3f1839cf2bdc6f9f /mysql-test/r/lowercase_table2.result | |
| parent | e23f2491878c7dd6c1a3238a99b244f416ebbd9b (diff) | |
| download | mariadb-git-495ee34be0e240947ad42b3809f35ff4797590e7.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)
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; |