Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.slave_transaction_retry_interval;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 '#--------------------FN_DYNVARS_149_01-------------------------#'
6 SET @@global.slave_transaction_retry_interval = 50;
7 SET @@global.slave_transaction_retry_interval = DEFAULT;
8 SELECT @@global.slave_transaction_retry_interval;
9 @@global.slave_transaction_retry_interval
10 0
11 '#--------------------FN_DYNVARS_149_02-------------------------#'
12 SET @@global.slave_transaction_retry_interval = DEFAULT;
13 SELECT @@global.slave_transaction_retry_interval = 10;
14 @@global.slave_transaction_retry_interval = 10
15 0
16 '#--------------------FN_DYNVARS_149_03-------------------------#'
17 SET @@global.slave_transaction_retry_interval = 0;
18 SELECT @@global.slave_transaction_retry_interval;
19 @@global.slave_transaction_retry_interval
20 0
21 SET @@global.slave_transaction_retry_interval = 1;
22 SELECT @@global.slave_transaction_retry_interval;
23 @@global.slave_transaction_retry_interval
24 1
25 SET @@global.slave_transaction_retry_interval = 15;
26 SELECT @@global.slave_transaction_retry_interval;
27 @@global.slave_transaction_retry_interval
28 15
29 SET @@global.slave_transaction_retry_interval = 1024;
30 SELECT @@global.slave_transaction_retry_interval;
31 @@global.slave_transaction_retry_interval
32 1024
33 SET @@global.slave_transaction_retry_interval = 2147483648;
34 Warnings:
35 Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '2147483648'
36 SELECT @@global.slave_transaction_retry_interval;
37 @@global.slave_transaction_retry_interval
38 3600
39 SET @@global.slave_transaction_retry_interval = 2147483648*2-1;
40 Warnings:
41 Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4294967295'
42 SELECT @@global.slave_transaction_retry_interval;
43 @@global.slave_transaction_retry_interval
44 3600
45 SET @@global.slave_transaction_retry_interval = 2147483649*2;
46 Warnings:
47 Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4294967298'
48 SELECT @@global.slave_transaction_retry_interval;
49 @@global.slave_transaction_retry_interval
50 3600
51 SET @@global.slave_transaction_retry_interval = 4294967295;
52 Warnings:
53 Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4294967295'
54 SELECT @@global.slave_transaction_retry_interval;
55 @@global.slave_transaction_retry_interval
56 3600
57 '#--------------------FN_DYNVARS_149_04-------------------------#'
58 SET @@slave_transaction_retry_interval = 2;
59 ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL
60 SET @@session.slave_transaction_retry_interval = 3;
61 ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL
62 SET @@local.slave_transaction_retry_interval = 4;
63 ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL
64 '#------------------FN_DYNVARS_149_05-----------------------#'
65 SET @@global.slave_transaction_retry_interval = -1;
66 Warnings:
67 Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '-1'
68 SELECT @@global.slave_transaction_retry_interval;
69 @@global.slave_transaction_retry_interval
70 0
71 SET @@global.slave_transaction_retry_interval = 2147483649*2147483649;
72 Warnings:
73 Warning 1292 Truncated incorrect slave_transaction_retry_interval value: '4611686022722355201'
74 SELECT @@global.slave_transaction_retry_interval;
75 @@global.slave_transaction_retry_interval
76 3600
77 SET @@global.slave_transaction_retry_interval = 65530.34;
78 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval'
79 SET @@global.slave_transaction_retry_interval = '100';
80 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval'
81 SET @@global.slave_transaction_retry_interval = 7483649.56;
82 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval'
83 SET @@global.slave_transaction_retry_interval = ON;
84 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval'
85 SET @@global.slave_transaction_retry_interval = OFF;
86 ERROR 42000: Incorrect argument type to variable 'slave_transaction_retry_interval'
87 '#------------------FN_DYNVARS_149_06-----------------------#'
88 SET @@global.slave_transaction_retry_interval = 3000;
89 SELECT @@global.slave_transaction_retry_interval = VARIABLE_VALUE
90 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
91 WHERE VARIABLE_NAME='slave_transaction_retry_interval';
92 @@global.slave_transaction_retry_interval = VARIABLE_VALUE
93 1
94 '#------------------FN_DYNVARS_149_07-----------------------#'
95 SELECT count(VARIABLE_VALUE)
96 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
97 WHERE VARIABLE_NAME='slave_transaction_retry_interval';
98 count(VARIABLE_VALUE)
99 1
100 '#------------------FN_DYNVARS_149_08-----------------------#'
101 SET @@global.slave_transaction_retry_interval = TRUE;
102 SELECT @@global.slave_transaction_retry_interval;
103 @@global.slave_transaction_retry_interval
104 1
105 SET @@global.slave_transaction_retry_interval = FALSE;
106 SELECT @@global.slave_transaction_retry_interval;
107 @@global.slave_transaction_retry_interval
108 0
109 '#---------------------FN_DYNVARS_149_09----------------------#'
110 SET @@global.slave_transaction_retry_interval = 60*60;
111 SELECT @@slave_transaction_retry_interval = @@global.slave_transaction_retry_interval;
112 @@slave_transaction_retry_interval = @@global.slave_transaction_retry_interval
113 1
114 '#---------------------FN_DYNVARS_149_10----------------------#'
115 SET slave_transaction_retry_interval = 2048;
116 ERROR HY000: Variable 'slave_transaction_retry_interval' is a GLOBAL variable and should be set with SET GLOBAL
117 SELECT slave_transaction_retry_interval;
118 ERROR 42S22: Unknown column 'slave_transaction_retry_interval' in 'SELECT'
119 SELECT @@slave_transaction_retry_interval;
120 @@slave_transaction_retry_interval
121 3600
122 SET global slave_transaction_retry_interval = 99;
123 SET @@global.slave_transaction_retry_interval = @start_global_value;
124 SELECT @@global.slave_transaction_retry_interval;
125 @@global.slave_transaction_retry_interval
126 0