summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning
diff options
context:
space:
mode:
authorEugene Kosov <claprix@yandex.ru>2019-07-26 15:22:31 +0300
committerEugene Kosov <claprix@yandex.ru>2019-07-26 15:22:31 +0300
commit4c7a74396497ae28779016b5bd59283aeee0b6f4 (patch)
tree31c49a23aede628f3afc3999faa290bc522923ad /mysql-test/suite/versioning
parentde9e3930940c44458d254987066a81f1cea9b500 (diff)
parent29df1003d9faf09b635eedf10a0e3196e71bb297 (diff)
downloadmariadb-git-4c7a74396497ae28779016b5bd59283aeee0b6f4.tar.gz
Merge 10.3 into 10.4
Diffstat (limited to 'mysql-test/suite/versioning')
-rw-r--r--mysql-test/suite/versioning/r/truncate.result12
-rw-r--r--mysql-test/suite/versioning/t/truncate.test14
2 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/r/truncate.result b/mysql-test/suite/versioning/r/truncate.result
index c7a90a2e726..802e382137d 100644
--- a/mysql-test/suite/versioning/r/truncate.result
+++ b/mysql-test/suite/versioning/r/truncate.result
@@ -130,5 +130,17 @@ truncate t1;
truncate t2;
ERROR HY000: System-versioned tables do not support TRUNCATE TABLE
unlock tables;
+#
+# MDEV-19814 Assertion `update->n_fields < ulint(table->n_cols + table->n_v_cols)' on DELETE HISTORY
+#
+create or replace table t1 (
+f varchar(1),
+row_start SYS_TYPE as row start,
+row_end SYS_TYPE as row end,
+period for system_time (row_start, row_end))
+with system versioning;
+insert into t1 (f) values ('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h');
+delete from t1;
+delete history from t1;
drop database test;
create database test;
diff --git a/mysql-test/suite/versioning/t/truncate.test b/mysql-test/suite/versioning/t/truncate.test
index 6b727e78e6b..9450ddce125 100644
--- a/mysql-test/suite/versioning/t/truncate.test
+++ b/mysql-test/suite/versioning/t/truncate.test
@@ -145,5 +145,19 @@ truncate t2;
unlock tables;
+--echo #
+--echo # MDEV-19814 Assertion `update->n_fields < ulint(table->n_cols + table->n_v_cols)' on DELETE HISTORY
+--echo #
+--replace_result $sys_datatype_expl SYS_TYPE
+eval create or replace table t1 (
+ f varchar(1),
+ row_start $sys_datatype_expl as row start,
+ row_end $sys_datatype_expl as row end,
+ period for system_time (row_start, row_end))
+with system versioning;
+insert into t1 (f) values ('a'), ('b'), ('c'), ('d'), ('e'), ('f'), ('g'), ('h');
+delete from t1;
+delete history from t1;
+
drop database test;
create database test;