diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-06-01 12:32:53 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-06-01 12:32:53 +0300 |
| commit | 2ef52d46a4f5b0c34bee26b0f70d672b6ee9325e (patch) | |
| tree | 5524062586f42802c3aab500a005cf3dc593b2a1 /mysql-test/t/lowercase_table.test | |
| parent | dbdcae8bef9092979a84ff490bb2eb791b5366fc (diff) | |
| download | mariadb-git-2ef52d46a4f5b0c34bee26b0f70d672b6ee9325e.tar.gz | |
Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED. Bug #478
mysql-test/r/alter_table.result:
new results
mysql-test/r/lowercase_table.result:
new results
mysql-test/t/alter_table.test:
Test of ALTER TABLE DISABLE KEYS + INSERT DELAYED
mysql-test/t/lowercase_table.test:
Added test of alias name comparison
sql/mysql_priv.h:
Made closed_cached_table local
sql/sql_table.cc:
Fixed bug in ALTER TABLE DISABLE KEYS and INSERT DELAYED
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 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; |