Debian Codegraph @

mysql-test/suite/sys_vars/r/replica_transaction_retries_basic_64.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 SET @@global.replica_transaction_retries = 18446744073709551615;
43 SELECT @@global.replica_transaction_retries;
44 @@global.replica_transaction_retries
45 18446744073709551615
46 '#--------------------FN_DYNVARS_149_04-------------------------#'
47 SET @@replica_transaction_retries = 2;
48 ERROR HY000: Variable 'replica_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
49 SET @@session.replica_transaction_retries = 3;
50 ERROR HY000: Variable 'replica_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
51 SET @@local.replica_transaction_retries = 4;
52 ERROR HY000: Variable 'replica_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
53 '#------------------FN_DYNVARS_149_05-----------------------#'
54 SET @@global.replica_transaction_retries = -1;
55 Warnings:
56 Warning 1292 Truncated incorrect replica_transaction_retries value: '-1'
57 SELECT @@global.replica_transaction_retries;
58 @@global.replica_transaction_retries
59 0
60 SET @@global.replica_transaction_retries = 65530.34;
61 ERROR 42000: Incorrect argument type to variable 'replica_transaction_retries'
62 SET @@global.replica_transaction_retries = '100';
63 ERROR 42000: Incorrect argument type to variable 'replica_transaction_retries'
64 SET @@global.replica_transaction_retries = 7483649.56;
65 ERROR 42000: Incorrect argument type to variable 'replica_transaction_retries'
66 SET @@global.replica_transaction_retries = ON;
67 ERROR 42000: Incorrect argument type to variable 'replica_transaction_retries'
68 SET @@global.replica_transaction_retries = OFF;
69 ERROR 42000: Incorrect argument type to variable 'replica_transaction_retries'
70 SET @@global.replica_transaction_retries = 18446744073709551616;
71 ERROR 42000: Incorrect argument type to variable 'replica_transaction_retries'
72 SELECT @@global.replica_transaction_retries;
73 @@global.replica_transaction_retries
74 0
75 '#------------------FN_DYNVARS_149_06-----------------------#'
76 SET @@global.replica_transaction_retries = 3000;
77 SELECT @@global.replica_transaction_retries = VARIABLE_VALUE
78 FROM performance_schema.global_variables
79 WHERE VARIABLE_NAME='replica_transaction_retries';
80 @@global.replica_transaction_retries = VARIABLE_VALUE
81 1
82 '#------------------FN_DYNVARS_149_07-----------------------#'
83 SELECT count(VARIABLE_VALUE)
84 FROM performance_schema.session_variables
85 WHERE VARIABLE_NAME='replica_transaction_retries';
86 count(VARIABLE_VALUE)
87 1
88 '#------------------FN_DYNVARS_149_08-----------------------#'
89 SET @@global.replica_transaction_retries = TRUE;
90 SELECT @@global.replica_transaction_retries;
91 @@global.replica_transaction_retries
92 1
93 SET @@global.replica_transaction_retries = FALSE;
94 SELECT @@global.replica_transaction_retries;
95 @@global.replica_transaction_retries
96 0
97 '#---------------------FN_DYNVARS_149_09----------------------#'
98 SET @@global.replica_transaction_retries = 60*60;
99 SELECT @@replica_transaction_retries = @@global.replica_transaction_retries;
100 @@replica_transaction_retries = @@global.replica_transaction_retries
101 1
102 '#---------------------FN_DYNVARS_149_10----------------------#'
103 SET replica_transaction_retries = 2048;
104 ERROR HY000: Variable 'replica_transaction_retries' is a GLOBAL variable and should be set with SET GLOBAL
105 SELECT replica_transaction_retries;
106 ERROR 42S22: Unknown column 'replica_transaction_retries' in 'field list'
107 SELECT @@replica_transaction_retries;
108 @@replica_transaction_retries
109 3600
110 SET global replica_transaction_retries = 99;
111 SET @@global.replica_transaction_retries = @start_global_value;