summaryrefslogtreecommitdiff
path: root/mysql-test/main/create.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/main/create.result')
-rw-r--r--mysql-test/main/create.result4
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/main/create.result b/mysql-test/main/create.result
index ea9014498e0..d8e9272e930 100644
--- a/mysql-test/main/create.result
+++ b/mysql-test/main/create.result
@@ -2008,3 +2008,7 @@ create table t1 (i int, j int, key(i), key(i)) as select 1 as i, 2 as j;
Warnings:
Note 1831 Duplicate index `i_2`. This is deprecated and will be disallowed in a future release
drop table t1;
+CREATE TABLE t1 ( id1 INT, id2 INT, CONSTRAINT `foo` PRIMARY KEY (id1), CONSTRAINT `bar` UNIQUE KEY(id2));
+Warnings:
+Warning 1280 Name 'foo' ignored for PRIMARY key.
+DROP TABLE t1;