diff options
| author | Aleksey Midenkov <midenok@gmail.com> | 2019-07-23 13:27:57 +0300 |
|---|---|---|
| committer | Aleksey Midenkov <midenok@gmail.com> | 2019-07-25 21:11:15 +0300 |
| commit | f6d0d309fa4ffe1d5890c09447d947103143a68a (patch) | |
| tree | 8d097090d1b507ea51b90fb72de4f34cab2ee1f6 /mysql-test | |
| parent | 1a73444d577ee54ac3ecf752e8436091e932d212 (diff) | |
| download | mariadb-git-f6d0d309fa4ffe1d5890c09447d947103143a68a.tar.gz | |
MDEV-19814 Assertion `update->n_fields < ulint(table->n_cols + table->n_v_cols)' on DELETE HISTORY
Turn off versioned_write for DELETE HISTORY.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/suite/versioning/r/truncate.result | 12 | ||||
| -rw-r--r-- | mysql-test/suite/versioning/t/truncate.test | 14 |
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 d38b9eed162..fa38ec96368 100644 --- a/mysql-test/suite/versioning/r/truncate.result +++ b/mysql-test/suite/versioning/r/truncate.result @@ -106,5 +106,17 @@ call pr; call pr; drop procedure pr; drop table t1; +# +# 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 1727c7787ef..0f4800efd0b 100644 --- a/mysql-test/suite/versioning/t/truncate.test +++ b/mysql-test/suite/versioning/t/truncate.test @@ -117,5 +117,19 @@ call pr; drop procedure pr; drop table t1; +--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; |