1SET @session_start_value = @@session.pseudo_slave_mode;
2SELECT @session_start_value;
3@session_start_value
40
5'#--------------------FN_DYNVARS_156_01------------------------#'
6SET @@session.pseudo_slave_mode = 0;
7Warnings:
8Warning	1231	'pseudo_slave_mode' change was ineffective.
9SET @@session.pseudo_slave_mode = DEFAULT;
10Warnings:
11Warning	1231	'pseudo_slave_mode' change was ineffective.
12SELECT @@session.pseudo_slave_mode;
13@@session.pseudo_slave_mode
140
15SET @@session.pseudo_slave_mode = 1;
16SET @@session.pseudo_slave_mode = DEFAULT;
17Warnings:
18Warning	1231	Slave applier execution mode not active, statement ineffective.
19SELECT @@session.pseudo_slave_mode;
20@@session.pseudo_slave_mode
210
22'#---------------------FN_DYNVARS_156_02-------------------------#'
23SET pseudo_slave_mode = 1;
24SELECT @@pseudo_slave_mode;
25@@pseudo_slave_mode
261
27SELECT session.pseudo_slave_mode;
28ERROR 42S02: Unknown table 'session' in field list
29SELECT local.pseudo_slave_mode;
30ERROR 42S02: Unknown table 'local' in field list
31SET session pseudo_slave_mode = 0;
32Warnings:
33Warning	1231	Slave applier execution mode not active, statement ineffective.
34SELECT @@session.pseudo_slave_mode;
35@@session.pseudo_slave_mode
360
37'#--------------------FN_DYNVARS_156_03------------------------#'
38SET @@session.pseudo_slave_mode = 0;
39Warnings:
40Warning	1231	'pseudo_slave_mode' change was ineffective.
41SELECT @@session.pseudo_slave_mode;
42@@session.pseudo_slave_mode
430
44SET @@session.pseudo_slave_mode = 1;
45SELECT @@session.pseudo_slave_mode;
46@@session.pseudo_slave_mode
471
48'#--------------------FN_DYNVARS_156_04-------------------------#'
49SET @@session.pseudo_slave_mode = -1;
50ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '-1'
51SET @@session.pseudo_slave_mode = 2;
52ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '2'
53SET @@session.pseudo_slave_mode = "T";
54ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'T'
55SET @@session.pseudo_slave_mode = "Y";
56ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'Y'
57SET @@session.pseudo_slave_mode = TR�E;
58ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'TR�E'
59SET @@session.pseudo_slave_mode = �N;
60ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '�N'
61SET @@session.pseudo_slave_mode = OF;
62ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'OF'
63SET @@session.pseudo_slave_mode = �FF;
64ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '�FF'
65SET @@session.pseudo_slave_mode = '�';
66ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of '�'
67SET @@session.pseudo_slave_mode = NO;
68ERROR 42000: Variable 'pseudo_slave_mode' can't be set to the value of 'NO'
69'#-------------------FN_DYNVARS_156_05----------------------------#'
70SET @@global.pseudo_slave_mode = 0;
71ERROR HY000: Variable 'pseudo_slave_mode' is a SESSION variable and can't be used with SET GLOBAL
72SELECT @@global.pseudo_slave_mode;
73ERROR HY000: Variable 'pseudo_slave_mode' is a SESSION variable
74'#----------------------FN_DYNVARS_156_06------------------------#'
75SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='pseudo_slave_mode';
76count(VARIABLE_VALUE)
771
78'#----------------------FN_DYNVARS_156_07------------------------#'
79SELECT IF(@@session.pseudo_slave_mode, "ON", "OFF") = VARIABLE_VALUE
80FROM INFORMATION_SCHEMA.SESSION_VARIABLES
81WHERE VARIABLE_NAME='pseudo_slave_mode';
82IF(@@session.pseudo_slave_mode, "ON", "OFF") = VARIABLE_VALUE
831
84SELECT @@session.pseudo_slave_mode;
85@@session.pseudo_slave_mode
861
87SELECT VARIABLE_VALUE
88FROM INFORMATION_SCHEMA.SESSION_VARIABLES
89WHERE VARIABLE_NAME='pseudo_slave_mode';
90VARIABLE_VALUE
91ON
92'#---------------------FN_DYNVARS_156_08-------------------------#'
93SET @@session.pseudo_slave_mode = OFF;
94Warnings:
95Warning	1231	Slave applier execution mode not active, statement ineffective.
96SELECT @@session.pseudo_slave_mode;
97@@session.pseudo_slave_mode
980
99SET @@session.pseudo_slave_mode = ON;
100SELECT @@session.pseudo_slave_mode;
101@@session.pseudo_slave_mode
1021
103'#---------------------FN_DYNVARS_156_09----------------------#'
104SET @@session.pseudo_slave_mode = TRUE;
105SELECT @@session.pseudo_slave_mode;
106@@session.pseudo_slave_mode
1071
108SET @@session.pseudo_slave_mode = FALSE;
109Warnings:
110Warning	1231	Slave applier execution mode not active, statement ineffective.
111SELECT @@session.pseudo_slave_mode;
112@@session.pseudo_slave_mode
1130
114SET @@session.pseudo_slave_mode = @session_start_value;
115Warnings:
116Warning	1231	'pseudo_slave_mode' change was ineffective.
117SELECT @@session.pseudo_slave_mode;
118@@session.pseudo_slave_mode
1190
120