diff options
| author | Michael Widenius <monty@askmonty.org> | 2011-01-05 15:09:06 +0200 |
|---|---|---|
| committer | Michael Widenius <monty@askmonty.org> | 2011-01-05 15:09:06 +0200 |
| commit | ab32ce9aa7fb09b2fb578e5bb44f004092bf1d89 (patch) | |
| tree | a794e234b9474b9eb7d2f445aa5d59ab9814f32d /mysql-test/suite | |
| parent | 711b36732b6913c189e1075441c7c9bd8ef529da (diff) | |
| download | mariadb-git-ab32ce9aa7fb09b2fb578e5bb44f004092bf1d89.tar.gz | |
ALTER TABLE IGNORE didn't ignore duplicates for unique add index for InnoDB
Diffstat (limited to 'mysql-test/suite')
| -rw-r--r-- | mysql-test/suite/innodb/r/innodb_mysql.result | 7 | ||||
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb_mysql.test | 9 |
2 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/r/innodb_mysql.result b/mysql-test/suite/innodb/r/innodb_mysql.result index 86a51b337ff..08fb0bdfe2e 100644 --- a/mysql-test/suite/innodb/r/innodb_mysql.result +++ b/mysql-test/suite/innodb/r/innodb_mysql.result @@ -2617,6 +2617,13 @@ 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 diff --git a/mysql-test/suite/innodb/t/innodb_mysql.test b/mysql-test/suite/innodb/t/innodb_mysql.test index 991440e54dd..177dabdc3e1 100644 --- a/mysql-test/suite/innodb/t/innodb_mysql.test +++ b/mysql-test/suite/innodb/t/innodb_mysql.test @@ -841,6 +841,15 @@ CREATE INDEX b ON t1(a,b,c,d); DROP TABLE t1; --echo # +--echo # ALTER TABLE IGNORE didn't ignore duplicates for unique add index +--echo # + +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; + +--echo # --echo End of 5.1 tests |