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/long_unique_bugs.result | |
| 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/long_unique_bugs.result')
| -rw-r--r-- | mysql-test/main/long_unique_bugs.result | 17 |
1 files changed, 17 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; |