Debian Codegraph @

mysql-test/suite/sys_vars/r/sql_log_bin_basic.result

raw
1 SET @session_start_value = @@session.sql_log_bin;
2 SELECT @session_start_value;
3 @session_start_value
4 1
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;
9 @@session.sql_log_bin
10 1
11 SET @@session.sql_log_bin = 1;
12 SET @@session.sql_log_bin = DEFAULT;
13 SELECT @@session.sql_log_bin;
14 @@session.sql_log_bin
15 1
16 '#---------------------FN_DYNVARS_156_02-------------------------#'
17 SET sql_log_bin = 1;
18 SELECT @@sql_log_bin;
19 @@sql_log_bin
20 1
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;
27 @@session.sql_log_bin
28 0
29 '#--------------------FN_DYNVARS_156_03------------------------#'
30 SET @@session.sql_log_bin = 0;
31 SELECT @@session.sql_log_bin;
32 @@session.sql_log_bin
33 0
34 SET @@session.sql_log_bin = 1;
35 SELECT @@session.sql_log_bin;
36 @@session.sql_log_bin
37 1
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 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OF' at line 1
53 SET @@session.sql_log_bin = ÓFF;
54 ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'ÓFF'
55 SET @@session.sql_log_bin = '¹';
56 ERROR 42000: Variable 'sql_log_bin' can't be set to the value of '¹'
57 SET @@session.sql_log_bin = NO;
58 ERROR 42000: Variable 'sql_log_bin' can't be set to the value of 'NO'
59 '#-------------------FN_DYNVARS_156_05----------------------------#'
60 SELECT @@global.sql_log_bin;
61 ERROR HY000: Variable 'sql_log_bin' is a SESSION variable
62 SET @@global.sql_log_bin = 0;
63 ERROR HY000: Variable 'sql_log_bin' is a SESSION variable and can't be used with SET GLOBAL
64 SELECT @@global.sql_log_bin;
65 ERROR HY000: Variable 'sql_log_bin' is a SESSION variable
66 SET @@global.sql_log_bin = 1;
67 ERROR HY000: Variable 'sql_log_bin' is a SESSION variable and can't be used with SET GLOBAL
68 '#----------------------FN_DYNVARS_156_06------------------------#'
69 SELECT count(VARIABLE_VALUE) FROM performance_schema.global_variables WHERE VARIABLE_NAME='sql_log_bin';
70 count(VARIABLE_VALUE)
71 0
72 '#----------------------FN_DYNVARS_156_07------------------------#'
73 SELECT IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE
74 FROM performance_schema.session_variables
75 WHERE VARIABLE_NAME='sql_log_bin';
76 IF(@@session.sql_log_bin, "ON", "OFF") = VARIABLE_VALUE
77 1
78 SELECT @@session.sql_log_bin;
79 @@session.sql_log_bin
80 1
81 SELECT VARIABLE_VALUE
82 FROM performance_schema.session_variables
83 WHERE VARIABLE_NAME='sql_log_bin';
84 VARIABLE_VALUE
85 ON
86 '#---------------------FN_DYNVARS_156_08-------------------------#'
87 SET @@session.sql_log_bin = OFF;
88 SELECT @@session.sql_log_bin;
89 @@session.sql_log_bin
90 0
91 SET @@session.sql_log_bin = ON;
92 SELECT @@session.sql_log_bin;
93 @@session.sql_log_bin
94 1
95 '#---------------------FN_DYNVARS_156_09----------------------#'
96 SET @@session.sql_log_bin = TRUE;
97 SELECT @@session.sql_log_bin;
98 @@session.sql_log_bin
99 1
100 SET @@session.sql_log_bin = FALSE;
101 SELECT @@session.sql_log_bin;
102 @@session.sql_log_bin
103 0
104 SET @@session.sql_log_bin = @session_start_value;
105 SELECT @@session.sql_log_bin;
106 @@session.sql_log_bin
107 1