diff options
| author | sachin <sachin.setiya@mariadb.com> | 2019-03-03 16:35:13 +0530 |
|---|---|---|
| committer | sachinsetia1001@gmail.com <sachinsetia1001@gmail.com> | 2019-03-13 13:59:31 +0530 |
| commit | f9f625fb431129cd72655ea90bf90fddbf05e3c5 (patch) | |
| tree | 17ce8109734a23ebf2da12bde10eb899bd30438a /mysql-test/main/long_unique_bugs.test | |
| parent | 3568427d11f7afcd111b4c28c14cc8aba2b10807 (diff) | |
| download | mariadb-git-f9f625fb431129cd72655ea90bf90fddbf05e3c5.tar.gz | |
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.
Diffstat (limited to 'mysql-test/main/long_unique_bugs.test')
| -rw-r--r-- | mysql-test/main/long_unique_bugs.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.test b/mysql-test/main/long_unique_bugs.test index 0246ea7962a..05a9bf83aa4 100644 --- a/mysql-test/main/long_unique_bugs.test +++ b/mysql-test/main/long_unique_bugs.test @@ -72,3 +72,13 @@ create table t (b blob, unique(b)) engine=myisam; insert into t values ('foo'); replace into t values ('foo'); drop table t; + +# +# MDEV-18790 Server crash in fields_in_hash_keyinfo after unsuccessful attempt to drop BLOB with long index +# +CREATE TABLE t1 (f INT, x BLOB, UNIQUE (x)); +INSERT INTO t1 VALUES (1,'foo'); +--error ER_ALTER_OPERATION_NOT_SUPPORTED +ALTER TABLE t1 DROP x, ALGORITHM=INPLACE; +UPDATE t1 SET x = 'bar'; +DROP TABLE t1; |