diff options
author | Sachin <sachin.setiya@mariadb.com> | 2019-03-19 16:40:23 +0530 |
---|---|---|
committer | Sachin <sachin.setiya@mariadb.com> | 2019-03-22 11:50:09 +0530 |
commit | c23d4700e6d9ea4f32eda6965ffc907fa83425e8 (patch) | |
tree | ff500e324a9167393eb37d89acd59a679178fd39 /mysql-test/main | |
parent | 625aa232a62b29309108d1fde1d582fdedc9ad77 (diff) | |
download | mariadb-git-c23d4700e6d9ea4f32eda6965ffc907fa83425e8.tar.gz |
MDEV-18901 Wrong results after ADD UNIQUE INDEX(blob_column)
Add test case for MDEV-18901 as MDEV-18967 and MDEV-18922 solves this issue
Diffstat (limited to 'mysql-test/main')
-rw-r--r-- | mysql-test/main/long_unique_bugs.result | 24 | ||||
-rw-r--r-- | mysql-test/main/long_unique_bugs.test | 22 |
2 files changed, 46 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.result b/mysql-test/main/long_unique_bugs.result index a96cac09bc1..1cbb7134783 100644 --- a/mysql-test/main/long_unique_bugs.result +++ b/mysql-test/main/long_unique_bugs.result @@ -195,3 +195,27 @@ select * from t1; data A DROP TABLE t1; +CREATE TABLE t1 (data VARCHAR(7961)) ENGINE=InnoDB; +INSERT INTO t1 VALUES ('f'), ('o'), ('o'); +SELECT * INTO OUTFILE 'load.data' from t1; +ALTER IGNORE TABLE t1 ADD UNIQUE INDEX (data); +SELECT * FROM t1; +data +f +o +ALTER TABLE t1 ADD SYSTEM VERSIONING ; +SELECT * FROM t1; +data +f +o +REPLACE INTO t1 VALUES ('f'), ('o'), ('o'); +SELECT * FROM t1; +data +f +o +LOAD DATA INFILE 'load.data' REPLACE INTO TABLE t1; +SELECT * FROM t1; +data +f +o +DROP TABLE t1; diff --git a/mysql-test/main/long_unique_bugs.test b/mysql-test/main/long_unique_bugs.test index 910e1e8b436..b75190e615f 100644 --- a/mysql-test/main/long_unique_bugs.test +++ b/mysql-test/main/long_unique_bugs.test @@ -228,3 +228,25 @@ select * from t1; DROP TABLE t1; --let $datadir= `select @@datadir` --remove_file $datadir/test/load.data + +# +# MDEV-18901 Wrong results after ADD UNIQUE INDEX(blob_column) +# +--source include/have_innodb.inc +CREATE TABLE t1 (data VARCHAR(7961)) ENGINE=InnoDB; + +INSERT INTO t1 VALUES ('f'), ('o'), ('o'); +SELECT * INTO OUTFILE 'load.data' from t1; + +ALTER IGNORE TABLE t1 ADD UNIQUE INDEX (data); +SELECT * FROM t1; +ALTER TABLE t1 ADD SYSTEM VERSIONING ; +SELECT * FROM t1; +REPLACE INTO t1 VALUES ('f'), ('o'), ('o'); +SELECT * FROM t1; +# This should be equivalent to the REPLACE above +LOAD DATA INFILE 'load.data' REPLACE INTO TABLE t1; +SELECT * FROM t1; +DROP TABLE t1; +--let $datadir= `select @@datadir` +--remove_file $datadir/test/load.data |