mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
eb26e20df5
Updates to transaction registry table shouldn't be replicated in cluster so there is no need to append wsrep keys. Reviewed-by: Jan Lindström <jan.lindstrom@mariadb.com>
12 lines
461 B
Text
12 lines
461 B
Text
#
|
|
# Tables with system versioning should not append keys to wsrep.
|
|
#
|
|
|
|
--source include/galera_cluster.inc
|
|
--source include/have_innodb.inc
|
|
|
|
SET @@local.sql_mode='no_field_options';
|
|
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;
|
|
INSERT INTO t1 VALUES (1);
|
|
UPDATE t1 SET f1 = 1 WHERE f1 = 1;
|
|
DROP TABLE t1;
|