diff options
author | sachin <sachin.setiya@mariadb.com> | 2019-03-04 14:48:11 +0530 |
---|---|---|
committer | sachinsetia1001@gmail.com <sachinsetia1001@gmail.com> | 2019-03-13 15:15:13 +0530 |
commit | 62bfb2fe492f2eb789476ce4517113d2f18be2c6 (patch) | |
tree | 1472614ab0498fa113a0958e589bb6f100e1bcfb /mysql-test/main | |
parent | ecf323620b7aa7b2fb50225d210244a9b675f90e (diff) | |
download | mariadb-git-62bfb2fe492f2eb789476ce4517113d2f18be2c6.tar.gz |
MDEV-18800 Server crash in instant_alter_column_possible or Assertion...
`!pk->has_virtual()' failed in instant_alter_column_possible upon adding key
Hash key can't be primary key.
Diffstat (limited to 'mysql-test/main')
-rw-r--r-- | mysql-test/main/long_unique_bugs.result | 17 | ||||
-rw-r--r-- | mysql-test/main/long_unique_bugs.test | 9 |
2 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.result b/mysql-test/main/long_unique_bugs.result index ec0105bccb5..b787683440f 100644 --- a/mysql-test/main/long_unique_bugs.result +++ b/mysql-test/main/long_unique_bugs.result @@ -112,3 +112,20 @@ ERROR 42000: Can't DROP COLUMN `x`; check that it exists SELECT * FROM t1 WHERE f LIKE 'foo'; f DROP TABLE t1; +CREATE TABLE t1 (pk INT, PRIMARY KEY USING HASH (pk)) ENGINE=InnoDB; +show keys from t1;; +Table t1 +Non_unique 0 +Key_name PRIMARY +Seq_in_index 1 +Column_name pk +Collation A +Cardinality 0 +Sub_part NULL +Packed NULL +Null +Index_type BTREE +Comment +Index_comment +ALTER TABLE t1 ADD INDEX (pk); +DROP TABLE t1; diff --git a/mysql-test/main/long_unique_bugs.test b/mysql-test/main/long_unique_bugs.test index a3cf60c17f6..5b4fcc5b09f 100644 --- a/mysql-test/main/long_unique_bugs.test +++ b/mysql-test/main/long_unique_bugs.test @@ -141,3 +141,12 @@ CREATE TABLE t1 (f VARCHAR(4096), UNIQUE(f)) ENGINE=InnoDB; ALTER TABLE t1 DROP x; SELECT * FROM t1 WHERE f LIKE 'foo'; DROP TABLE t1; + +# +# MDEV-18800 Server crash in instant_alter_column_possible or +# Assertion `!pk->has_virtual()' failed in instant_alter_column_possible upon adding key +# +CREATE TABLE t1 (pk INT, PRIMARY KEY USING HASH (pk)) ENGINE=InnoDB; +--query_vertical show keys from t1; +ALTER TABLE t1 ADD INDEX (pk); +DROP TABLE t1; |