summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb/r/innodb_mysql.result
diff options
context:
space:
mode:
authorMichael Widenius <monty@askmonty.org>2011-02-22 11:15:47 +0200
committerMichael Widenius <monty@askmonty.org>2011-02-22 11:15:47 +0200
commit97c1ef96ca01a4eaad310e16bc512936f6859a8e (patch)
treee305bc182a35eaf41802e4cc51a61bfd5bde5cd2 /mysql-test/suite/innodb/r/innodb_mysql.result
parent646dc6e3aa4a4f945c0d243bf607dc919e1f5eb2 (diff)
parent50d1833c5f992338ab8a3f95e8a0e1abec06f402 (diff)
downloadmariadb-git-97c1ef96ca01a4eaad310e16bc512936f6859a8e.tar.gz
Merge in new handler and handlersocket code into 5.3 main
Diffstat (limited to 'mysql-test/suite/innodb/r/innodb_mysql.result')
-rw-r--r--mysql-test/suite/innodb/r/innodb_mysql.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_mysql.result b/mysql-test/suite/innodb/r/innodb_mysql.result
index 8f876294039..fd9f794a8c0 100644
--- a/mysql-test/suite/innodb/r/innodb_mysql.result
+++ b/mysql-test/suite/innodb/r/innodb_mysql.result
@@ -2617,6 +2617,14 @@ ref NULL
rows 3
Extra Using index
DROP TABLE t1;
+#
+# ALTER TABLE IGNORE didn't ignore duplicates for unique add index
+#
+create table t1 (a int primary key, b int) engine = innodb;
+insert into t1 values (1,1),(2,1);
+alter ignore table t1 add unique `main` (b);
+drop table t1;
+#
End of 5.1 tests
#
# Test for bug #39932 "create table fails if column for FK is in different