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