Debian Codegraph @

mysql-test/suite/galera/t/galera_commit_empty.test

raw
1 # Test empty transactions.
2 #
3 # Check that the empty transaction gets terminated by starting and new
4 # transaction after it. If the empty transaction is not terminated
5 # appropriately, the following START TRANSACTION will fail.
6 #
7 # Also check that empty transactions don't generate any write sets.
8 #
9
10 --source include/galera_cluster.inc
11 --source include/have_innodb.inc
12
13 --let $wsrep_last_committed_before = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
14
15 START TRANSACTION;
16 COMMIT;
17
18 START TRANSACTION;
19 COMMIT;
20
21 START TRANSACTION READ ONLY;
22 COMMIT;
23
24 START TRANSACTION;
25 COMMIT;
26
27 START TRANSACTION;
28 START TRANSACTION;
29 COMMIT;
30
31 --let $wsrep_last_committed_after = `SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_STATUS WHERE VARIABLE_NAME = 'wsrep_last_committed'`
32
33 --disable_query_log
34 --eval SELECT $wsrep_last_committed_after = $wsrep_last_committed_before AS wsrep_last_committed_diff
35 --enable_query_log