diff options
| author | unknown <monty@narttu.mysql.fi> | 2003-06-01 12:33:23 +0300 |
|---|---|---|
| committer | unknown <monty@narttu.mysql.fi> | 2003-06-01 12:33:23 +0300 |
| commit | 2d23d49b1fb6e8f785ab01499ec1ad9f0f862d64 (patch) | |
| tree | a6f16cbb413442bde18b58b4b8fdf69e4fed56a1 /mysql-test/t | |
| parent | 91f1d5991306ebd7869eaa3a3489913f7c0298a4 (diff) | |
| parent | 2ef52d46a4f5b0c34bee26b0f70d672b6ee9325e (diff) | |
| download | mariadb-git-2d23d49b1fb6e8f785ab01499ec1ad9f0f862d64.tar.gz | |
Merge bk-internal.mysql.com:/home/bk/mysql-4.0
into narttu.mysql.fi:/my/mysql-4.0
sql/mysql_priv.h:
Auto merged
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/alter_table.test | 9 | ||||
| -rw-r--r-- | mysql-test/t/lowercase_table.test | 11 |
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 96f969c8776..a3ab62afc69 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -133,3 +133,12 @@ analyze table t1; show keys from t1; drop table t1; +# +# Test of ALTER TABLE DELAYED +# + +CREATE TABLE t1 (i int(10), index(i) ); +ALTER TABLE t1 DISABLE KEYS; +INSERT DELAYED INTO t1 VALUES(1),(2),(3); +ALTER TABLE t1 ENABLE KEYS; +drop table t1; 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; |