Debian Codegraph @

mysql-test/suite/sys_vars/t/binlog_transaction_dependency_tracking_basic.test

raw
1 ###############################################################################
2 # Variable Name: binlog_transaction_dependency_tracking
3 # Scope: global
4 # Access Type: dynamic
5 # Data Type: enum
6 #
7 # Description: Test Cases of Dynamic System Variable
8 # "binlog_transaction_dependency_history_size" that checks
9 # behavior of this variable in the following ways
10 # * Scope & Access type
11 # * Valid & Default value
12 # * Invalid values
13 # * Dependency on transaction_write_set_extraction
14 #
15 # Reference: WL#9556
16 ###############################################################################
17
18 --source include/have_binlog_format_row.inc
19
20 # Save initial value
21 --let $saved_binlog_transaction_dependency_tracking= `SELECT @@global.binlog_transaction_dependency_tracking`
22 --let $saved_transaction_write_set_extraction= `SELECT @@global.transaction_write_set_extraction`
23
24 # Set initial values to test further
25 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
26 SET GLOBAL transaction_write_set_extraction= 'XXHASH64';
27
28 #
29 # Scope: Global only
30 #
31 SELECT COUNT(@@GLOBAL.binlog_transaction_dependency_tracking);
32
33 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
34 SELECT COUNT(@@SESSION.binlog_transaction_dependency_tracking);
35
36 --disable_warnings
37 SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_transaction_dependency_tracking';
38 SELECT VARIABLE_NAME FROM performance_schema.session_variables WHERE variable_name='binlog_transaction_dependency_tracking';
39 --enable_warnings
40
41 #
42 # Access Type: Dynamic
43 #
44 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
45 --let $assert_text= 'binlog_transaction_dependency_tracking is a dynamic variable'
46 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "COMMIT_ORDER"
47 --source include/assert.inc
48
49 #
50 # Valid values and Default value
51 #
52 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
53 --let $assert_text= 'binlog_transaction_dependency_tracking should be COMMIT_ORDER'
54 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "COMMIT_ORDER"
55 --source include/assert.inc
56
57 SET GLOBAL binlog_transaction_dependency_tracking= 0;
58 --let $assert_text= 'binlog_transaction_dependency_tracking should be COMMIT_ORDER'
59 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "COMMIT_ORDER"
60 --source include/assert.inc
61
62 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET';
63 --let $assert_text= 'binlog_transaction_dependency_tracking should be WRITESET'
64 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET"
65 --source include/assert.inc
66
67 SET GLOBAL binlog_transaction_dependency_tracking= 1;
68 --let $assert_text= 'binlog_transaction_dependency_tracking should be WRITESET'
69 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET"
70 --source include/assert.inc
71
72 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET_SESSION';
73 --let $assert_text= 'binlog_transaction_dependency_tracking should be WRITESET_SESSION'
74 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET_SESSION"
75 --source include/assert.inc
76
77 SET GLOBAL binlog_transaction_dependency_tracking= 2;
78 --let $assert_text= 'binlog_transaction_dependency_tracking should be WRITESET_SESSION'
79 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "WRITESET_SESSION"
80 --source include/assert.inc
81
82 SET GLOBAL binlog_transaction_dependency_tracking= DEFAULT;
83 --let $assert_text= 'binlog_transaction_dependency_tracking should be COMMIT_ORDER'
84 --let $assert_cond= "[SELECT @@GLOBAL.binlog_transaction_dependency_tracking]" = "COMMIT_ORDER"
85 --source include/assert.inc
86
87 #
88 # Invalid values
89 #
90 --error ER_WRONG_VALUE_FOR_VAR
91 SET GLOBAL binlog_transaction_dependency_tracking= NULL;
92
93 --error ER_WRONG_VALUE_FOR_VAR
94 SET GLOBAL binlog_transaction_dependency_tracking= '';
95
96 --error ER_WRONG_TYPE_FOR_VAR
97 SET GLOBAL binlog_transaction_dependency_tracking= 1.0;
98
99 --error ER_WRONG_VALUE_FOR_VAR
100 SET GLOBAL binlog_transaction_dependency_tracking= 'GARBAGE';
101
102 --error ER_WRONG_VALUE_FOR_VAR
103 SET GLOBAL binlog_transaction_dependency_tracking= ON;
104
105 --error ER_WRONG_VALUE_FOR_VAR
106 SET GLOBAL binlog_transaction_dependency_tracking= OFF;
107
108 --error ER_WRONG_VALUE_FOR_VAR
109 SET GLOBAL binlog_transaction_dependency_tracking= 3;
110
111 --echo Expect value still set to "COMMIT_ORDER"
112 SELECT @@global.binlog_transaction_dependency_tracking;
113
114 #
115 # Test usage: Dependency on transaction_write_set_extraction
116 #
117 --echo Case1 a): "When binlog_transaction_dependency_tracking != COMMIT_ORDER,
118 --echo transaction_write_set_extraction cannot be changed."
119 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET';
120 --error ER_WRONG_USAGE
121 SET GLOBAL transaction_write_set_extraction= OFF;
122 --error ER_WRONG_USAGE
123 SET GLOBAL transaction_write_set_extraction= MURMUR32;
124 --echo Expect value still set to XXHASH64
125 SELECT @@global.transaction_write_set_extraction;
126
127 --echo Case1 b): "When binlog_transaction_dependency_tracking != COMMIT_ORDER,
128 --echo transaction_write_set_extraction cannot be changed."
129 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET_SESSION';
130 --error ER_WRONG_USAGE
131 SET GLOBAL transaction_write_set_extraction= OFF;
132 --error ER_WRONG_USAGE
133 SET GLOBAL transaction_write_set_extraction= MURMUR32;
134 --echo Expect value still set to XXHASH64
135 SELECT @@global.transaction_write_set_extraction;
136
137 --echo Case2: "When transaction_write_set_extraction = OFF,
138 --echo binlog_transaction_dependency_tracking cannot be set to WRITESET%"
139 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
140 SET GLOBAL transaction_write_set_extraction= OFF;
141 --error ER_WRONG_USAGE
142 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET';
143 --error ER_WRONG_USAGE
144 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET_SESSION';
145 --echo Expect value still set to COMMIT_ORDER
146 SELECT @@global.binlog_transaction_dependency_tracking;
147
148 SET GLOBAL transaction_write_set_extraction= XXHASH64;
149
150 # Clean up
151 --disable_query_log
152 --eval SET GLOBAL binlog_transaction_dependency_tracking= '$saved_binlog_transaction_dependency_tracking';
153 --eval SET GLOBAL transaction_write_set_extraction= '$saved_transaction_write_set_extraction';
154 --enable_query_log