EVOLUTION-MANAGER

Edit File: versioning_trx_id.result

connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3; connection node_1; create table t1 (a int, s bigint unsigned as row start, e bigint unsigned as row end, period for system_time(s,e)) engine=InnoDB with system versioning; insert into t1 (a) values (1),(2); connection node_2; insert into t1 (a) values (3),(4); select a from t1; a 1 2 3 4 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0'; count(*) 0 select count(*) from mysql.transaction_registry where begin_timestamp>=commit_timestamp; count(*) 0 connection node_3; insert into t1 (a) values (5),(6); select a from t1; a 1 2 3 4 5 6 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0'; count(*) 0 select count(*) from mysql.transaction_registry where begin_timestamp>=commit_timestamp; count(*) 0 connection node_1; select a from t1; a 1 2 3 4 5 6 select count(*) from mysql.transaction_registry where begin_timestamp='0-0-0'; count(*) 0 select count(*) from mysql.transaction_registry where begin_timestamp>=commit_timestamp; count(*) 0 drop table t1; disconnect node_2; disconnect node_1;