Debian Codegraph @

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

raw
1 SET @session_start_value = @@session.sql_notes;
2 SELECT @session_start_value;
3 @session_start_value
4 1
5 '#--------------------FN_DYNVARS_161_01------------------------#'
6 SET @@session.sql_notes = 0;
7 SET @@session.sql_notes = DEFAULT;
8 SELECT @@session.sql_notes;
9 @@session.sql_notes
10 1
11 SET @@session.sql_notes = 1;
12 SET @@session.sql_notes = DEFAULT;
13 SELECT @@session.sql_notes;
14 @@session.sql_notes
15 1
16 '#---------------------FN_DYNVARS_161_02-------------------------#'
17 SET sql_notes = 1;
18 SELECT @@sql_notes;
19 @@sql_notes
20 1
21 SELECT session.sql_notes;
22 ERROR 42S02: Unknown table 'session' in field list
23 SELECT local.sql_notes;
24 ERROR 42S02: Unknown table 'local' in field list
25 SET session sql_notes = 0;
26 SELECT @@session.sql_notes;
27 @@session.sql_notes
28 0
29 '#--------------------FN_DYNVARS_161_03------------------------#'
30 SET @@session.sql_notes = 0;
31 SELECT @@session.sql_notes;
32 @@session.sql_notes
33 0
34 SET @@session.sql_notes = 1;
35 SELECT @@session.sql_notes;
36 @@session.sql_notes
37 1
38 '#--------------------FN_DYNVARS_161_04-------------------------#'
39 SET @@session.sql_notes = -1;
40 ERROR 42000: Variable 'sql_notes' can't be set to the value of '-1'
41 SET @@session.sql_notes = 2;
42 ERROR 42000: Variable 'sql_notes' can't be set to the value of '2'
43 SET @@session.sql_notes = "T";
44 ERROR 42000: Variable 'sql_notes' can't be set to the value of 'T'
45 SET @@session.sql_notes = "Y";
46 ERROR 42000: Variable 'sql_notes' can't be set to the value of 'Y'
47 SET @@session.sql_notes = TRÜE;
48 ERROR 42000: Variable 'sql_notes' can't be set to the value of 'TRÜE'
49 SET @@session.sql_notes = ÕN;
50 ERROR 42000: Variable 'sql_notes' can't be set to the value of 'ÕN'
51 SET @@session.sql_notes = 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_notes = ÓFF;
54 ERROR 42000: Variable 'sql_notes' can't be set to the value of 'ÓFF'
55 SET @@session.sql_notes = '¹';
56 ERROR 42000: Variable 'sql_notes' can't be set to the value of '¹'
57 SET @@session.sql_notes = NO;
58 ERROR 42000: Variable 'sql_notes' can't be set to the value of 'NO'
59 '#-------------------FN_DYNVARS_161_05----------------------------#'
60 SET @@global.sql_notes = 1-@@global.sql_notes;
61 SELECT @@global.sql_notes;
62 @@global.sql_notes
63 0
64 SET @@global.sql_notes = 1-@@global.sql_notes;
65 SELECT @@global.sql_notes;
66 @@global.sql_notes
67 1
68 '#----------------------FN_DYNVARS_161_06------------------------#'
69 SELECT count(VARIABLE_VALUE) FROM performance_schema.global_variables WHERE VARIABLE_NAME='sql_notes';
70 count(VARIABLE_VALUE)
71 1
72 '#----------------------FN_DYNVARS_161_07------------------------#'
73 SELECT IF(@@session.sql_notes, "ON", "OFF") = VARIABLE_VALUE
74 FROM performance_schema.session_variables
75 WHERE VARIABLE_NAME='sql_notes';
76 IF(@@session.sql_notes, "ON", "OFF") = VARIABLE_VALUE
77 1
78 SELECT @@session.sql_notes;
79 @@session.sql_notes
80 1
81 SELECT VARIABLE_VALUE
82 FROM performance_schema.session_variables
83 WHERE VARIABLE_NAME='sql_notes';
84 VARIABLE_VALUE
85 ON
86 '#---------------------FN_DYNVARS_161_08-------------------------#'
87 SET @@session.sql_notes = OFF;
88 SELECT @@session.sql_notes;
89 @@session.sql_notes
90 0
91 SET @@session.sql_notes = ON;
92 SELECT @@session.sql_notes;
93 @@session.sql_notes
94 1
95 '#---------------------FN_DYNVARS_161_09----------------------#'
96 SET @@session.sql_notes = TRUE;
97 SELECT @@session.sql_notes;
98 @@session.sql_notes
99 1
100 SET @@session.sql_notes = FALSE;
101 SELECT @@session.sql_notes;
102 @@session.sql_notes
103 0
104 SET @@session.sql_notes = @session_start_value;
105 SELECT @@session.sql_notes;
106 @@session.sql_notes
107 1