From f9f625fb431129cd72655ea90bf90fddbf05e3c5 Mon Sep 17 00:00:00 2001 From: sachin Date: Sun, 3 Mar 2019 16:35:13 +0530 Subject: MDEV-18790 Server crash in fields_in_hash_keyinfo after unsuccessful... attempt to drop BLOB with long index Restore long table->key_info, So that in the case of unsuccessful table alter table->key_info should have a correct value. In the case of successful table alter old table is flushed so that is why we don't see this error in the case of successful alter. --- mysql-test/main/long_unique_bugs.result | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'mysql-test/main/long_unique_bugs.result') diff --git a/mysql-test/main/long_unique_bugs.result b/mysql-test/main/long_unique_bugs.result index 5de7566c8a3..716c343f9c4 100644 --- a/mysql-test/main/long_unique_bugs.result +++ b/mysql-test/main/long_unique_bugs.result @@ -57,3 +57,9 @@ create table t (b blob, unique(b)) engine=myisam; insert into t values ('foo'); replace into t values ('foo'); drop table t; +CREATE TABLE t1 (f INT, x BLOB, UNIQUE (x)); +INSERT INTO t1 VALUES (1,'foo'); +ALTER TABLE t1 DROP x, ALGORITHM=INPLACE; +ERROR 0A000: ALGORITHM=INPLACE is not supported for this operation. Try ALGORITHM=COPY +UPDATE t1 SET x = 'bar'; +DROP TABLE t1; -- cgit v1.2.1