Debian Codegraph @

mysql-test/suite/sys_vars/r/binlog_transaction_dependency_tracking_basic.result

raw
1 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
2 Warnings:
3 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
4 SET GLOBAL transaction_write_set_extraction= 'XXHASH64';
5 Warnings:
6 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
7 SELECT COUNT(@@GLOBAL.binlog_transaction_dependency_tracking);
8 COUNT(@@GLOBAL.binlog_transaction_dependency_tracking)
9 1
10 Warnings:
11 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
12 SELECT COUNT(@@SESSION.binlog_transaction_dependency_tracking);
13 ERROR HY000: Variable 'binlog_transaction_dependency_tracking' is a GLOBAL variable
14 SELECT VARIABLE_NAME FROM performance_schema.global_variables WHERE VARIABLE_NAME='binlog_transaction_dependency_tracking';
15 VARIABLE_NAME
16 binlog_transaction_dependency_tracking
17 SELECT VARIABLE_NAME FROM performance_schema.session_variables WHERE variable_name='binlog_transaction_dependency_tracking';
18 VARIABLE_NAME
19 binlog_transaction_dependency_tracking
20 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
21 Warnings:
22 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
23 include/assert.inc ['binlog_transaction_dependency_tracking is a dynamic variable']
24 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
25 Warnings:
26 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
27 include/assert.inc ['binlog_transaction_dependency_tracking should be COMMIT_ORDER']
28 SET GLOBAL binlog_transaction_dependency_tracking= 0;
29 Warnings:
30 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
31 include/assert.inc ['binlog_transaction_dependency_tracking should be COMMIT_ORDER']
32 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET';
33 Warnings:
34 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
35 include/assert.inc ['binlog_transaction_dependency_tracking should be WRITESET']
36 SET GLOBAL binlog_transaction_dependency_tracking= 1;
37 Warnings:
38 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
39 include/assert.inc ['binlog_transaction_dependency_tracking should be WRITESET']
40 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET_SESSION';
41 Warnings:
42 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
43 include/assert.inc ['binlog_transaction_dependency_tracking should be WRITESET_SESSION']
44 SET GLOBAL binlog_transaction_dependency_tracking= 2;
45 Warnings:
46 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
47 include/assert.inc ['binlog_transaction_dependency_tracking should be WRITESET_SESSION']
48 SET GLOBAL binlog_transaction_dependency_tracking= DEFAULT;
49 Warnings:
50 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
51 include/assert.inc ['binlog_transaction_dependency_tracking should be COMMIT_ORDER']
52 SET GLOBAL binlog_transaction_dependency_tracking= NULL;
53 ERROR 42000: Variable 'binlog_transaction_dependency_tracking' can't be set to the value of 'NULL'
54 SET GLOBAL binlog_transaction_dependency_tracking= '';
55 ERROR 42000: Variable 'binlog_transaction_dependency_tracking' can't be set to the value of ''
56 SET GLOBAL binlog_transaction_dependency_tracking= 1.0;
57 ERROR 42000: Incorrect argument type to variable 'binlog_transaction_dependency_tracking'
58 SET GLOBAL binlog_transaction_dependency_tracking= 'GARBAGE';
59 ERROR 42000: Variable 'binlog_transaction_dependency_tracking' can't be set to the value of 'GARBAGE'
60 SET GLOBAL binlog_transaction_dependency_tracking= ON;
61 ERROR 42000: Variable 'binlog_transaction_dependency_tracking' can't be set to the value of 'ON'
62 SET GLOBAL binlog_transaction_dependency_tracking= OFF;
63 ERROR 42000: Variable 'binlog_transaction_dependency_tracking' can't be set to the value of 'OFF'
64 SET GLOBAL binlog_transaction_dependency_tracking= 3;
65 ERROR 42000: Variable 'binlog_transaction_dependency_tracking' can't be set to the value of '3'
66 Expect value still set to "COMMIT_ORDER"
67 SELECT @@global.binlog_transaction_dependency_tracking;
68 @@global.binlog_transaction_dependency_tracking
69 COMMIT_ORDER
70 Warnings:
71 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
72 Case1 a): "When binlog_transaction_dependency_tracking != COMMIT_ORDER,
73 transaction_write_set_extraction cannot be changed."
74 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET';
75 Warnings:
76 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
77 SET GLOBAL transaction_write_set_extraction= OFF;
78 ERROR HY000: Incorrect usage of transaction_write_set_extraction (changed) and binlog_transaction_dependency_tracking (!= COMMIT_ORDER)
79 SET GLOBAL transaction_write_set_extraction= MURMUR32;
80 ERROR HY000: Incorrect usage of transaction_write_set_extraction (changed) and binlog_transaction_dependency_tracking (!= COMMIT_ORDER)
81 Expect value still set to XXHASH64
82 SELECT @@global.transaction_write_set_extraction;
83 @@global.transaction_write_set_extraction
84 XXHASH64
85 Warnings:
86 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
87 Case1 b): "When binlog_transaction_dependency_tracking != COMMIT_ORDER,
88 transaction_write_set_extraction cannot be changed."
89 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET_SESSION';
90 Warnings:
91 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
92 SET GLOBAL transaction_write_set_extraction= OFF;
93 ERROR HY000: Incorrect usage of transaction_write_set_extraction (changed) and binlog_transaction_dependency_tracking (!= COMMIT_ORDER)
94 SET GLOBAL transaction_write_set_extraction= MURMUR32;
95 ERROR HY000: Incorrect usage of transaction_write_set_extraction (changed) and binlog_transaction_dependency_tracking (!= COMMIT_ORDER)
96 Expect value still set to XXHASH64
97 SELECT @@global.transaction_write_set_extraction;
98 @@global.transaction_write_set_extraction
99 XXHASH64
100 Warnings:
101 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
102 Case2: "When transaction_write_set_extraction = OFF,
103 binlog_transaction_dependency_tracking cannot be set to WRITESET%"
104 SET GLOBAL binlog_transaction_dependency_tracking= 'COMMIT_ORDER';
105 Warnings:
106 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
107 SET GLOBAL transaction_write_set_extraction= OFF;
108 Warnings:
109 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
110 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET';
111 ERROR HY000: Incorrect usage of binlog_transaction_dependency_tracking (!= COMMIT_ORDER) and transaction_write_set_extraction (= OFF)
112 SET GLOBAL binlog_transaction_dependency_tracking= 'WRITESET_SESSION';
113 ERROR HY000: Incorrect usage of binlog_transaction_dependency_tracking (!= COMMIT_ORDER) and transaction_write_set_extraction (= OFF)
114 Expect value still set to COMMIT_ORDER
115 SELECT @@global.binlog_transaction_dependency_tracking;
116 @@global.binlog_transaction_dependency_tracking
117 COMMIT_ORDER
118 Warnings:
119 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
120 SET GLOBAL transaction_write_set_extraction= XXHASH64;
121 Warnings:
122 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.
123 Warnings:
124 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
125 Warnings:
126 Warning 1287 '@@transaction_write_set_extraction' is deprecated and will be removed in a future release.