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
63Warnings:
64Warning	1287	'@@global.sql_log_bin' is deprecated and will be removed in a future release. Please use the constant 1 (since @@global.sql_log_bin is always equal to 1) instead
65SET @@global.sql_log_bin = 0;
66ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '0'
67SELECT @@global.sql_log_bin;
68@@global.sql_log_bin
691
70Warnings:
71Warning	1287	'@@global.sql_log_bin' is deprecated and will be removed in a future release. Please use the constant 1 (since @@global.sql_log_bin is always equal to 1) instead
72SET @@global.sql_log_bin = 1;
73ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '1'
74'#----------------------FN_DYNVARS_156_06------------------------#'
75SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sql_log_bin';
76count(VARIABLE_VALUE)
771
78'#----------------------FN_DYNVARS_156_07------------------------#'
79SELECT IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE
80FROM INFORMATION_SCHEMA.SESSION_VARIABLES
81WHERE VARIABLE_NAME='sql_log_bin';
82IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE
831
84SELECT @@session.sql_log_bin;
85@@session.sql_log_bin
861
87SELECT VARIABLE_VALUE
88FROM INFORMATION_SCHEMA.SESSION_VARIABLES
89WHERE VARIABLE_NAME='sql_log_bin';
90VARIABLE_VALUE
91ON
92'#---------------------FN_DYNVARS_156_08-------------------------#'
93SET @@session.sql_log_bin = OFF;
94SELECT @@session.sql_log_bin;
95@@session.sql_log_bin
960
97SET @@session.sql_log_bin = ON;
98SELECT @@session.sql_log_bin;
99@@session.sql_log_bin
1001
101'#---------------------FN_DYNVARS_156_09----------------------#'
102SET @@session.sql_log_bin = TRUE;
103SELECT @@session.sql_log_bin;
104@@session.sql_log_bin
1051
106SET @@session.sql_log_bin = FALSE;
107SELECT @@session.sql_log_bin;
108@@session.sql_log_bin
1090
110SET @@session.sql_log_bin = @session_start_value;
111SELECT @@session.sql_log_bin;
112@@session.sql_log_bin
1131
114