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