1
SET @session_start_value = @@session.sql_log_bin;
2
SELECT @session_start_value;
5
'#--------------------FN_DYNVARS_156_01------------------------#'
6
SET @@session.sql_log_bin = 0;
7
SET @@session.sql_log_bin = DEFAULT;
8
SELECT @@session.sql_log_bin;
11
SET @@session.sql_log_bin = 1;
12
SET @@session.sql_log_bin = DEFAULT;
13
SELECT @@session.sql_log_bin;
16
'#---------------------FN_DYNVARS_156_02-------------------------#'
21
SELECT session.sql_log_bin;
22
ERROR 42S02: Unknown table 'session' in field list
23
SELECT local.sql_log_bin;
24
ERROR 42S02: Unknown table 'local' in field list
25
SET session sql_log_bin = 0;
26
SELECT @@session.sql_log_bin;
29
'#--------------------FN_DYNVARS_156_03------------------------#'
30
SET @@session.sql_log_bin = 0;
31
SELECT @@session.sql_log_bin;
34
SET @@session.sql_log_bin = 1;
35
SELECT @@session.sql_log_bin;
38
'#--------------------FN_DYNVARS_156_04-------------------------#'
39
SET @@session.sql_log_bin = -1;
40
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '-1'
41
SET @@session.sql_log_bin = 2;
42
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '2'
43
SET @@session.sql_log_bin = "T";
44
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'T'
45
SET @@session.sql_log_bin = "Y";
46
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'Y'
47
SET @@session.sql_log_bin = TR�E;
48
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'TRÜE'
49
SET @@session.sql_log_bin = �N;
50
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'ÕN'
51
SET @@session.sql_log_bin = OF;
52
SELECT @@session.sql_log_bin;
55
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
56
SET @@session.sql_log_bin = �FF;
57
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'ÓFF'
58
SET @@session.sql_log_bin = '�';
59
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '�'
60
SET @@session.sql_log_bin = NO;
61
ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'NO'
62
'#-------------------FN_DYNVARS_156_05----------------------------#'
63
SET @@global.sql_log_bin = 0;
64
ERROR HY000: Variable 'sql_log_bin' is a SESSION variable and can't be used with SET GLOBAL
65
SELECT @@global.sql_log_bin;
66
ERROR HY000: Variable 'sql_log_bin' is a SESSION variable
67
'#----------------------FN_DYNVARS_156_06------------------------#'
68
SELECT count(VARIABLE_VALUE) FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='sql_log_bin';
71
'#----------------------FN_DYNVARS_156_07------------------------#'
72
SELECT @@session.sql_log_bin = VARIABLE_VALUE
73
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
74
WHERE VARIABLE_NAME='sql_log_bin';
75
@@session.sql_log_bin = VARIABLE_VALUE
77
SELECT @@session.sql_log_bin;
81
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
82
WHERE VARIABLE_NAME='sql_log_bin';
85
'#---------------------FN_DYNVARS_156_08-------------------------#'
86
SET @@session.sql_log_bin = OFF;
87
SELECT @@session.sql_log_bin;
90
SET @@session.sql_log_bin = ON;
91
SELECT @@session.sql_log_bin;
94
'#---------------------FN_DYNVARS_156_09----------------------#'
95
SET @@session.sql_log_bin = TRUE;
96
SELECT @@session.sql_log_bin;
99
SET @@session.sql_log_bin = FALSE;
100
SELECT @@session.sql_log_bin;
101
@@session.sql_log_bin
103
SET @@session.sql_log_bin = @session_start_value;
104
SELECT @@session.sql_log_bin;
105
@@session.sql_log_bin