summaryrefslogtreecommitdiff
path: root/mysql-test/main/long_unique_bugs.test
diff options
context:
space:
mode:
authorsachin <sachin.setiya@mariadb.com>2019-03-04 14:48:11 +0530
committersachinsetia1001@gmail.com <sachinsetia1001@gmail.com>2019-03-13 15:15:13 +0530
commit62bfb2fe492f2eb789476ce4517113d2f18be2c6 (patch)
tree1472614ab0498fa113a0958e589bb6f100e1bcfb /mysql-test/main/long_unique_bugs.test
parentecf323620b7aa7b2fb50225d210244a9b675f90e (diff)
downloadmariadb-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/long_unique_bugs.test')
-rw-r--r--mysql-test/main/long_unique_bugs.test9
1 files changed, 9 insertions, 0 deletions
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;