Debian Codegraph @

mysql-test/suite/ndb_binlog/r/log_trans_dependency_off.result

raw
1 #
2 # Check default behaviour of logical clock timestamps in binlog generated
3 # by ndb_binlog thread. The timestamps will indicate that each epoch
4 # transaction depends on the previous.
5 #
6 # Test requires that transaction dependency calculations are turned off
7 # for the ndb_binlog thread
8 select @@global.ndb_log_transaction_dependency;
9 @@global.ndb_log_transaction_dependency
10 0
11 # Test assumes that COMMIT_ORDER is used for dependency tracking (this
12 # is the default setting for MySQL Server)
13 select @@binlog_transaction_dependency_tracking;
14 @@binlog_transaction_dependency_tracking
15 COMMIT_ORDER
16 Warnings:
17 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
18 CREATE TABLE t1 (
19 a INT PRIMARY KEY
20 ) engine=ndb;
21 include/include/assert_logical_timestamps.inc [0 1]
22 INSERT INTO t1 VALUES (1);
23 # Wait for changes to be injected, then check timestamps
24 # Wait for ndb_binlog thread...
25 include/include/assert_logical_timestamps.inc [1 2]
26 INSERT INTO t1 VALUES (2);
27 # Wait for changes to be injected, then check timestamps
28 # Wait for ndb_binlog thread...
29 include/include/assert_logical_timestamps.inc [2 3]
30 CREATE TABLE t2 (
31 a INT PRIMARY KEY
32 ) engine=ndb;
33 BEGIN;
34 INSERT INTO t1 VALUES (3);
35 INSERT INTO t2 VALUES (23);
36 COMMIT;
37 # Wait for changes to be injected, then check timestamps
38 # Wait for ndb_binlog thread...
39 include/include/assert_logical_timestamps.inc [4 5]
40 # Create new binlog, timestamps will start over
41 FLUSH LOGS;
42 INSERT INTO t1 VALUES (4);
43 # Wait for changes to be injected, then check timestamps
44 # Wait for ndb_binlog thread...
45 include/include/assert_logical_timestamps.inc [0 1]
46 BEGIN;
47 INSERT INTO t1 VALUES (5);
48 INSERT INTO t2 VALUES (25);
49 COMMIT;
50 # Wait for changes to be injected, then check timestamps
51 # Wait for ndb_binlog thread...
52 include/include/assert_logical_timestamps.inc [1 2]
53 # Cleanup
54 DROP TABLE t1;
55 DROP TABLE t2;