diff options
| author | monty@hundin.mysql.fi <> | 2002-01-02 21:29:41 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-01-02 21:29:41 +0200 |
| commit | 4b877e0088e6f32a606ffaa0fb3c94afb0b24388 (patch) | |
| tree | ef8afaf7a0fed42b30ef0d9d38acccc992b5f87d /mysql-test/t/key.test | |
| parent | 5b77e3391050f1f585ab28816ad31761d93e8264 (diff) | |
| download | mariadb-git-4b877e0088e6f32a606ffaa0fb3c94afb0b24388.tar.gz | |
Added macros for nice TIMESPEC usage.
Fixes for building MySQL with gcc 3.0
Added SIGNED / UNSIGNED casts
Fixed core dump bug in net_clear() with libmysqld.
Back to using semaphores in query cache.
Added 'Null' and 'Index_type' to SHOW INDEX.
Diffstat (limited to 'mysql-test/t/key.test')
| -rw-r--r-- | mysql-test/t/key.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/key.test b/mysql-test/t/key.test index a8417fad876..6fc975a1cb3 100644 --- a/mysql-test/t/key.test +++ b/mysql-test/t/key.test @@ -160,3 +160,11 @@ SELECT * FROM t1 WHERE a='a' AND b=2; SELECT * FROM t1 WHERE a='a' AND b in (2); SELECT * FROM t1 WHERE a='a' AND b in (1,2); drop table t1; + +# +# Test of create key order +# + +create table t1 (a int not null unique, b int unique, c int, d int not null primary key, key(c), e int not null unique); +show keys from t1; +drop table t1; |