diff options
author | Eugene Kosov <claprix@yandex.ru> | 2019-07-26 15:22:31 +0300 |
---|---|---|
committer | Eugene Kosov <claprix@yandex.ru> | 2019-07-26 15:22:31 +0300 |
commit | 4c7a74396497ae28779016b5bd59283aeee0b6f4 (patch) | |
tree | 31c49a23aede628f3afc3999faa290bc522923ad /mysql-test/suite/versioning | |
parent | de9e3930940c44458d254987066a81f1cea9b500 (diff) | |
parent | 29df1003d9faf09b635eedf10a0e3196e71bb297 (diff) | |
download | mariadb-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.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 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; |