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/t/lowercase_table2.test | |
| 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/t/lowercase_table2.test')
| -rw-r--r-- | mysql-test/t/lowercase_table2.test | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/mysql-test/t/lowercase_table2.test b/mysql-test/t/lowercase_table2.test index eff5f2a99ec..51c6f6b5ac3 100644 --- a/mysql-test/t/lowercase_table2.test +++ b/mysql-test/t/lowercase_table2.test @@ -10,7 +10,7 @@ show variables like "lower_case_table_names"; enable_query_log; --disable_warnings -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`; --enable_warnings @@ -128,3 +128,11 @@ create table myUC (i int); select * from myUC; use test; drop database mysqltest_LC2; + +# +# Bug #9500: Problem with WHERE clause +# +create table t2aA (col1 int); +create table t1Aa (col1 int); +select t1Aa.col1 from t1aA,t2Aa where t1Aa.col1 = t2aA.col1; +drop table t2aA, t1Aa; |