diff options
| author | unknown <sanja@askmonty.org> | 2013-09-20 22:30:19 +0300 |
|---|---|---|
| committer | unknown <sanja@askmonty.org> | 2013-09-20 22:30:19 +0300 |
| commit | 192bafe526b42fc92e6549cf752b01bd17bf2c70 (patch) | |
| tree | 5aa0f19154b9a01a42a084afc9161acf4b459d34 /mysql-test/r/constraints.result | |
| parent | c9f0792c2904988efb1a421dcd174b0bf9f3c0e4 (diff) | |
| download | mariadb-git-192bafe526b42fc92e6549cf752b01bd17bf2c70.tar.gz | |
Check for duplicate index (port from mysql)
(pre fts)
Diffstat (limited to 'mysql-test/r/constraints.result')
| -rw-r--r-- | mysql-test/r/constraints.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/constraints.result b/mysql-test/r/constraints.result index 3821a18b072..3bec2c3e16d 100644 --- a/mysql-test/r/constraints.result +++ b/mysql-test/r/constraints.result @@ -17,7 +17,11 @@ drop table t1; create table t1 (a int null); alter table t1 add constraint constraint_1 unique (a); alter table t1 add constraint unique key_1(a); +Warnings: +Note 1831 Duplicate index 'key_1' defined on the table 'test.t1'. This is deprecated and will be disallowed in a future release. alter table t1 add constraint constraint_2 unique key_2(a); +Warnings: +Note 1831 Duplicate index 'key_2' defined on the table 'test.t1'. This is deprecated and will be disallowed in a future release. show create table t1; Table Create Table t1 CREATE TABLE `t1` ( |