Debian Codegraph @

mysql-test/suite/galera/t/MDEV-22421.test

raw
1 #
2 # Tables with system versioning should not append keys to wsrep.
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7
8 SET @@local.sql_mode='no_field_options';
9 CREATE TABLE t1 (f1 INT, ROW_START BIGINT UNSIGNED AS ROW START INVISIBLE, ROW_END BIGINT UNSIGNED AS ROW END INVISIBLE, PERIOD FOR SYSTEM_TIME(ROW_START, ROW_END)) WITH SYSTEM VERSIONING ENGINE=InnoDB;
10 INSERT INTO t1 VALUES (1);
11 UPDATE t1 SET f1 = 1 WHERE f1 = 1;
12 DROP TABLE t1;