summaryrefslogtreecommitdiff
path: root/mysql-test/r/innodb_icp.result
diff options
context:
space:
mode:
authorunknown <sanja@askmonty.org>2013-09-20 22:30:19 +0300
committerunknown <sanja@askmonty.org>2013-09-20 22:30:19 +0300
commit192bafe526b42fc92e6549cf752b01bd17bf2c70 (patch)
tree5aa0f19154b9a01a42a084afc9161acf4b459d34 /mysql-test/r/innodb_icp.result
parentc9f0792c2904988efb1a421dcd174b0bf9f3c0e4 (diff)
downloadmariadb-git-192bafe526b42fc92e6549cf752b01bd17bf2c70.tar.gz
Check for duplicate index (port from mysql)
(pre fts)
Diffstat (limited to 'mysql-test/r/innodb_icp.result')
-rw-r--r--mysql-test/r/innodb_icp.result3
1 files changed, 3 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_icp.result b/mysql-test/r/innodb_icp.result
index 07c75986392..5e9e6d647f8 100644
--- a/mysql-test/r/innodb_icp.result
+++ b/mysql-test/r/innodb_icp.result
@@ -711,6 +711,9 @@ a INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
b INT, c INT, d DATE NOT NULL, e VARCHAR(1),
KEY (c), KEY (d), KEY k2(b), KEY k3(b), KEY k4(b)
);
+Warnings:
+Note 1831 Duplicate index 'k3' defined on the table 'test.t1'. This is deprecated and will be disallowed in a future release.
+Note 1831 Duplicate index 'k4' defined on the table 'test.t1'. This is deprecated and will be disallowed in a future release.
INSERT INTO t1 (b,c,d,e) VALUES
(6,5,'2006-05-25','y'),(1,5,'2008-01-23','t'),
(6,5,'2007-06-18','d'),(4,5,'1900-01-01','r'),