diff options
Diffstat (limited to 'mysql-test/suite/innodb/t/innodb_force_pk.test')
| -rw-r--r-- | mysql-test/suite/innodb/t/innodb_force_pk.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/innodb_force_pk.test b/mysql-test/suite/innodb/t/innodb_force_pk.test index 48986ca2fee..7dcab8eaead 100644 --- a/mysql-test/suite/innodb/t/innodb_force_pk.test +++ b/mysql-test/suite/innodb/t/innodb_force_pk.test @@ -33,6 +33,17 @@ create table t2(a integer) engine=innodb; show warnings; drop table t1; +# +# MDEV-8582: innodb_force_primary_key option does not +# force PK or unique key +# +--error 1173 +create table t1 (i int not null, key(i)) engine=innodb; +create table t1 (i int not null, unique key(i)) engine=innodb; +show warnings; +show create table t1; +drop table t1; + --disable_query_log eval set global innodb_force_primary_key=$force_pk; --enable_query_log |