diff options
| author | unknown <jimw@mysql.com> | 2005-06-10 14:44:25 -0700 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-06-10 14:44:25 -0700 |
| commit | 0670a02ca207d96d9723913d5bd2c5cb7df4e0ae (patch) | |
| tree | 8d94691e37c5c4424cc5aef96eda807472c98ccf /mysql-test | |
| parent | 41bb9bf94bfd5f13cc6af306283c2bf826b8fc7f (diff) | |
| parent | c23ef5e1f301c7184ba4c66352569402012d2569 (diff) | |
| download | mariadb-git-0670a02ca207d96d9723913d5bd2c5cb7df4e0ae.tar.gz | |
Merge mysql.com:/home/jimw/my/mysql-4.1-9500
into mysql.com:/home/jimw/my/mysql-4.1-clean
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/lowercase_table2.result | 7 | ||||
| -rw-r--r-- | mysql-test/t/lowercase_table2.test | 10 |
2 files changed, 15 insertions, 2 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; 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; |