diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2019-07-30 21:57:48 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2019-07-30 21:57:48 +0400 |
| commit | c6efbc543d6fb3004f320ef9d02542a4692ca88a (patch) | |
| tree | 4a2df43eb04ddcbf30878add945cb0577f4121aa /mysql-test/main/create.test | |
| parent | 4b5a14d0fe3d6945a0a9516261f563dcfd1f2c9c (diff) | |
| download | mariadb-git-c6efbc543d6fb3004f320ef9d02542a4692ca88a.tar.gz | |
MDEV-17544 No warning when trying to name a primary key constraint.
Warning added.
Diffstat (limited to 'mysql-test/main/create.test')
| -rw-r--r-- | mysql-test/main/create.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/main/create.test b/mysql-test/main/create.test index af5c427852c..9cd3d9909f0 100644 --- a/mysql-test/main/create.test +++ b/mysql-test/main/create.test @@ -1941,3 +1941,10 @@ create table t1; # create table t1 (i int, j int, key(i), key(i)) as select 1 as i, 2 as j; drop table t1; + +# +# MDEV-17544 No warning when trying to name a primary key constraint. +# +CREATE TABLE t1 ( id1 INT, id2 INT, CONSTRAINT `foo` PRIMARY KEY (id1), CONSTRAINT `bar` UNIQUE KEY(id2)); +DROP TABLE t1; + |