Debian Codegraph @

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

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