Debian Codegraph @

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

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