diff options
author | Sergei Golubchik <serg@mariadb.org> | 2019-02-27 03:36:37 +0100 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2019-02-27 23:27:43 -0500 |
commit | 20c89f9f376dfd05a1eef5b2abc136d2f32c277d (patch) | |
tree | 3eb8bdebc9ee6db72f4ac50115f86d483f9cafe5 /mysql-test/main/long_unique_bugs.result | |
parent | 5adf11250ab1c1a3e09a33f55696f6df6507a30f (diff) | |
download | mariadb-git-20c89f9f376dfd05a1eef5b2abc136d2f32c277d.tar.gz |
MDEV-18712 InnoDB indexes are inconsistent with what defined in .frm for table after rebuilding table with index on blob
when auto-adding a virtual LONG_UNIQUE_HASH_FIELD, fill in
a Virtual_column_info for it, so that fill_alter_inplace_info()
would know we're adding a virtual field (ALTER_ADD_VIRTUAL_COLUMN).
Diffstat (limited to 'mysql-test/main/long_unique_bugs.result')
-rw-r--r-- | mysql-test/main/long_unique_bugs.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.result b/mysql-test/main/long_unique_bugs.result index 338b4072516..9a5f35a2e70 100644 --- a/mysql-test/main/long_unique_bugs.result +++ b/mysql-test/main/long_unique_bugs.result @@ -10,3 +10,13 @@ create temporary table tmp (a varchar(1024), b int, c int, d int, e linestring, load data infile 'load.data' into table tmp; delete from tmp; drop table t1; +create table t1 (b blob) engine=innodb; +alter table t1 add unique (b); +alter table t1 force; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `b` blob DEFAULT NULL, + UNIQUE KEY `b` (`b`) USING HASH +) ENGINE=InnoDB DEFAULT CHARSET=latin1 +drop table t1; |