diff options
author | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2021-11-07 04:41:35 +0530 |
---|---|---|
committer | Thirunarayanan Balathandayuthapani <thiru@mariadb.com> | 2021-11-07 04:41:35 +0530 |
commit | 8c9cc2fb6eb2b3841dc34b40d6e936a322268148 (patch) | |
tree | 8fdd1726b933d81d07ca7bfcdc60785bc5c7bfab /mysql-test/suite/innodb/t/insert_into_empty.test | |
parent | d20de4d447c70512f915fca6d78b9a77bbaeb4c7 (diff) | |
download | mariadb-git-8c9cc2fb6eb2b3841dc34b40d6e936a322268148.tar.gz |
MDEV-26956 LeakSanitizer/Valgrind errors in trx_mod_table_time_t::start_bulk_insert upon adding system versioningbb-10.7-MDEV-26956
InnoDB fails to apply buffered insert operation for
'mysql/transaction_registry' table during system versioning DDL.
To avoid this, DDL calls extra(HA_EXTRA_IGNORE_INSERT) to
inform the InnoDB for applying the buffered insert operation.
Diffstat (limited to 'mysql-test/suite/innodb/t/insert_into_empty.test')
-rw-r--r-- | mysql-test/suite/innodb/t/insert_into_empty.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb/t/insert_into_empty.test b/mysql-test/suite/innodb/t/insert_into_empty.test index cfd79f05f6c..7719ae68d7b 100644 --- a/mysql-test/suite/innodb/t/insert_into_empty.test +++ b/mysql-test/suite/innodb/t/insert_into_empty.test @@ -221,3 +221,15 @@ SELECT * FROM t; DELETE FROM t; COMMIT; DROP TABLE t; + +--echo # +--echo # MDEV-26956 LeakSanitizer/Valgrind errors in +--echo # trx_mod_table_time_t::start_bulk_insert +--echo # upon adding system versioning +--echo # +CREATE TABLE t1(id INT, s DATE, e DATE, PERIOD FOR p(s,e), + PRIMARY KEY(id, p WITHOUT OVERLAPS)) ENGINE=InnoDB; +ALTER TABLE t1 ADD COLUMN row_start BIGINT UNSIGNED AS ROW START, + ADD COLUMN row_end BIGINT UNSIGNED AS ROW END, + ADD PERIOD FOR SYSTEM_TIME(row_start,row_end), WITH SYSTEM VERSIONING; +DROP TABLE t1; |