Debian Codegraph @

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

raw
1 include/only_with_option.inc [GLOBAL.xa_detach_on_prepare = 1]
2 SET @session_start_value = @@session.pseudo_replica_mode;
3 SELECT @session_start_value;
4 @session_start_value
5 0
6 '#--------------------FN_DYNVARS_156_01------------------------#'
7 SET @@session.pseudo_replica_mode = 0;
8 Warnings:
9 Warning 1231 'pseudo_replica_mode' change was ineffective.
10 SET @@session.pseudo_replica_mode = DEFAULT;
11 Warnings:
12 Warning 1231 'pseudo_replica_mode' change was ineffective.
13 SELECT @@session.pseudo_replica_mode;
14 @@session.pseudo_replica_mode
15 0
16 SET @@session.pseudo_replica_mode = 1;
17 SET @@session.pseudo_replica_mode = DEFAULT;
18 Warnings:
19 Warning 1231 Replica applier execution mode not active, statement ineffective.
20 SELECT @@session.pseudo_replica_mode;
21 @@session.pseudo_replica_mode
22 0
23 SET @@session.pseudo_replica_mode = 1;
24 SET @@session.pseudo_slave_mode = DEFAULT;
25 Warnings:
26 Warning 1287 '@@pseudo_slave_mode' is deprecated and will be removed in a future release. Please use pseudo_replica_mode instead.
27 Warning 1231 Replica applier execution mode not active, statement ineffective.
28 SELECT @@session.pseudo_replica_mode;
29 @@session.pseudo_replica_mode
30 0
31 '#---------------------FN_DYNVARS_156_02-------------------------#'
32 SET pseudo_replica_mode = 1;
33 SELECT @@pseudo_replica_mode;
34 @@pseudo_replica_mode
35 1
36 SELECT session.pseudo_replica_mode;
37 ERROR 42S02: Unknown table 'session' in field list
38 SELECT local.pseudo_replica_mode;
39 ERROR 42S02: Unknown table 'local' in field list
40 SET session pseudo_replica_mode = 0;
41 Warnings:
42 Warning 1231 Replica applier execution mode not active, statement ineffective.
43 SELECT @@session.pseudo_replica_mode;
44 @@session.pseudo_replica_mode
45 0
46 '#--------------------FN_DYNVARS_156_03------------------------#'
47 SET @@session.pseudo_replica_mode = 0;
48 Warnings:
49 Warning 1231 'pseudo_replica_mode' change was ineffective.
50 SELECT @@session.pseudo_replica_mode;
51 @@session.pseudo_replica_mode
52 0
53 SET @@session.pseudo_replica_mode = 1;
54 SELECT @@session.pseudo_replica_mode;
55 @@session.pseudo_replica_mode
56 1
57 '#--------------------FN_DYNVARS_156_04-------------------------#'
58 SET @@session.pseudo_replica_mode = -1;
59 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of '-1'
60 SET @@session.pseudo_replica_mode = 2;
61 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of '2'
62 SET @@session.pseudo_replica_mode = "T";
63 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of 'T'
64 SET @@session.pseudo_replica_mode = "Y";
65 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of 'Y'
66 SET @@session.pseudo_replica_mode = TRÜE;
67 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of 'TRÜE'
68 SET @@session.pseudo_replica_mode = ÕN;
69 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of 'ÕN'
70 SET @@session.pseudo_replica_mode = OF;
71 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OF' at line 1
72 SET @@session.pseudo_replica_mode = ÓFF;
73 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of 'ÓFF'
74 SET @@session.pseudo_replica_mode = '¹';
75 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of '¹'
76 SET @@session.pseudo_replica_mode = NO;
77 ERROR 42000: Variable 'pseudo_replica_mode' can't be set to the value of 'NO'
78 '#-------------------FN_DYNVARS_156_05----------------------------#'
79 SET @@global.pseudo_replica_mode = 0;
80 ERROR HY000: Variable 'pseudo_replica_mode' is a SESSION variable and can't be used with SET GLOBAL
81 SELECT @@global.pseudo_replica_mode;
82 ERROR HY000: Variable 'pseudo_replica_mode' is a SESSION variable
83 '#----------------------FN_DYNVARS_156_06------------------------#'
84 SELECT count(VARIABLE_VALUE) FROM performance_schema.session_variables WHERE VARIABLE_NAME='pseudo_replica_mode';
85 count(VARIABLE_VALUE)
86 1
87 '#----------------------FN_DYNVARS_156_07------------------------#'
88 SELECT IF(@@session.pseudo_replica_mode, "ON", "OFF") = VARIABLE_VALUE
89 FROM performance_schema.session_variables
90 WHERE VARIABLE_NAME='pseudo_replica_mode';
91 IF(@@session.pseudo_replica_mode, "ON", "OFF") = VARIABLE_VALUE
92 1
93 SELECT @@session.pseudo_replica_mode;
94 @@session.pseudo_replica_mode
95 1
96 SELECT VARIABLE_VALUE
97 FROM performance_schema.session_variables
98 WHERE VARIABLE_NAME='pseudo_replica_mode';
99 VARIABLE_VALUE
100 ON
101 '#---------------------FN_DYNVARS_156_08-------------------------#'
102 SET @@session.pseudo_replica_mode = OFF;
103 Warnings:
104 Warning 1231 Replica applier execution mode not active, statement ineffective.
105 SELECT @@session.pseudo_replica_mode;
106 @@session.pseudo_replica_mode
107 0
108 SET @@session.pseudo_replica_mode = ON;
109 SELECT @@session.pseudo_replica_mode;
110 @@session.pseudo_replica_mode
111 1
112 '#---------------------FN_DYNVARS_156_09----------------------#'
113 SET @@session.pseudo_replica_mode = TRUE;
114 SELECT @@session.pseudo_replica_mode;
115 @@session.pseudo_replica_mode
116 1
117 SET @@session.pseudo_replica_mode = FALSE;
118 Warnings:
119 Warning 1231 Replica applier execution mode not active, statement ineffective.
120 SELECT @@session.pseudo_replica_mode;
121 @@session.pseudo_replica_mode
122 0
123 '#---------------------FN_DYNVARS_156_10----------------------#'
124 BEGIN;
125 SET @@session.pseudo_replica_mode = TRUE;
126 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
127 SET @@session.pseudo_replica_mode = FALSE;
128 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
129 COMMIT;
130 XA START 'xa1';
131 SET @@session.pseudo_replica_mode = TRUE;
132 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
133 SET @@session.pseudo_replica_mode = FALSE;
134 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
135 XA END 'xa1';
136 SET @@session.pseudo_replica_mode = TRUE;
137 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
138 SET @@session.pseudo_replica_mode = FALSE;
139 ERROR HY000: The system variable pseudo_replica_mode cannot be set when there is an ongoing transaction.
140 XA PREPARE 'xa1';
141 SET @@session.pseudo_replica_mode = TRUE;
142 SET @@session.pseudo_replica_mode = FALSE;
143 Warnings:
144 Warning 1231 Replica applier execution mode not active, statement ineffective.
145 XA COMMIT 'xa1';
146 SET @@session.pseudo_replica_mode = TRUE;
147 SET @@session.pseudo_replica_mode = FALSE;
148 Warnings:
149 Warning 1231 Replica applier execution mode not active, statement ineffective.
150 SET @@session.pseudo_replica_mode = @session_start_value;
151 Warnings:
152 Warning 1231 'pseudo_replica_mode' change was ineffective.
153 SELECT @@session.pseudo_replica_mode;
154 @@session.pseudo_replica_mode
155 0