1SET @session_start_value = @@session.sql_log_bin;
2SELECT @session_start_value;
3@session_start_value
41
5'#--------------------FN_DYNVARS_156_01------------------------#'
6SET @@session.sql_log_bin = 0;
7SET @@session.sql_log_bin = DEFAULT;
8SELECT @@session.sql_log_bin;
9@@session.sql_log_bin
101
11SET @@session.sql_log_bin = 1;
12SET @@session.sql_log_bin = DEFAULT;
13SELECT @@session.sql_log_bin;
14@@session.sql_log_bin
151
16'#---------------------FN_DYNVARS_156_02-------------------------#'
17SET sql_log_bin = 1;
18SELECT @@sql_log_bin;
19@@sql_log_bin
201
21SELECT session.sql_log_bin;
22ERROR 42S02: Unknown table 'session' in field list
23SELECT local.sql_log_bin;
24ERROR 42S02: Unknown table 'local' in field list
25SET session sql_log_bin = 0;
26SELECT @@session.sql_log_bin;
27@@session.sql_log_bin
280
29'#--------------------FN_DYNVARS_156_03------------------------#'
30SET @@session.sql_log_bin = 0;
31SELECT @@session.sql_log_bin;
32@@session.sql_log_bin
330
34SET @@session.sql_log_bin = 1;
35SELECT @@session.sql_log_bin;
36@@session.sql_log_bin
371
38'#--------------------FN_DYNVARS_156_04-------------------------#'
39SET @@session.sql_log_bin = -1;
40ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '-1'
41SET @@session.sql_log_bin = 2;
42ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '2'
43SET @@session.sql_log_bin = "T";
44ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'T'
45SET @@session.sql_log_bin = "Y";
46ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'Y'
47SET @@session.sql_log_bin = TR�E;
48ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'TR�E'
49SET @@session.sql_log_bin = �N;
50ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '�N'
51SET @@session.sql_log_bin = OF;
52ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'OF'
53SET @@session.sql_log_bin = �FF;
54ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '�FF'
55SET @@session.sql_log_bin = '�';
56ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '�'
57SET @@session.sql_log_bin = NO;
58ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'NO'
59'#-------------------FN_DYNVARS_156_05----------------------------#'
60SELECT @@global.sql_log_bin;
61@@global.sql_log_bin
621
63SET @@global.sql_log_bin = 0;
64ERROR HY000: Variable 'sql_log_bin' is a SESSION variable
65SELECT @@global.sql_log_bin;
66@@global.sql_log_bin
671
68SET @@global.sql_log_bin = 1;
69ERROR HY000: Variable 'sql_log_bin' is a SESSION variable
70'#----------------------FN_DYNVARS_156_06------------------------#'
71SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sql_log_bin';
72count(VARIABLE_VALUE)
731
74'#----------------------FN_DYNVARS_156_07------------------------#'
75SELECT IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE
76FROM INFORMATION_SCHEMA.SESSION_VARIABLES
77WHERE VARIABLE_NAME='sql_log_bin';
78IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE
791
80SELECT @@session.sql_log_bin;
81@@session.sql_log_bin
821
83SELECT VARIABLE_VALUE
84FROM INFORMATION_SCHEMA.SESSION_VARIABLES
85WHERE VARIABLE_NAME='sql_log_bin';
86VARIABLE_VALUE
87ON
88'#---------------------FN_DYNVARS_156_08-------------------------#'
89SET @@session.sql_log_bin = OFF;
90SELECT @@session.sql_log_bin;
91@@session.sql_log_bin
920
93SET @@session.sql_log_bin = ON;
94SELECT @@session.sql_log_bin;
95@@session.sql_log_bin
961
97'#---------------------FN_DYNVARS_156_09----------------------#'
98SET @@session.sql_log_bin = TRUE;
99SELECT @@session.sql_log_bin;
100@@session.sql_log_bin
1011
102SET @@session.sql_log_bin = FALSE;
103SELECT @@session.sql_log_bin;
104@@session.sql_log_bin
1050
106SET @@session.sql_log_bin = @session_start_value;
107SELECT @@session.sql_log_bin;
108@@session.sql_log_bin
1091
110