Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.log_warnings;
2 SELECT @start_global_value;
3 @start_global_value
4 2
5 SET @start_session_value = @@session.log_warnings;
6 SELECT @start_session_value;
7 @start_session_value
8 2
9 '#--------------------FN_DYNVARS_067_01-------------------------#'
10 SET @@global.log_warnings = 100;
11 SET @@global.log_warnings = DEFAULT;
12 SELECT @@global.log_warnings;
13 @@global.log_warnings
14 2
15 SET @@session.log_warnings = 200;
16 SET @@session.log_warnings = DEFAULT;
17 SELECT @@session.log_warnings;
18 @@session.log_warnings
19 2
20 '#--------------------FN_DYNVARS_067_02-------------------------#'
21 SET @@global.log_warnings = DEFAULT;
22 SELECT @@global.log_warnings = 1;
23 @@global.log_warnings = 1
24 0
25 SET @@session.log_warnings = DEFAULT;
26 SELECT @@session.log_warnings = 1;
27 @@session.log_warnings = 1
28 0
29 '#--------------------FN_DYNVARS_067_03-------------------------#'
30 SET @@global.log_warnings = 0;
31 SELECT @@global.log_warnings;
32 @@global.log_warnings
33 0
34 SET @@global.log_warnings = 1;
35 SELECT @@global.log_warnings;
36 @@global.log_warnings
37 1
38 SET @@global.log_warnings = 60020;
39 SELECT @@global.log_warnings;
40 @@global.log_warnings
41 60020
42 SET @@global.log_warnings = 65535;
43 SELECT @@global.log_warnings;
44 @@global.log_warnings
45 65535
46 SET @@global.log_warnings = 65536;
47 SELECT @@global.log_warnings;
48 @@global.log_warnings
49 65536
50 '#--------------------FN_DYNVARS_067_04-------------------------#'
51 SET @@session.log_warnings = 0;
52 SELECT @@session.log_warnings;
53 @@session.log_warnings
54 0
55 SET @@session.log_warnings = 1;
56 SELECT @@session.log_warnings;
57 @@session.log_warnings
58 1
59 SET @@session.log_warnings = 50050;
60 SELECT @@session.log_warnings;
61 @@session.log_warnings
62 50050
63 SET @@session.log_warnings = 65535;
64 SELECT @@session.log_warnings;
65 @@session.log_warnings
66 65535
67 SET @@session.log_warnings = 65550;
68 SELECT @@session.log_warnings;
69 @@session.log_warnings
70 65550
71 '#------------------FN_DYNVARS_067_05-----------------------#'
72 SET @@global.log_warnings = 100000000000;
73 Warnings:
74 Warning 1292 Truncated incorrect log_warnings value: '100000000000'
75 SELECT @@global.log_warnings;
76 @@global.log_warnings
77 4294967295
78 SET @@global.log_warnings = -1024;
79 Warnings:
80 Warning 1292 Truncated incorrect log_warnings value: '-1024'
81 SELECT @@global.log_warnings;
82 @@global.log_warnings
83 0
84 SET @@global.log_warnings = 65530.34;
85 ERROR 42000: Incorrect argument type to variable 'log_warnings'
86 SELECT @@global.log_warnings;
87 @@global.log_warnings
88 0
89 SET @@global.log_warnings = test;
90 ERROR 42000: Incorrect argument type to variable 'log_warnings'
91 SELECT @@global.log_warnings;
92 @@global.log_warnings
93 0
94 SET @@session.log_warnings = 100000000000;
95 Warnings:
96 Warning 1292 Truncated incorrect log_warnings value: '100000000000'
97 SELECT @@session.log_warnings;
98 @@session.log_warnings
99 4294967295
100 SET @@session.log_warnings = -2;
101 Warnings:
102 Warning 1292 Truncated incorrect log_warnings value: '-2'
103 SELECT @@session.log_warnings;
104 @@session.log_warnings
105 0
106 SET @@session.log_warnings = 65530.34;
107 ERROR 42000: Incorrect argument type to variable 'log_warnings'
108 SET @@session.log_warnings = test;
109 ERROR 42000: Incorrect argument type to variable 'log_warnings'
110 SELECT @@session.log_warnings;
111 @@session.log_warnings
112 0
113 '#------------------FN_DYNVARS_067_06-----------------------#'
114 SELECT @@global.log_warnings = VARIABLE_VALUE
115 FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
116 WHERE VARIABLE_NAME='log_warnings';
117 @@global.log_warnings = VARIABLE_VALUE
118 1
119 '#------------------FN_DYNVARS_067_07-----------------------#'
120 SELECT @@session.log_warnings = VARIABLE_VALUE
121 FROM INFORMATION_SCHEMA.SESSION_VARIABLES
122 WHERE VARIABLE_NAME='log_warnings';
123 @@session.log_warnings = VARIABLE_VALUE
124 1
125 '#------------------FN_DYNVARS_067_08-----------------------#'
126 SET @@global.log_warnings = TRUE;
127 SELECT @@global.log_warnings;
128 @@global.log_warnings
129 1
130 SET @@global.log_warnings = FALSE;
131 SELECT @@global.log_warnings;
132 @@global.log_warnings
133 0
134 '#---------------------FN_DYNVARS_067_09----------------------#'
135 SET @@global.log_warnings = 10;
136 SELECT @@log_warnings = @@global.log_warnings;
137 @@log_warnings = @@global.log_warnings
138 0
139 '#---------------------FN_DYNVARS_067_10----------------------#'
140 SET @@log_warnings = 100;
141 SELECT @@log_warnings = @@local.log_warnings;
142 @@log_warnings = @@local.log_warnings
143 1
144 SELECT @@local.log_warnings = @@session.log_warnings;
145 @@local.log_warnings = @@session.log_warnings
146 1
147 '#---------------------FN_DYNVARS_067_11----------------------#'
148 SET log_warnings = 1;
149 SELECT @@log_warnings;
150 @@log_warnings
151 1
152 SELECT local.log_warnings;
153 ERROR 42S02: Unknown table 'local' in SELECT
154 SELECT session.log_warnings;
155 ERROR 42S02: Unknown table 'session' in SELECT
156 SELECT log_warnings = @@session.log_warnings;
157 ERROR 42S22: Unknown column 'log_warnings' in 'SELECT'
158 SET @@global.log_warnings = @start_global_value;
159 SELECT @@global.log_warnings;
160 @@global.log_warnings
161 2
162 SET @@session.log_warnings = @start_session_value;
163 SELECT @@session.log_warnings;
164 @@session.log_warnings
165 2