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