diff options
| author | serg@serg.mylan <> | 2004-11-22 21:33:15 +0100 |
|---|---|---|
| committer | serg@serg.mylan <> | 2004-11-22 21:33:15 +0100 |
| commit | ee933cd1986fcbe14eb37cf732e92fe3692a7461 (patch) | |
| tree | 9fd3b9eb87ff64ffe7e7374609beb327e419a87d /mysql-test/t/key.test | |
| parent | 55575bea2ed86b3f16297c6a0aa8540133aea963 (diff) | |
| parent | 2ca5a0f2b17b02c13711d5f45ff75c52a23e4fb3 (diff) | |
| download | mariadb-git-ee933cd1986fcbe14eb37cf732e92fe3692a7461.tar.gz | |
merged
Diffstat (limited to 'mysql-test/t/key.test')
| -rw-r--r-- | mysql-test/t/key.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/key.test b/mysql-test/t/key.test index 0a86c1cd145..af3509c8454 100644 --- a/mysql-test/t/key.test +++ b/mysql-test/t/key.test @@ -301,3 +301,26 @@ drop table t1; --error 1391 create table t1 (c char(10), index (c(0))); + +# +# Bug #6126: Duplicate columns in keys should fail +# Bug #6252: (dup) +# +--error 1060 +create table t1 (c char(10), index (c,c)); +--error 1060 +create table t1 (c1 char(10), c2 char(10), index (c1,c2,c1)); +--error 1060 +create table t1 (c1 char(10), c2 char(10), index (c1,c1,c2)); +--error 1060 +create table t1 (c1 char(10), c2 char(10), index (c2,c1,c1)); +create table t1 (c1 char(10), c2 char(10)); +--error 1060 +alter table t1 add key (c1,c1); +--error 1060 +alter table t1 add key (c2,c1,c1); +--error 1060 +alter table t1 add key (c1,c2,c1); +--error 1060 +alter table t1 add key (c1,c1,c2); +drop table t1; |