diff options
| author | rburnett@build.mysql.com <> | 2004-08-25 17:25:38 +0200 |
|---|---|---|
| committer | rburnett@build.mysql.com <> | 2004-08-25 17:25:38 +0200 |
| commit | 1e0e96a0d2484da14175092e60f3ab119946dd2d (patch) | |
| tree | c33bb978b3813a5add8f2f1e9ad546172594f3e9 /mysql-test/t/lowercase_table.test | |
| parent | 358900236ab52a1021df1cb4d95158c7ee40705a (diff) | |
| download | mariadb-git-1e0e96a0d2484da14175092e60f3ab119946dd2d.tar.gz | |
Test case for Bug #4792 lower_case_table_names does not resolve db.tbl.column in SELECT list
lowercase_table.result:
New results for modified lowercase_table test
lowercase_table.test:
Added test case for all uppercase database when running under lower_case_table_names. This really only failed under Windows. Bug# 4792
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
| -rw-r--r-- | mysql-test/t/lowercase_table.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test index 5bc19f26c0e..d52c60baea7 100644 --- a/mysql-test/t/lowercase_table.test +++ b/mysql-test/t/lowercase_table.test @@ -30,3 +30,14 @@ select count(T1.a) from t1; --error 1109 select count(bags.a) from t1 as Bags; drop table t1; + +# +# Test all caps database name +# +create database foo; +use foo; +create table t1 (a int); +select FOO.t1.* from FOO.t1; +alter table t1 rename to T1; +select FOO.t1.* from FOO.t1; +drop database FOO; |