diff options
author | Sachin <sachin.setiya@mariadb.com> | 2019-03-19 16:36:54 +0530 |
---|---|---|
committer | Sachin <sachin.setiya@mariadb.com> | 2019-03-21 21:24:59 +0530 |
commit | 625aa232a62b29309108d1fde1d582fdedc9ad77 (patch) | |
tree | 201a0d23ff6c5e40b6cbf12d614f7a9ff6f68cb9 /mysql-test/main | |
parent | 1dffa9d9c18b3d9b3cf16f3aa63c4ec3d157326b (diff) | |
download | mariadb-git-625aa232a62b29309108d1fde1d582fdedc9ad77.tar.gz |
MDEV-18967 Load data in system version with long unique does not work
Update system versioning fields before generated columns for left out
fill_record
Diffstat (limited to 'mysql-test/main')
-rw-r--r-- | mysql-test/main/long_unique_bugs.result | 9 | ||||
-rw-r--r-- | mysql-test/main/long_unique_bugs.test | 13 |
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/main/long_unique_bugs.result b/mysql-test/main/long_unique_bugs.result index b3a1076804b..a96cac09bc1 100644 --- a/mysql-test/main/long_unique_bugs.result +++ b/mysql-test/main/long_unique_bugs.result @@ -186,3 +186,12 @@ c varchar(5000), UNIQUE(c,b(64)) ) ENGINE=InnoDB; drop table t1; +CREATE TABLE t1 (data VARCHAR(4), unique(data) using hash) with system versioning; +INSERT INTO t1 VALUES ('A'); +SELECT * INTO OUTFILE 'load.data' from t1; +LOAD DATA INFILE 'load.data' INTO TABLE t1; +ERROR 23000: Duplicate entry 'A' for key 'data' +select * from t1; +data +A +DROP TABLE t1; diff --git a/mysql-test/main/long_unique_bugs.test b/mysql-test/main/long_unique_bugs.test index 6257111b3fb..910e1e8b436 100644 --- a/mysql-test/main/long_unique_bugs.test +++ b/mysql-test/main/long_unique_bugs.test @@ -215,3 +215,16 @@ CREATE TABLE t1 ( UNIQUE(c,b(64)) ) ENGINE=InnoDB; drop table t1; + +# +# MDEV-18967 Load data in system version with long unique does not work +# +CREATE TABLE t1 (data VARCHAR(4), unique(data) using hash) with system versioning; +INSERT INTO t1 VALUES ('A'); +SELECT * INTO OUTFILE 'load.data' from t1; +--error ER_DUP_ENTRY +LOAD DATA INFILE 'load.data' INTO TABLE t1; +select * from t1; +DROP TABLE t1; +--let $datadir= `select @@datadir` +--remove_file $datadir/test/load.data |