summaryrefslogtreecommitdiff
path: root/mysql-test/t/lowercase_table.test
diff options
context:
space:
mode:
authormonty@narttu.mysql.fi <>2003-06-01 12:32:53 +0300
committermonty@narttu.mysql.fi <>2003-06-01 12:32:53 +0300
commit02adbe659991af851a51c225059011a20d5cd47c (patch)
tree5524062586f42802c3aab500a005cf3dc593b2a1 /mysql-test/t/lowercase_table.test
parent889db1aa5ef099136ae0954ac35bb73ffe5b5226 (diff)
downloadmariadb-git-02adbe659991af851a51c225059011a20d5cd47c.tar.gz
Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED. Bug #478
Diffstat (limited to 'mysql-test/t/lowercase_table.test')
-rw-r--r--mysql-test/t/lowercase_table.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/lowercase_table.test b/mysql-test/t/lowercase_table.test
index 0d04e6c7df7..b3453dfd3c4 100644
--- a/mysql-test/t/lowercase_table.test
+++ b/mysql-test/t/lowercase_table.test
@@ -12,3 +12,14 @@ ALTER TABLE T2 RENAME T3;
show tables like 't_';
drop table t3;
+#
+# Test alias
+#
+create table t1 (a int);
+select count(*) from T1;
+select count(*) from t1;
+--error 1109
+select count(T1.a) from t1;
+--error 1109
+select count(bags.a) from t1 as Bags;
+drop table t1;