diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2018-02-23 20:22:09 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2018-02-24 01:28:51 +0100 |
| commit | 5c7a40e3cf0b9869c7023e2f8c48b7c6e65a87dd (patch) | |
| tree | 8e5845d08af9d54b319d686e5481dc632f359f7e /mysql-test/suite/versioning | |
| parent | fd240a10e3a9726340bc23339d9297f0ad0c680d (diff) | |
| download | mariadb-git-5c7a40e3cf0b9869c7023e2f8c48b7c6e65a87dd.tar.gz | |
MDEV-15330 Server crash or assertion `table->insert_values' failure in write_record upon LOAD DATA
copy the corresponding line from mysql_prepare_insert()
Diffstat (limited to 'mysql-test/suite/versioning')
| -rw-r--r-- | mysql-test/suite/versioning/r/load_data.result | 8 | ||||
| -rw-r--r-- | mysql-test/suite/versioning/t/load_data.test | 12 |
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/r/load_data.result b/mysql-test/suite/versioning/r/load_data.result new file mode 100644 index 00000000000..83d64cee787 --- /dev/null +++ b/mysql-test/suite/versioning/r/load_data.result @@ -0,0 +1,8 @@ +CREATE TABLE t1 (a INT, b INT, c INT, vc INT AS (c), UNIQUE(a), UNIQUE(b)) WITH SYSTEM VERSIONING; +INSERT IGNORE INTO t1 (a,b,c) VALUES (1,2,3); +SELECT a, b, c FROM t1 INTO OUTFILE '15330.data'; +LOAD DATA INFILE '15330.data' IGNORE INTO TABLE t1 (a,b,c); +Warnings: +Warning 1062 Duplicate entry '1-2038-01-19 04:14:07.999999' for key 'a' +LOAD DATA INFILE '15330.data' REPLACE INTO TABLE t1 (a,b,c); +DROP TABLE t1; diff --git a/mysql-test/suite/versioning/t/load_data.test b/mysql-test/suite/versioning/t/load_data.test new file mode 100644 index 00000000000..4db6eee6c4d --- /dev/null +++ b/mysql-test/suite/versioning/t/load_data.test @@ -0,0 +1,12 @@ +# +# MDEV-15330 Server crash or assertion `table->insert_values' failure in write_record upon LOAD DATA +# +CREATE TABLE t1 (a INT, b INT, c INT, vc INT AS (c), UNIQUE(a), UNIQUE(b)) WITH SYSTEM VERSIONING; +INSERT IGNORE INTO t1 (a,b,c) VALUES (1,2,3); + +SELECT a, b, c FROM t1 INTO OUTFILE '15330.data'; +LOAD DATA INFILE '15330.data' IGNORE INTO TABLE t1 (a,b,c); +LOAD DATA INFILE '15330.data' REPLACE INTO TABLE t1 (a,b,c); + +# Cleanup +DROP TABLE t1; |