Debian Codegraph @

mysql-test/suite/x/r/notices_enable.result

raw
1
2 ###
3 ### General setup for all scenarios
4 ###
5
6 ### Scenario 1: Enable group replication notifications
7 ### Expected notices:
8 ### - Myself: N/A
9 ##########################################################################
10
11 command ok
12
13 ### Scenario 2: Execute SQL queries that generate warning notices
14 ### Expected notices:
15 ### - Myself: Warnings
16 ##########################################################################
17
18 ##
19 ## Check with dropping db which doesn't exists
20 RUN drop database if exists mysqltest
21
22 0 rows affected
23 Warnings generated:
24 NOTE | 1008 | Can't drop database 'mysqltest'; database doesn't exist
25 Got expected warning: 1008
26
27 ##
28 ## Check with dropping table which doesn't exists
29 RUN drop table if exists test.mysqltest
30
31 0 rows affected
32 Warnings generated:
33 NOTE | 1051 | Unknown table 'test.mysqltest'
34 Got expected warning: 1051
35
36 ##
37 ## Check with show variables like version
38 RUN show variables like 'versio'
39 Variable_name Value
40 0 rows affected
41
42 ##
43 ## Check with dropping procedure which doesn't exists
44 RUN drop procedure if exists test.test_invalid
45
46 0 rows affected
47 Warnings generated:
48 NOTE | 1305 | PROCEDURE test.test_invalid does not exist
49 Got expected warning: 1305
50
51 ##
52 ## Check with dropping function which doesn't exists
53 RUN drop function if exists test.test_signal_func
54
55 0 rows affected
56 Warnings generated:
57 NOTE | 1305 | FUNCTION test.test_signal_func does not exist
58 Got expected warning: 1305
59
60 ##
61 ## Check with dropping view which doesn't exists
62 RUN drop view if exists test.v1
63
64 0 rows affected
65 Warnings generated:
66 NOTE | 1051 | Unknown table 'test.v1'
67 Got expected warning: 1051
68
69 ##
70 ## Out of range values for INT,UNSIGN INT
71 RUN create table test.t1 (c1 INT, c2 INT UNSIGNED)
72
73 0 rows affected
74 RUN insert ignore into test.t1 values ('21474836461','21474836461')
75
76 1 rows affected
77 Warnings generated:
78 WARNING | 1264 | Out of range value for column 'c1' at row 1
79 WARNING | 1264 | Out of range value for column 'c2' at row 1
80 Got expected warning: 1264
81 RUN insert ignore into test.t1 values ('-21474836461','-21474836461')
82
83 1 rows affected
84 Warnings generated:
85 WARNING | 1264 | Out of range value for column 'c1' at row 1
86 WARNING | 1264 | Out of range value for column 'c2' at row 1
87 Got expected warning: 1264
88 RUN drop table test.t1
89
90 0 rows affected
91
92 ##
93 ## Checking double data type
94 RUN create table test.t1 (grp int, a bigint unsigned, c char(10) not null, d char(10) not null, index grp_idx(grp))
95
96 0 rows affected
97 RUN insert into test.t1 values (1,1,"a","a")
98
99 1 rows affected
100 RUN insert into test.t1 values (2,2,"b","a")
101
102 1 rows affected
103 RUN insert into test.t1 values (2,3,"c","b")
104
105 1 rows affected
106 RUN insert into test.t1 values (3,4,"E","a")
107
108 1 rows affected
109 RUN insert into test.t1 values (3,5,"C","b")
110
111 1 rows affected
112 RUN insert into test.t1 values (3,6,"D","b")
113
114 1 rows affected
115 RUN insert into test.t1 values (3,7,"d","d")
116
117 1 rows affected
118 RUN insert into test.t1 values (3,8,"d","d")
119
120 1 rows affected
121 RUN insert into test.t1 values (3,9,"D","c")
122
123 1 rows affected
124 RUN select grp,group_concat(a order by a,d-ascii(c)-a) from test.t1 group by grp order by grp
125 grp group_concat(a order by a,d-ascii(c)-a)
126 1 1
127 2 2,3
128 3 4,5,6,7,8,9
129 0 rows affected
130 Warnings generated:
131 WARNING | 1292 | Truncated incorrect DOUBLE value: 'a'
132 WARNING | 1292 | Truncated incorrect DOUBLE value: 'a'
133 WARNING | 1292 | Truncated incorrect DOUBLE value: 'b'
134 WARNING | 1292 | Truncated incorrect DOUBLE value: 'a'
135 WARNING | 1292 | Truncated incorrect DOUBLE value: 'b'
136 WARNING | 1292 | Truncated incorrect DOUBLE value: 'b'
137 WARNING | 1292 | Truncated incorrect DOUBLE value: 'd'
138 WARNING | 1292 | Truncated incorrect DOUBLE value: 'd'
139 WARNING | 1292 | Truncated incorrect DOUBLE value: 'c'
140 Got expected warning: 1292
141 RUN select grp,group_concat(a order by c-ascii(c),a) from test.t1 group by grp order by grp
142 grp group_concat(a order by c-ascii(c),a)
143 1 1
144 2 3,2
145 3 7,8,4,6,9,5
146 0 rows affected
147 Warnings generated:
148 WARNING | 1292 | Truncated incorrect DOUBLE value: 'a'
149 WARNING | 1292 | Truncated incorrect DOUBLE value: 'b'
150 WARNING | 1292 | Truncated incorrect DOUBLE value: 'c'
151 WARNING | 1292 | Truncated incorrect DOUBLE value: 'E'
152 WARNING | 1292 | Truncated incorrect DOUBLE value: 'C'
153 WARNING | 1292 | Truncated incorrect DOUBLE value: 'D'
154 WARNING | 1292 | Truncated incorrect DOUBLE value: 'd'
155 WARNING | 1292 | Truncated incorrect DOUBLE value: 'd'
156 WARNING | 1292 | Truncated incorrect DOUBLE value: 'D'
157 Got expected warning: 1292
158 RUN set group_concat_max_len = 4
159
160 0 rows affected
161 RUN select grp,group_concat(c order by c) from test.t1 group by grp order by grp
162 grp group_concat(c order by c)
163 1 a
164 2 b,c
165 3 C,D,
166 0 rows affected
167 Warnings generated:
168 WARNING | 1260 | Row 6 was cut by GROUP_CONCAT()
169 Got expected warning: 1260
170 RUN drop table test.t1
171
172 0 rows affected
173
174 ##
175 ## Checking character data type
176 ## Error is returned instead of warning for insert operation with xplugin
177 RUN SET sql_mode = 'NO_ENGINE_SUBSTITUTION'
178
179 0 rows affected
180 RUN prepare stmt from 'create table test.t1 (a varchar(10) character set utf8)'
181
182 0 rows affected
183 Statement prepared
184 Warnings generated:
185 WARNING | 3719 | 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
186 Got expected warning: 3719
187 RUN execute stmt
188
189 0 rows affected
190 RUN insert into test.t1 (a) values (repeat('a', 20))
191
192 1 rows affected
193 Warnings generated:
194 WARNING | 1265 | Data truncated for column 'a' at row 1
195 Got expected warning: 1265
196 RUN select length(a) from test.t1
197 length(a)
198 10
199 0 rows affected
200 RUN drop table test.t1
201
202 0 rows affected
203 RUN execute stmt
204
205 0 rows affected
206
207 ##
208 ## Checking directly from IS tables
209 RUN show session variables like 'max_join_size'
210 Variable_name Value
211 max_join_size 18446744073709551615
212 0 rows affected
213 RUN show session variables like 'concurrent_insert'
214 Variable_name Value
215 concurrent_insert AUTO
216 0 rows affected
217 RUN show session variables like 'default_storage_engine'
218 Variable_name Value
219 default_storage_engine InnoDB
220 0 rows affected
221
222 ##
223 ## Checking errors and warnings with duplicate table
224 RUN SET SQL_WARNINGS=1
225
226 0 rows affected
227
228 ##
229 ## Checking errors and warnings with duplicate table names
230 RUN create table test.dup (a int)
231
232 0 rows affected
233 RUN create table test.dup (a int)
234 While executing create table test.dup (a int):
235 Got expected error: Table 'dup' already exists (code 1050)
236 RUN show count(*) errors
237 @@session.error_count
238 1
239 0 rows affected
240 RUN show errors
241 Level Code Message
242 Error 1050 Table 'dup' already exists
243 0 rows affected
244 RUN drop table test.dup
245
246 0 rows affected
247
248 ##
249 ## Checking creating table with if not exists
250 RUN flush status
251
252 0 rows affected
253 RUN use test
254
255 0 rows affected
256 RUN create table t1 (a int not null, b int, primary key (a))
257 While executing create table t1 (a int not null, b int, primary key (a)):
258 Got expected error: Table 't1' already exists (code 1050)
259 RUN create table if not exists t1 select 2
260
261 0 rows affected
262 Warnings generated:
263 NOTE | 1050 | Table 't1' already exists
264 Got expected warning: 1050
265 RUN select * from t1
266 a
267 0 rows affected
268 RUN create table if not exists t1 select 3 as 'a',4 as 'b'
269
270 0 rows affected
271 Warnings generated:
272 NOTE | 1050 | Table 't1' already exists
273 Got expected warning: 1050
274 RUN show status like "Opened_tables"
275 Variable_name Value
276 Opened_tables 1
277 0 rows affected
278 RUN select * from t1
279 a
280 0 rows affected
281 RUN drop table t1
282
283 0 rows affected
284
285 ##
286 ## Try dropping multiple tables with if exists and check multiple warnings
287 RUN use test
288
289 0 rows affected
290 RUN drop tables if exists t1, t2
291
292 0 rows affected
293 Warnings generated:
294 NOTE | 1051 | Unknown table 'test.t1'
295 NOTE | 1051 | Unknown table 'test.t2'
296 Got expected warning: 1051
297
298 ##
299 ## Try checking many warnings
300 RUN drop tables if exists t1, t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21,t22,t23,t24,t25,t26,t27,t28,t29,t30,a1, a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a17,a18,a19,a20,a21,a22,a23,a24,a25,a26,a27,a28,a29,a30,aa1, aa2,aa3,aa4,aa5,aa6,aa7,aa8,aa9,aa10,aa11,aa12,aa13,aa14,aa15,aa16,aa17,aa18,aa19,aa20,aa21,aa22,aa23,aa24,aa25,aa26,aa27,aa28,aa29,aa30,aaaa1, aaaa2,aaaa3,aaaa4,aaaa5,aaaa6,aaaa7,aaaa8,aaaa9,aaaa10,aaaa11,aaaa12,aaaa13,aaaa14,aaaa15,aaaa16,aaaa17,aaaa18,aaaa19,aaaa20,aaaa21,aaaa22,aaaa23,aaaa24,aaaa25,aaaa26,aaaa27,aaaa28,aaaa29,aaaa30
301
302 0 rows affected
303 Warnings generated:
304 NOTE | 1051 | Unknown table 'test.t1'
305 NOTE | 1051 | Unknown table 'test.t2'
306 NOTE | 1051 | Unknown table 'test.t3'
307 NOTE | 1051 | Unknown table 'test.t4'
308 NOTE | 1051 | Unknown table 'test.t5'
309 NOTE | 1051 | Unknown table 'test.t6'
310 NOTE | 1051 | Unknown table 'test.t7'
311 NOTE | 1051 | Unknown table 'test.t8'
312 NOTE | 1051 | Unknown table 'test.t9'
313 NOTE | 1051 | Unknown table 'test.t10'
314 NOTE | 1051 | Unknown table 'test.t11'
315 NOTE | 1051 | Unknown table 'test.t12'
316 NOTE | 1051 | Unknown table 'test.t13'
317 NOTE | 1051 | Unknown table 'test.t14'
318 NOTE | 1051 | Unknown table 'test.t15'
319 NOTE | 1051 | Unknown table 'test.t16'
320 NOTE | 1051 | Unknown table 'test.t17'
321 NOTE | 1051 | Unknown table 'test.t18'
322 NOTE | 1051 | Unknown table 'test.t19'
323 NOTE | 1051 | Unknown table 'test.t20'
324 NOTE | 1051 | Unknown table 'test.t21'
325 NOTE | 1051 | Unknown table 'test.t22'
326 NOTE | 1051 | Unknown table 'test.t23'
327 NOTE | 1051 | Unknown table 'test.t24'
328 NOTE | 1051 | Unknown table 'test.t25'
329 NOTE | 1051 | Unknown table 'test.t26'
330 NOTE | 1051 | Unknown table 'test.t27'
331 NOTE | 1051 | Unknown table 'test.t28'
332 NOTE | 1051 | Unknown table 'test.t29'
333 NOTE | 1051 | Unknown table 'test.t30'
334 NOTE | 1051 | Unknown table 'test.a1'
335 NOTE | 1051 | Unknown table 'test.a2'
336 NOTE | 1051 | Unknown table 'test.a3'
337 NOTE | 1051 | Unknown table 'test.a4'
338 NOTE | 1051 | Unknown table 'test.a5'
339 NOTE | 1051 | Unknown table 'test.a6'
340 NOTE | 1051 | Unknown table 'test.a7'
341 NOTE | 1051 | Unknown table 'test.a8'
342 NOTE | 1051 | Unknown table 'test.a9'
343 NOTE | 1051 | Unknown table 'test.a10'
344 NOTE | 1051 | Unknown table 'test.a11'
345 NOTE | 1051 | Unknown table 'test.a12'
346 NOTE | 1051 | Unknown table 'test.a13'
347 NOTE | 1051 | Unknown table 'test.a14'
348 NOTE | 1051 | Unknown table 'test.a15'
349 NOTE | 1051 | Unknown table 'test.a16'
350 NOTE | 1051 | Unknown table 'test.a17'
351 NOTE | 1051 | Unknown table 'test.a18'
352 NOTE | 1051 | Unknown table 'test.a19'
353 NOTE | 1051 | Unknown table 'test.a20'
354 NOTE | 1051 | Unknown table 'test.a21'
355 NOTE | 1051 | Unknown table 'test.a22'
356 NOTE | 1051 | Unknown table 'test.a23'
357 NOTE | 1051 | Unknown table 'test.a24'
358 NOTE | 1051 | Unknown table 'test.a25'
359 NOTE | 1051 | Unknown table 'test.a26'
360 NOTE | 1051 | Unknown table 'test.a27'
361 NOTE | 1051 | Unknown table 'test.a28'
362 NOTE | 1051 | Unknown table 'test.a29'
363 NOTE | 1051 | Unknown table 'test.a30'
364 NOTE | 1051 | Unknown table 'test.aa1'
365 NOTE | 1051 | Unknown table 'test.aa2'
366 NOTE | 1051 | Unknown table 'test.aa3'
367 NOTE | 1051 | Unknown table 'test.aa4'
368 NOTE | 1051 | Unknown table 'test.aa5'
369 NOTE | 1051 | Unknown table 'test.aa6'
370 NOTE | 1051 | Unknown table 'test.aa7'
371 NOTE | 1051 | Unknown table 'test.aa8'
372 NOTE | 1051 | Unknown table 'test.aa9'
373 NOTE | 1051 | Unknown table 'test.aa10'
374 NOTE | 1051 | Unknown table 'test.aa11'
375 NOTE | 1051 | Unknown table 'test.aa12'
376 NOTE | 1051 | Unknown table 'test.aa13'
377 NOTE | 1051 | Unknown table 'test.aa14'
378 NOTE | 1051 | Unknown table 'test.aa15'
379 NOTE | 1051 | Unknown table 'test.aa16'
380 NOTE | 1051 | Unknown table 'test.aa17'
381 NOTE | 1051 | Unknown table 'test.aa18'
382 NOTE | 1051 | Unknown table 'test.aa19'
383 NOTE | 1051 | Unknown table 'test.aa20'
384 NOTE | 1051 | Unknown table 'test.aa21'
385 NOTE | 1051 | Unknown table 'test.aa22'
386 NOTE | 1051 | Unknown table 'test.aa23'
387 NOTE | 1051 | Unknown table 'test.aa24'
388 NOTE | 1051 | Unknown table 'test.aa25'
389 NOTE | 1051 | Unknown table 'test.aa26'
390 NOTE | 1051 | Unknown table 'test.aa27'
391 NOTE | 1051 | Unknown table 'test.aa28'
392 NOTE | 1051 | Unknown table 'test.aa29'
393 NOTE | 1051 | Unknown table 'test.aa30'
394 NOTE | 1051 | Unknown table 'test.aaaa1'
395 NOTE | 1051 | Unknown table 'test.aaaa2'
396 NOTE | 1051 | Unknown table 'test.aaaa3'
397 NOTE | 1051 | Unknown table 'test.aaaa4'
398 NOTE | 1051 | Unknown table 'test.aaaa5'
399 NOTE | 1051 | Unknown table 'test.aaaa6'
400 NOTE | 1051 | Unknown table 'test.aaaa7'
401 NOTE | 1051 | Unknown table 'test.aaaa8'
402 NOTE | 1051 | Unknown table 'test.aaaa9'
403 NOTE | 1051 | Unknown table 'test.aaaa10'
404 NOTE | 1051 | Unknown table 'test.aaaa11'
405 NOTE | 1051 | Unknown table 'test.aaaa12'
406 NOTE | 1051 | Unknown table 'test.aaaa13'
407 NOTE | 1051 | Unknown table 'test.aaaa14'
408 NOTE | 1051 | Unknown table 'test.aaaa15'
409 NOTE | 1051 | Unknown table 'test.aaaa16'
410 NOTE | 1051 | Unknown table 'test.aaaa17'
411 NOTE | 1051 | Unknown table 'test.aaaa18'
412 NOTE | 1051 | Unknown table 'test.aaaa19'
413 NOTE | 1051 | Unknown table 'test.aaaa20'
414 NOTE | 1051 | Unknown table 'test.aaaa21'
415 NOTE | 1051 | Unknown table 'test.aaaa22'
416 NOTE | 1051 | Unknown table 'test.aaaa23'
417 NOTE | 1051 | Unknown table 'test.aaaa24'
418 NOTE | 1051 | Unknown table 'test.aaaa25'
419 NOTE | 1051 | Unknown table 'test.aaaa26'
420 NOTE | 1051 | Unknown table 'test.aaaa27'
421 NOTE | 1051 | Unknown table 'test.aaaa28'
422 NOTE | 1051 | Unknown table 'test.aaaa29'
423 NOTE | 1051 | Unknown table 'test.aaaa30'
424 Got expected warning: 1051
425
426 ##
427 ## Dropping same table with if exists and observe error/warnings
428 RUN drop tables if exists t1,t1
429 While executing drop tables if exists t1,t1:
430 Got expected error: Not unique table/alias: 't1' (code 1066)
431 RUN set max_error_count=65535
432
433 0 rows affected
434
435 ##
436 ## Check more than 64 warnings returned
437 RUN drop tables if exists t1, t2,t3,t4,t5,t6,t7,t8,t9,t10,t11,t12,t13,t14,t15,t16,t17,t18,t19,t20,t21,t22,t23,t24,t25,t26,t27,t28,t29,t30,a1, a2,a3,a4,a5,a6,a7,a8,a9,a10,a11,a12,a13,a14,a15,a16,a17,a18,a19,a20,a21,a22,a23,a24,a25,a26,a27,a28,a29,a30,aa1, aa2,aa3,aa4,aa5,aa6,aa7,aa8,aa9,aa10,aa11,aa12,aa13,aa14,aa15,aa16,aa17,aa18,aa19,aa20,aa21,aa22,aa23,aa24,aa25,aa26,aa27,aa28,aa29,aa30,aaaa1, aaaa2,aaaa3,aaaa4,aaaa5,aaaa6,aaaa7,aaaa8,aaaa9,aaaa10,aaaa11,aaaa12,aaaa13,aaaa14,aaaa15,aaaa16,aaaa17,aaaa18,aaaa19,aaaa20,aaaa21,aaaa22,aaaa23,aaaa24,aaaa25,aaaa26,aaaa27,aaaa28,aaaa29,aaaa30,bb1, bb2,bb3,bb4,bb5,bb6,bb7,bb8,bb9,bb10,bb11,bb12,bb13,bb14,bb15,bb16,bb17,bb18,bb19,bb20,bb21,bb22,bb23,bb24,bb25,bb26,bb27,bb28,bb29,bb30,b1, b2,b3,b4,b5,b6,b7,b8,b9,b10,b11,b12,b13,b14,b15,b16,b17,b18,b19,b20,b21,b22,b23,b24,b25,b26,b27,b28,b29,b30
438
439 0 rows affected
440 Warnings generated:
441 NOTE | 1051 | Unknown table 'test.t1'
442 NOTE | 1051 | Unknown table 'test.t2'
443 NOTE | 1051 | Unknown table 'test.t3'
444 NOTE | 1051 | Unknown table 'test.t4'
445 NOTE | 1051 | Unknown table 'test.t5'
446 NOTE | 1051 | Unknown table 'test.t6'
447 NOTE | 1051 | Unknown table 'test.t7'
448 NOTE | 1051 | Unknown table 'test.t8'
449 NOTE | 1051 | Unknown table 'test.t9'
450 NOTE | 1051 | Unknown table 'test.t10'
451 NOTE | 1051 | Unknown table 'test.t11'
452 NOTE | 1051 | Unknown table 'test.t12'
453 NOTE | 1051 | Unknown table 'test.t13'
454 NOTE | 1051 | Unknown table 'test.t14'
455 NOTE | 1051 | Unknown table 'test.t15'
456 NOTE | 1051 | Unknown table 'test.t16'
457 NOTE | 1051 | Unknown table 'test.t17'
458 NOTE | 1051 | Unknown table 'test.t18'
459 NOTE | 1051 | Unknown table 'test.t19'
460 NOTE | 1051 | Unknown table 'test.t20'
461 NOTE | 1051 | Unknown table 'test.t21'
462 NOTE | 1051 | Unknown table 'test.t22'
463 NOTE | 1051 | Unknown table 'test.t23'
464 NOTE | 1051 | Unknown table 'test.t24'
465 NOTE | 1051 | Unknown table 'test.t25'
466 NOTE | 1051 | Unknown table 'test.t26'
467 NOTE | 1051 | Unknown table 'test.t27'
468 NOTE | 1051 | Unknown table 'test.t28'
469 NOTE | 1051 | Unknown table 'test.t29'
470 NOTE | 1051 | Unknown table 'test.t30'
471 NOTE | 1051 | Unknown table 'test.a1'
472 NOTE | 1051 | Unknown table 'test.a2'
473 NOTE | 1051 | Unknown table 'test.a3'
474 NOTE | 1051 | Unknown table 'test.a4'
475 NOTE | 1051 | Unknown table 'test.a5'
476 NOTE | 1051 | Unknown table 'test.a6'
477 NOTE | 1051 | Unknown table 'test.a7'
478 NOTE | 1051 | Unknown table 'test.a8'
479 NOTE | 1051 | Unknown table 'test.a9'
480 NOTE | 1051 | Unknown table 'test.a10'
481 NOTE | 1051 | Unknown table 'test.a11'
482 NOTE | 1051 | Unknown table 'test.a12'
483 NOTE | 1051 | Unknown table 'test.a13'
484 NOTE | 1051 | Unknown table 'test.a14'
485 NOTE | 1051 | Unknown table 'test.a15'
486 NOTE | 1051 | Unknown table 'test.a16'
487 NOTE | 1051 | Unknown table 'test.a17'
488 NOTE | 1051 | Unknown table 'test.a18'
489 NOTE | 1051 | Unknown table 'test.a19'
490 NOTE | 1051 | Unknown table 'test.a20'
491 NOTE | 1051 | Unknown table 'test.a21'
492 NOTE | 1051 | Unknown table 'test.a22'
493 NOTE | 1051 | Unknown table 'test.a23'
494 NOTE | 1051 | Unknown table 'test.a24'
495 NOTE | 1051 | Unknown table 'test.a25'
496 NOTE | 1051 | Unknown table 'test.a26'
497 NOTE | 1051 | Unknown table 'test.a27'
498 NOTE | 1051 | Unknown table 'test.a28'
499 NOTE | 1051 | Unknown table 'test.a29'
500 NOTE | 1051 | Unknown table 'test.a30'
501 NOTE | 1051 | Unknown table 'test.aa1'
502 NOTE | 1051 | Unknown table 'test.aa2'
503 NOTE | 1051 | Unknown table 'test.aa3'
504 NOTE | 1051 | Unknown table 'test.aa4'
505 NOTE | 1051 | Unknown table 'test.aa5'
506 NOTE | 1051 | Unknown table 'test.aa6'
507 NOTE | 1051 | Unknown table 'test.aa7'
508 NOTE | 1051 | Unknown table 'test.aa8'
509 NOTE | 1051 | Unknown table 'test.aa9'
510 NOTE | 1051 | Unknown table 'test.aa10'
511 NOTE | 1051 | Unknown table 'test.aa11'
512 NOTE | 1051 | Unknown table 'test.aa12'
513 NOTE | 1051 | Unknown table 'test.aa13'
514 NOTE | 1051 | Unknown table 'test.aa14'
515 NOTE | 1051 | Unknown table 'test.aa15'
516 NOTE | 1051 | Unknown table 'test.aa16'
517 NOTE | 1051 | Unknown table 'test.aa17'
518 NOTE | 1051 | Unknown table 'test.aa18'
519 NOTE | 1051 | Unknown table 'test.aa19'
520 NOTE | 1051 | Unknown table 'test.aa20'
521 NOTE | 1051 | Unknown table 'test.aa21'
522 NOTE | 1051 | Unknown table 'test.aa22'
523 NOTE | 1051 | Unknown table 'test.aa23'
524 NOTE | 1051 | Unknown table 'test.aa24'
525 NOTE | 1051 | Unknown table 'test.aa25'
526 NOTE | 1051 | Unknown table 'test.aa26'
527 NOTE | 1051 | Unknown table 'test.aa27'
528 NOTE | 1051 | Unknown table 'test.aa28'
529 NOTE | 1051 | Unknown table 'test.aa29'
530 NOTE | 1051 | Unknown table 'test.aa30'
531 NOTE | 1051 | Unknown table 'test.aaaa1'
532 NOTE | 1051 | Unknown table 'test.aaaa2'
533 NOTE | 1051 | Unknown table 'test.aaaa3'
534 NOTE | 1051 | Unknown table 'test.aaaa4'
535 NOTE | 1051 | Unknown table 'test.aaaa5'
536 NOTE | 1051 | Unknown table 'test.aaaa6'
537 NOTE | 1051 | Unknown table 'test.aaaa7'
538 NOTE | 1051 | Unknown table 'test.aaaa8'
539 NOTE | 1051 | Unknown table 'test.aaaa9'
540 NOTE | 1051 | Unknown table 'test.aaaa10'
541 NOTE | 1051 | Unknown table 'test.aaaa11'
542 NOTE | 1051 | Unknown table 'test.aaaa12'
543 NOTE | 1051 | Unknown table 'test.aaaa13'
544 NOTE | 1051 | Unknown table 'test.aaaa14'
545 NOTE | 1051 | Unknown table 'test.aaaa15'
546 NOTE | 1051 | Unknown table 'test.aaaa16'
547 NOTE | 1051 | Unknown table 'test.aaaa17'
548 NOTE | 1051 | Unknown table 'test.aaaa18'
549 NOTE | 1051 | Unknown table 'test.aaaa19'
550 NOTE | 1051 | Unknown table 'test.aaaa20'
551 NOTE | 1051 | Unknown table 'test.aaaa21'
552 NOTE | 1051 | Unknown table 'test.aaaa22'
553 NOTE | 1051 | Unknown table 'test.aaaa23'
554 NOTE | 1051 | Unknown table 'test.aaaa24'
555 NOTE | 1051 | Unknown table 'test.aaaa25'
556 NOTE | 1051 | Unknown table 'test.aaaa26'
557 NOTE | 1051 | Unknown table 'test.aaaa27'
558 NOTE | 1051 | Unknown table 'test.aaaa28'
559 NOTE | 1051 | Unknown table 'test.aaaa29'
560 NOTE | 1051 | Unknown table 'test.aaaa30'
561 NOTE | 1051 | Unknown table 'test.bb1'
562 NOTE | 1051 | Unknown table 'test.bb2'
563 NOTE | 1051 | Unknown table 'test.bb3'
564 NOTE | 1051 | Unknown table 'test.bb4'
565 NOTE | 1051 | Unknown table 'test.bb5'
566 NOTE | 1051 | Unknown table 'test.bb6'
567 NOTE | 1051 | Unknown table 'test.bb7'
568 NOTE | 1051 | Unknown table 'test.bb8'
569 NOTE | 1051 | Unknown table 'test.bb9'
570 NOTE | 1051 | Unknown table 'test.bb10'
571 NOTE | 1051 | Unknown table 'test.bb11'
572 NOTE | 1051 | Unknown table 'test.bb12'
573 NOTE | 1051 | Unknown table 'test.bb13'
574 NOTE | 1051 | Unknown table 'test.bb14'
575 NOTE | 1051 | Unknown table 'test.bb15'
576 NOTE | 1051 | Unknown table 'test.bb16'
577 NOTE | 1051 | Unknown table 'test.bb17'
578 NOTE | 1051 | Unknown table 'test.bb18'
579 NOTE | 1051 | Unknown table 'test.bb19'
580 NOTE | 1051 | Unknown table 'test.bb20'
581 NOTE | 1051 | Unknown table 'test.bb21'
582 NOTE | 1051 | Unknown table 'test.bb22'
583 NOTE | 1051 | Unknown table 'test.bb23'
584 NOTE | 1051 | Unknown table 'test.bb24'
585 NOTE | 1051 | Unknown table 'test.bb25'
586 NOTE | 1051 | Unknown table 'test.bb26'
587 NOTE | 1051 | Unknown table 'test.bb27'
588 NOTE | 1051 | Unknown table 'test.bb28'
589 NOTE | 1051 | Unknown table 'test.bb29'
590 NOTE | 1051 | Unknown table 'test.bb30'
591 NOTE | 1051 | Unknown table 'test.b1'
592 NOTE | 1051 | Unknown table 'test.b2'
593 NOTE | 1051 | Unknown table 'test.b3'
594 NOTE | 1051 | Unknown table 'test.b4'
595 NOTE | 1051 | Unknown table 'test.b5'
596 NOTE | 1051 | Unknown table 'test.b6'
597 NOTE | 1051 | Unknown table 'test.b7'
598 NOTE | 1051 | Unknown table 'test.b8'
599 NOTE | 1051 | Unknown table 'test.b9'
600 NOTE | 1051 | Unknown table 'test.b10'
601 NOTE | 1051 | Unknown table 'test.b11'
602 NOTE | 1051 | Unknown table 'test.b12'
603 NOTE | 1051 | Unknown table 'test.b13'
604 NOTE | 1051 | Unknown table 'test.b14'
605 NOTE | 1051 | Unknown table 'test.b15'
606 NOTE | 1051 | Unknown table 'test.b16'
607 NOTE | 1051 | Unknown table 'test.b17'
608 NOTE | 1051 | Unknown table 'test.b18'
609 NOTE | 1051 | Unknown table 'test.b19'
610 NOTE | 1051 | Unknown table 'test.b20'
611 NOTE | 1051 | Unknown table 'test.b21'
612 NOTE | 1051 | Unknown table 'test.b22'
613 NOTE | 1051 | Unknown table 'test.b23'
614 NOTE | 1051 | Unknown table 'test.b24'
615 NOTE | 1051 | Unknown table 'test.b25'
616 NOTE | 1051 | Unknown table 'test.b26'
617 NOTE | 1051 | Unknown table 'test.b27'
618 NOTE | 1051 | Unknown table 'test.b28'
619 NOTE | 1051 | Unknown table 'test.b29'
620 NOTE | 1051 | Unknown table 'test.b30'
621 Got expected warning: 1051
622
623 ##
624 ## Check no warnings based on max_error_count parameter set
625 RUN set max_error_count=0
626
627 0 rows affected
628 RUN drop tables if exists t1,t2
629
630 0 rows affected
631 RUN set max_error_count=-64
632
633 0 rows affected
634 RUN show variables like 'max_error_count'
635 Variable_name Value
636 max_error_count 0
637 0 rows affected
638 RUN set max_error_count=64
639
640 0 rows affected
641
642 ##
643 ## Checking creating temporary table when normal and temp table exists
644 RUN use test
645
646 0 rows affected
647 RUN create table if not exists t1 (a int) select 2 as a
648
649 1 rows affected
650 Records: 1 Duplicates: 0 Warnings: 0
651 RUN create temporary table t1 (a int) select 2 as a
652
653 1 rows affected
654 Records: 1 Duplicates: 0 Warnings: 0
655 RUN select * from t1
656 a
657 2
658 0 rows affected
659 RUN create temporary table if not exists t1 (a int) select 2 as a
660
661 0 rows affected
662 Warnings generated:
663 NOTE | 1050 | Table 't1' already exists
664 Got expected warning: 1050
665 RUN select * from t1
666 a
667 2
668 0 rows affected
669 RUN drop temporary table t1
670
671 0 rows affected
672 RUN drop table t1
673
674 0 rows affected
675
676 ##
677 ## Checking data truncation warnings for default values
678 RUN use test
679
680 0 rows affected
681 RUN CREATE TABLE t1 SELECT 0.123456789012345678901234567890123456 AS f1
682
683 1 rows affected
684 Records: 1 Duplicates: 0 Warnings: 1
685 Warnings generated:
686 NOTE | 1265 | Data truncated for column 'f1' at row 1
687 Got expected warning: 1265
688 RUN drop table t1
689
690 0 rows affected
691
692 ##
693 ## Checking data truncation warnings while creating table with expression
694 RUN use test
695
696 0 rows affected
697 RUN create table t1 as select 5.05 / 0.014
698
699 1 rows affected
700 Records: 1 Duplicates: 0 Warnings: 1
701 Warnings generated:
702 NOTE | 1265 | Data truncated for column '5.05 / 0.014' at row 1
703 Got expected warning: 1265
704 RUN drop table t1
705
706 0 rows affected
707
708 ##
709 ## Checking warnings with insert and select operations
710 ## Below insert into t1 returns 17775 warnings,checking only limited warnings as test takes more time to render the warnings
711 RUN use test
712
713 0 rows affected
714 RUN create table t2 (a char(1))
715
716 0 rows affected
717 RUN insert into t2 values ('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7')
718
719 8 rows affected
720 Records: 8 Duplicates: 0 Warnings: 0
721 RUN insert into t2 values ('8'),('9'),('A'),('B'),('C'),('D'),('E'),('F')
722
723 8 rows affected
724 Records: 8 Duplicates: 0 Warnings: 0
725 RUN create table t1 (a varchar(2) character set cp932) engine=myisam
726
727 0 rows affected
728
729 ##
730 ## Checking for more than default 64 warnings
731 RUN set max_error_count=500
732
733 0 rows affected
734 RUN insert into t1 select unhex(concat(t24.a, t23.a, t22.a, t21.a)) from t2 t21, t2 t22, t2 t23, t2 t24
735 ORDER BY t24.a, t23.a, t22.a, t21.a
736
737 65536 rows affected
738 Records: 65536 Duplicates: 0 Warnings: 17775
739 Warnings generated:
740 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 129
741 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 130
742 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 131
743 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 132
744 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 133
745 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 134
746 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 135
747 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 136
748 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 137
749 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 138
750 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 139
751 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 140
752 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 141
753 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 142
754 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 143
755 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 144
756 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 145
757 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 146
758 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 147
759 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 148
760 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 149
761 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 150
762 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 151
763 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 152
764 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 153
765 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 154
766 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 155
767 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 156
768 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 157
769 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 158
770 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 159
771 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 160
772 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 161
773 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 225
774 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 226
775 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 227
776 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 228
777 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 229
778 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 230
779 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 231
780 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 232
781 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 233
782 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 234
783 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 235
784 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 236
785 WARNING | 1366 | Incorrect string value: '\xEC' for column 'a' at row 237
786 WARNING | 1366 | Incorrect string value: '\xED' for column 'a' at row 238
787 WARNING | 1366 | Incorrect string value: '\xEE' for column 'a' at row 239
788 WARNING | 1366 | Incorrect string value: '\xEF' for column 'a' at row 240
789 WARNING | 1366 | Incorrect string value: '\xF0' for column 'a' at row 241
790 WARNING | 1366 | Incorrect string value: '\xF1' for column 'a' at row 242
791 WARNING | 1366 | Incorrect string value: '\xF2' for column 'a' at row 243
792 WARNING | 1366 | Incorrect string value: '\xF3' for column 'a' at row 244
793 WARNING | 1366 | Incorrect string value: '\xF4' for column 'a' at row 245
794 WARNING | 1366 | Incorrect string value: '\xF5' for column 'a' at row 246
795 WARNING | 1366 | Incorrect string value: '\xF6' for column 'a' at row 247
796 WARNING | 1366 | Incorrect string value: '\xF7' for column 'a' at row 248
797 WARNING | 1366 | Incorrect string value: '\xF8' for column 'a' at row 249
798 WARNING | 1366 | Incorrect string value: '\xF9' for column 'a' at row 250
799 WARNING | 1366 | Incorrect string value: '\xFA' for column 'a' at row 251
800 WARNING | 1366 | Incorrect string value: '\xFB' for column 'a' at row 252
801 WARNING | 1366 | Incorrect string value: '\xFC' for column 'a' at row 253
802 WARNING | 1366 | Incorrect string value: '\xFD' for column 'a' at row 254
803 WARNING | 1366 | Incorrect string value: '\xFE' for column 'a' at row 255
804 WARNING | 1366 | Incorrect string value: '\xFF' for column 'a' at row 256
805 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 385
806 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 386
807 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 387
808 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 388
809 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 389
810 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 390
811 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 391
812 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 392
813 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 393
814 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 394
815 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 395
816 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 396
817 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 397
818 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 398
819 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 399
820 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 400
821 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 401
822 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 402
823 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 403
824 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 404
825 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 405
826 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 406
827 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 407
828 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 408
829 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 409
830 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 410
831 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 411
832 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 412
833 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 413
834 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 414
835 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 415
836 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 416
837 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 417
838 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 481
839 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 482
840 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 483
841 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 484
842 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 485
843 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 486
844 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 487
845 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 488
846 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 489
847 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 490
848 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 491
849 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 492
850 WARNING | 1366 | Incorrect string value: '\xEC' for column 'a' at row 493
851 WARNING | 1366 | Incorrect string value: '\xED' for column 'a' at row 494
852 WARNING | 1366 | Incorrect string value: '\xEE' for column 'a' at row 495
853 WARNING | 1366 | Incorrect string value: '\xEF' for column 'a' at row 496
854 WARNING | 1366 | Incorrect string value: '\xF0' for column 'a' at row 497
855 WARNING | 1366 | Incorrect string value: '\xF1' for column 'a' at row 498
856 WARNING | 1366 | Incorrect string value: '\xF2' for column 'a' at row 499
857 WARNING | 1366 | Incorrect string value: '\xF3' for column 'a' at row 500
858 WARNING | 1366 | Incorrect string value: '\xF4' for column 'a' at row 501
859 WARNING | 1366 | Incorrect string value: '\xF5' for column 'a' at row 502
860 WARNING | 1366 | Incorrect string value: '\xF6' for column 'a' at row 503
861 WARNING | 1366 | Incorrect string value: '\xF7' for column 'a' at row 504
862 WARNING | 1366 | Incorrect string value: '\xF8' for column 'a' at row 505
863 WARNING | 1366 | Incorrect string value: '\xF9' for column 'a' at row 506
864 WARNING | 1366 | Incorrect string value: '\xFA' for column 'a' at row 507
865 WARNING | 1366 | Incorrect string value: '\xFB' for column 'a' at row 508
866 WARNING | 1366 | Incorrect string value: '\xFC' for column 'a' at row 509
867 WARNING | 1366 | Incorrect string value: '\xFD' for column 'a' at row 510
868 WARNING | 1366 | Incorrect string value: '\xFE' for column 'a' at row 511
869 WARNING | 1366 | Incorrect string value: '\xFF' for column 'a' at row 512
870 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 641
871 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 642
872 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 643
873 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 644
874 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 645
875 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 646
876 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 647
877 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 648
878 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 649
879 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 650
880 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 651
881 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 652
882 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 653
883 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 654
884 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 655
885 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 656
886 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 657
887 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 658
888 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 659
889 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 660
890 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 661
891 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 662
892 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 663
893 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 664
894 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 665
895 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 666
896 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 667
897 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 668
898 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 669
899 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 670
900 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 671
901 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 672
902 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 673
903 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 737
904 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 738
905 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 739
906 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 740
907 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 741
908 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 742
909 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 743
910 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 744
911 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 745
912 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 746
913 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 747
914 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 748
915 WARNING | 1366 | Incorrect string value: '\xEC' for column 'a' at row 749
916 WARNING | 1366 | Incorrect string value: '\xED' for column 'a' at row 750
917 WARNING | 1366 | Incorrect string value: '\xEE' for column 'a' at row 751
918 WARNING | 1366 | Incorrect string value: '\xEF' for column 'a' at row 752
919 WARNING | 1366 | Incorrect string value: '\xF0' for column 'a' at row 753
920 WARNING | 1366 | Incorrect string value: '\xF1' for column 'a' at row 754
921 WARNING | 1366 | Incorrect string value: '\xF2' for column 'a' at row 755
922 WARNING | 1366 | Incorrect string value: '\xF3' for column 'a' at row 756
923 WARNING | 1366 | Incorrect string value: '\xF4' for column 'a' at row 757
924 WARNING | 1366 | Incorrect string value: '\xF5' for column 'a' at row 758
925 WARNING | 1366 | Incorrect string value: '\xF6' for column 'a' at row 759
926 WARNING | 1366 | Incorrect string value: '\xF7' for column 'a' at row 760
927 WARNING | 1366 | Incorrect string value: '\xF8' for column 'a' at row 761
928 WARNING | 1366 | Incorrect string value: '\xF9' for column 'a' at row 762
929 WARNING | 1366 | Incorrect string value: '\xFA' for column 'a' at row 763
930 WARNING | 1366 | Incorrect string value: '\xFB' for column 'a' at row 764
931 WARNING | 1366 | Incorrect string value: '\xFC' for column 'a' at row 765
932 WARNING | 1366 | Incorrect string value: '\xFD' for column 'a' at row 766
933 WARNING | 1366 | Incorrect string value: '\xFE' for column 'a' at row 767
934 WARNING | 1366 | Incorrect string value: '\xFF' for column 'a' at row 768
935 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 897
936 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 898
937 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 899
938 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 900
939 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 901
940 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 902
941 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 903
942 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 904
943 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 905
944 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 906
945 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 907
946 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 908
947 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 909
948 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 910
949 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 911
950 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 912
951 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 913
952 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 914
953 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 915
954 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 916
955 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 917
956 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 918
957 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 919
958 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 920
959 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 921
960 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 922
961 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 923
962 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 924
963 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 925
964 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 926
965 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 927
966 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 928
967 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 929
968 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 993
969 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 994
970 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 995
971 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 996
972 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 997
973 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 998
974 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 999
975 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 1000
976 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 1001
977 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 1002
978 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 1003
979 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 1004
980 WARNING | 1366 | Incorrect string value: '\xEC' for column 'a' at row 1005
981 WARNING | 1366 | Incorrect string value: '\xED' for column 'a' at row 1006
982 WARNING | 1366 | Incorrect string value: '\xEE' for column 'a' at row 1007
983 WARNING | 1366 | Incorrect string value: '\xEF' for column 'a' at row 1008
984 WARNING | 1366 | Incorrect string value: '\xF0' for column 'a' at row 1009
985 WARNING | 1366 | Incorrect string value: '\xF1' for column 'a' at row 1010
986 WARNING | 1366 | Incorrect string value: '\xF2' for column 'a' at row 1011
987 WARNING | 1366 | Incorrect string value: '\xF3' for column 'a' at row 1012
988 WARNING | 1366 | Incorrect string value: '\xF4' for column 'a' at row 1013
989 WARNING | 1366 | Incorrect string value: '\xF5' for column 'a' at row 1014
990 WARNING | 1366 | Incorrect string value: '\xF6' for column 'a' at row 1015
991 WARNING | 1366 | Incorrect string value: '\xF7' for column 'a' at row 1016
992 WARNING | 1366 | Incorrect string value: '\xF8' for column 'a' at row 1017
993 WARNING | 1366 | Incorrect string value: '\xF9' for column 'a' at row 1018
994 WARNING | 1366 | Incorrect string value: '\xFA' for column 'a' at row 1019
995 WARNING | 1366 | Incorrect string value: '\xFB' for column 'a' at row 1020
996 WARNING | 1366 | Incorrect string value: '\xFC' for column 'a' at row 1021
997 WARNING | 1366 | Incorrect string value: '\xFD' for column 'a' at row 1022
998 WARNING | 1366 | Incorrect string value: '\xFE' for column 'a' at row 1023
999 WARNING | 1366 | Incorrect string value: '\xFF' for column 'a' at row 1024
1000 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 1153
1001 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 1154
1002 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 1155
1003 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 1156
1004 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 1157
1005 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 1158
1006 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 1159
1007 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 1160
1008 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 1161
1009 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 1162
1010 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 1163
1011 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 1164
1012 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 1165
1013 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 1166
1014 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 1167
1015 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 1168
1016 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 1169
1017 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 1170
1018 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 1171
1019 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 1172
1020 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 1173
1021 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 1174
1022 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 1175
1023 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 1176
1024 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 1177
1025 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 1178
1026 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 1179
1027 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 1180
1028 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 1181
1029 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 1182
1030 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 1183
1031 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 1184
1032 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 1185
1033 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 1249
1034 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 1250
1035 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 1251
1036 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 1252
1037 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 1253
1038 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 1254
1039 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 1255
1040 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 1256
1041 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 1257
1042 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 1258
1043 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 1259
1044 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 1260
1045 WARNING | 1366 | Incorrect string value: '\xEC' for column 'a' at row 1261
1046 WARNING | 1366 | Incorrect string value: '\xED' for column 'a' at row 1262
1047 WARNING | 1366 | Incorrect string value: '\xEE' for column 'a' at row 1263
1048 WARNING | 1366 | Incorrect string value: '\xEF' for column 'a' at row 1264
1049 WARNING | 1366 | Incorrect string value: '\xF0' for column 'a' at row 1265
1050 WARNING | 1366 | Incorrect string value: '\xF1' for column 'a' at row 1266
1051 WARNING | 1366 | Incorrect string value: '\xF2' for column 'a' at row 1267
1052 WARNING | 1366 | Incorrect string value: '\xF3' for column 'a' at row 1268
1053 WARNING | 1366 | Incorrect string value: '\xF4' for column 'a' at row 1269
1054 WARNING | 1366 | Incorrect string value: '\xF5' for column 'a' at row 1270
1055 WARNING | 1366 | Incorrect string value: '\xF6' for column 'a' at row 1271
1056 WARNING | 1366 | Incorrect string value: '\xF7' for column 'a' at row 1272
1057 WARNING | 1366 | Incorrect string value: '\xF8' for column 'a' at row 1273
1058 WARNING | 1366 | Incorrect string value: '\xF9' for column 'a' at row 1274
1059 WARNING | 1366 | Incorrect string value: '\xFA' for column 'a' at row 1275
1060 WARNING | 1366 | Incorrect string value: '\xFB' for column 'a' at row 1276
1061 WARNING | 1366 | Incorrect string value: '\xFC' for column 'a' at row 1277
1062 WARNING | 1366 | Incorrect string value: '\xFD' for column 'a' at row 1278
1063 WARNING | 1366 | Incorrect string value: '\xFE' for column 'a' at row 1279
1064 WARNING | 1366 | Incorrect string value: '\xFF' for column 'a' at row 1280
1065 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 1409
1066 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 1410
1067 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 1411
1068 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 1412
1069 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 1413
1070 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 1414
1071 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 1415
1072 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 1416
1073 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 1417
1074 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 1418
1075 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 1419
1076 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 1420
1077 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 1421
1078 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 1422
1079 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 1423
1080 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 1424
1081 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 1425
1082 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 1426
1083 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 1427
1084 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 1428
1085 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 1429
1086 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 1430
1087 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 1431
1088 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 1432
1089 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 1433
1090 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 1434
1091 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 1435
1092 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 1436
1093 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 1437
1094 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 1438
1095 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 1439
1096 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 1440
1097 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 1441
1098 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 1505
1099 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 1506
1100 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 1507
1101 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 1508
1102 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 1509
1103 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 1510
1104 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 1511
1105 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 1512
1106 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 1513
1107 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 1514
1108 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 1515
1109 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 1516
1110 WARNING | 1366 | Incorrect string value: '\xEC' for column 'a' at row 1517
1111 WARNING | 1366 | Incorrect string value: '\xED' for column 'a' at row 1518
1112 WARNING | 1366 | Incorrect string value: '\xEE' for column 'a' at row 1519
1113 WARNING | 1366 | Incorrect string value: '\xEF' for column 'a' at row 1520
1114 WARNING | 1366 | Incorrect string value: '\xF0' for column 'a' at row 1521
1115 WARNING | 1366 | Incorrect string value: '\xF1' for column 'a' at row 1522
1116 WARNING | 1366 | Incorrect string value: '\xF2' for column 'a' at row 1523
1117 WARNING | 1366 | Incorrect string value: '\xF3' for column 'a' at row 1524
1118 WARNING | 1366 | Incorrect string value: '\xF4' for column 'a' at row 1525
1119 WARNING | 1366 | Incorrect string value: '\xF5' for column 'a' at row 1526
1120 WARNING | 1366 | Incorrect string value: '\xF6' for column 'a' at row 1527
1121 WARNING | 1366 | Incorrect string value: '\xF7' for column 'a' at row 1528
1122 WARNING | 1366 | Incorrect string value: '\xF8' for column 'a' at row 1529
1123 WARNING | 1366 | Incorrect string value: '\xF9' for column 'a' at row 1530
1124 WARNING | 1366 | Incorrect string value: '\xFA' for column 'a' at row 1531
1125 WARNING | 1366 | Incorrect string value: '\xFB' for column 'a' at row 1532
1126 WARNING | 1366 | Incorrect string value: '\xFC' for column 'a' at row 1533
1127 WARNING | 1366 | Incorrect string value: '\xFD' for column 'a' at row 1534
1128 WARNING | 1366 | Incorrect string value: '\xFE' for column 'a' at row 1535
1129 WARNING | 1366 | Incorrect string value: '\xFF' for column 'a' at row 1536
1130 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 1665
1131 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 1666
1132 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 1667
1133 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 1668
1134 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 1669
1135 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 1670
1136 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 1671
1137 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 1672
1138 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 1673
1139 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 1674
1140 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 1675
1141 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 1676
1142 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 1677
1143 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 1678
1144 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 1679
1145 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 1680
1146 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 1681
1147 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 1682
1148 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 1683
1149 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 1684
1150 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 1685
1151 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 1686
1152 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 1687
1153 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 1688
1154 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 1689
1155 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 1690
1156 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 1691
1157 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 1692
1158 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 1693
1159 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 1694
1160 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 1695
1161 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 1696
1162 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 1697
1163 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 1761
1164 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 1762
1165 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 1763
1166 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 1764
1167 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 1765
1168 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 1766
1169 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 1767
1170 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 1768
1171 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 1769
1172 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 1770
1173 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 1771
1174 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 1772
1175 WARNING | 1366 | Incorrect string value: '\xEC' for column 'a' at row 1773
1176 WARNING | 1366 | Incorrect string value: '\xED' for column 'a' at row 1774
1177 WARNING | 1366 | Incorrect string value: '\xEE' for column 'a' at row 1775
1178 WARNING | 1366 | Incorrect string value: '\xEF' for column 'a' at row 1776
1179 WARNING | 1366 | Incorrect string value: '\xF0' for column 'a' at row 1777
1180 WARNING | 1366 | Incorrect string value: '\xF1' for column 'a' at row 1778
1181 WARNING | 1366 | Incorrect string value: '\xF2' for column 'a' at row 1779
1182 WARNING | 1366 | Incorrect string value: '\xF3' for column 'a' at row 1780
1183 WARNING | 1366 | Incorrect string value: '\xF4' for column 'a' at row 1781
1184 WARNING | 1366 | Incorrect string value: '\xF5' for column 'a' at row 1782
1185 WARNING | 1366 | Incorrect string value: '\xF6' for column 'a' at row 1783
1186 WARNING | 1366 | Incorrect string value: '\xF7' for column 'a' at row 1784
1187 WARNING | 1366 | Incorrect string value: '\xF8' for column 'a' at row 1785
1188 WARNING | 1366 | Incorrect string value: '\xF9' for column 'a' at row 1786
1189 WARNING | 1366 | Incorrect string value: '\xFA' for column 'a' at row 1787
1190 WARNING | 1366 | Incorrect string value: '\xFB' for column 'a' at row 1788
1191 WARNING | 1366 | Incorrect string value: '\xFC' for column 'a' at row 1789
1192 WARNING | 1366 | Incorrect string value: '\xFD' for column 'a' at row 1790
1193 WARNING | 1366 | Incorrect string value: '\xFE' for column 'a' at row 1791
1194 WARNING | 1366 | Incorrect string value: '\xFF' for column 'a' at row 1792
1195 WARNING | 1366 | Incorrect string value: '\x80' for column 'a' at row 1921
1196 WARNING | 1366 | Incorrect string value: '\x81' for column 'a' at row 1922
1197 WARNING | 1366 | Incorrect string value: '\x82' for column 'a' at row 1923
1198 WARNING | 1366 | Incorrect string value: '\x83' for column 'a' at row 1924
1199 WARNING | 1366 | Incorrect string value: '\x84' for column 'a' at row 1925
1200 WARNING | 1366 | Incorrect string value: '\x85' for column 'a' at row 1926
1201 WARNING | 1366 | Incorrect string value: '\x86' for column 'a' at row 1927
1202 WARNING | 1366 | Incorrect string value: '\x87' for column 'a' at row 1928
1203 WARNING | 1366 | Incorrect string value: '\x88' for column 'a' at row 1929
1204 WARNING | 1366 | Incorrect string value: '\x89' for column 'a' at row 1930
1205 WARNING | 1366 | Incorrect string value: '\x8A' for column 'a' at row 1931
1206 WARNING | 1366 | Incorrect string value: '\x8B' for column 'a' at row 1932
1207 WARNING | 1366 | Incorrect string value: '\x8C' for column 'a' at row 1933
1208 WARNING | 1366 | Incorrect string value: '\x8D' for column 'a' at row 1934
1209 WARNING | 1366 | Incorrect string value: '\x8E' for column 'a' at row 1935
1210 WARNING | 1366 | Incorrect string value: '\x8F' for column 'a' at row 1936
1211 WARNING | 1366 | Incorrect string value: '\x90' for column 'a' at row 1937
1212 WARNING | 1366 | Incorrect string value: '\x91' for column 'a' at row 1938
1213 WARNING | 1366 | Incorrect string value: '\x92' for column 'a' at row 1939
1214 WARNING | 1366 | Incorrect string value: '\x93' for column 'a' at row 1940
1215 WARNING | 1366 | Incorrect string value: '\x94' for column 'a' at row 1941
1216 WARNING | 1366 | Incorrect string value: '\x95' for column 'a' at row 1942
1217 WARNING | 1366 | Incorrect string value: '\x96' for column 'a' at row 1943
1218 WARNING | 1366 | Incorrect string value: '\x97' for column 'a' at row 1944
1219 WARNING | 1366 | Incorrect string value: '\x98' for column 'a' at row 1945
1220 WARNING | 1366 | Incorrect string value: '\x99' for column 'a' at row 1946
1221 WARNING | 1366 | Incorrect string value: '\x9A' for column 'a' at row 1947
1222 WARNING | 1366 | Incorrect string value: '\x9B' for column 'a' at row 1948
1223 WARNING | 1366 | Incorrect string value: '\x9C' for column 'a' at row 1949
1224 WARNING | 1366 | Incorrect string value: '\x9D' for column 'a' at row 1950
1225 WARNING | 1366 | Incorrect string value: '\x9E' for column 'a' at row 1951
1226 WARNING | 1366 | Incorrect string value: '\x9F' for column 'a' at row 1952
1227 WARNING | 1366 | Incorrect string value: '\xA0' for column 'a' at row 1953
1228 WARNING | 1366 | Incorrect string value: '\xE0' for column 'a' at row 2017
1229 WARNING | 1366 | Incorrect string value: '\xE1' for column 'a' at row 2018
1230 WARNING | 1366 | Incorrect string value: '\xE2' for column 'a' at row 2019
1231 WARNING | 1366 | Incorrect string value: '\xE3' for column 'a' at row 2020
1232 WARNING | 1366 | Incorrect string value: '\xE4' for column 'a' at row 2021
1233 WARNING | 1366 | Incorrect string value: '\xE5' for column 'a' at row 2022
1234 WARNING | 1366 | Incorrect string value: '\xE6' for column 'a' at row 2023
1235 WARNING | 1366 | Incorrect string value: '\xE7' for column 'a' at row 2024
1236 WARNING | 1366 | Incorrect string value: '\xE8' for column 'a' at row 2025
1237 WARNING | 1366 | Incorrect string value: '\xE9' for column 'a' at row 2026
1238 WARNING | 1366 | Incorrect string value: '\xEA' for column 'a' at row 2027
1239 WARNING | 1366 | Incorrect string value: '\xEB' for column 'a' at row 2028
1240 Got expected warning: 1366
1241 RUN set max_error_count=64
1242
1243 0 rows affected
1244 RUN drop tables t1,t2
1245
1246 0 rows affected
1247
1248 ##
1249 ## Checking warnings with prepare and execute statements
1250 RUN use test
1251
1252 0 rows affected
1253 RUN CREATE TABLE t1(f1 VARCHAR(6) NOT NULL, FULLTEXT KEY(f1), UNIQUE(f1))
1254
1255 0 rows affected
1256 RUN INSERT INTO t1 VALUES ('test')
1257
1258 1 rows affected
1259 RUN SELECT 1 FROM t1 WHERE 1 > ALL((SELECT 1 FROM t1 JOIN t1 a ON (MATCH(t1.f1) against ("")) WHERE t1.f1 GROUP BY t1.f1)) xor f1
1260 1
1261 1
1262 0 rows affected
1263 Warnings generated:
1264 WARNING | 1292 | Truncated incorrect DOUBLE value: 'test'
1265 Got expected warning: 1292
1266 RUN PREPARE stmt FROM 'SELECT 1 FROM t1 WHERE 1 > ALL((SELECT 1 FROM t1 RIGHT OUTER JOIN t1 a ON (MATCH(t1.f1) against ("")) WHERE t1.f1 GROUP BY t1.f1)) xor f1'
1267
1268 0 rows affected
1269 Statement prepared
1270 RUN EXECUTE stmt
1271 1
1272 1
1273 0 rows affected
1274 Warnings generated:
1275 WARNING | 1292 | Truncated incorrect DOUBLE value: 'test'
1276 Got expected warning: 1292
1277 RUN EXECUTE stmt
1278 1
1279 1
1280 0 rows affected
1281 Warnings generated:
1282 WARNING | 1292 | Truncated incorrect DOUBLE value: 'test'
1283 Got expected warning: 1292
1284 RUN DEALLOCATE PREPARE stmt
1285
1286 0 rows affected
1287 RUN PREPARE stmt FROM 'SELECT 1 FROM t1 WHERE 1 > ALL((SELECT 1 FROM t1 JOIN t1 a ON (MATCH(t1.f1) against ("")) WHERE t1.f1 GROUP BY t1.f1))'
1288
1289 0 rows affected
1290 Statement prepared
1291 RUN EXECUTE stmt
1292 1
1293 1
1294 0 rows affected
1295 RUN EXECUTE stmt
1296 1
1297 1
1298 0 rows affected
1299 RUN DEALLOCATE PREPARE stmt
1300
1301 0 rows affected
1302 RUN drop table t1
1303
1304 0 rows affected
1305
1306 ##
1307 ## Checking warnings with group by when sql_mode is no_engine_substitution
1308 RUN use test
1309
1310 0 rows affected
1311 RUN SET sql_mode = 'NO_ENGINE_SUBSTITUTION'
1312
1313 0 rows affected
1314 RUN create table t1 (c1 char(3), c2 char(3))
1315
1316 0 rows affected
1317 RUN create table t2 (c3 char(3), c4 char(3))
1318
1319 0 rows affected
1320 RUN insert into t1 values ('aaa', 'bb1'), ('aaa', 'bb2')
1321
1322 2 rows affected
1323 Records: 2 Duplicates: 0 Warnings: 0
1324 RUN insert into t2 values ('aaa', 'bb1'), ('aaa', 'bb2')
1325
1326 2 rows affected
1327 Records: 2 Duplicates: 0 Warnings: 0
1328 RUN select t1.c1 as c2 from t1, t2 where t1.c2 = t2.c4 group by c2
1329 c2
1330 aaa
1331 aaa
1332 0 rows affected
1333 Warnings generated:
1334 WARNING | 1052 | Column 'c2' in group statement is ambiguous
1335 Got expected warning: 1052
1336 RUN select t1.c1 as c2 from t1, t2 where t1.c2 = t2.c4 group by t1.c1
1337 c2
1338 aaa
1339 0 rows affected
1340 RUN drop table t1, t2
1341
1342 0 rows affected
1343
1344 ##
1345 ## Setting back to default of sql_mode
1346 RUN SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'
1347
1348 0 rows affected
1349 Warnings generated:
1350 WARNING | 3135 | 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
1351 Got expected warning: 3135
1352
1353 ##
1354 ## Checking with group by where both error and warnings expected with default sql_mode
1355 RUN use test
1356
1357 0 rows affected
1358 RUN create table t1 (c1 char(3), c2 char(3))
1359
1360 0 rows affected
1361 RUN create table t2 (c3 char(3), c4 char(3))
1362
1363 0 rows affected
1364 RUN insert into t1 values ('aaa', 'bb1'), ('aaa', 'bb2')
1365
1366 2 rows affected
1367 Records: 2 Duplicates: 0 Warnings: 0
1368 RUN insert into t2 values ('aaa', 'bb1'), ('aaa', 'bb2')
1369
1370 2 rows affected
1371 Records: 2 Duplicates: 0 Warnings: 0
1372 RUN select t1.c1 as c2 from t1, t2 where t1.c2 = t2.c4 group by c2
1373 Warnings generated:
1374 WARNING | 1052 | Column 'c2' in group statement is ambiguous
1375 While executing select t1.c1 as c2 from t1, t2 where t1.c2 = t2.c4 group by c2:
1376 Got expected error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.t1.c1' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (code 1055)
1377 Got expected warning: 1052
1378
1379 ##
1380 ## Expect both error and warning
1381 RUN select t1.c1 as c2 from t1, t2 where t1.c2 = t2.c4 group by t1.c1
1382 c2
1383 aaa
1384 0 rows affected
1385 RUN drop table t1, t2
1386
1387 0 rows affected
1388
1389 ##
1390 ## Checking warnings with rollback on non-transactional tables
1391 RUN use test
1392
1393 0 rows affected
1394 RUN create table t1 (n int not null primary key) engine=myisam
1395
1396 0 rows affected
1397 RUN begin work
1398
1399 0 rows affected
1400 RUN insert into t1 values (4)
1401
1402 1 rows affected
1403 RUN insert into t1 values (5)
1404
1405 1 rows affected
1406 RUN rollback
1407
1408 0 rows affected
1409 Warnings generated:
1410 WARNING | 1196 | Some non-transactional changed tables couldn't be rolled back
1411 Got expected warning: 1196
1412 RUN show warnings
1413 Level Code Message
1414 Warning 1196 Some non-transactional changed tables couldn't be rolled back
1415 0 rows affected
1416 RUN show errors
1417 Level Code Message
1418 0 rows affected
1419 RUN select @@warning_count,@@error_count
1420 @@warning_count @@error_count
1421 1 0
1422 0 rows affected
1423 RUN select * from t1
1424 n
1425 4
1426 5
1427 0 rows affected
1428 RUN show warnings
1429 Level Code Message
1430 0 rows affected
1431 RUN select @@warning_count
1432 @@warning_count
1433 0
1434 0 rows affected
1435 RUN drop table t1
1436
1437 0 rows affected
1438
1439 ##
1440 ## Expect 2 warnings for insert related to truncation and incorrect date value
1441 RUN use test
1442
1443 0 rows affected
1444 RUN set sql_mode=''
1445
1446 0 rows affected
1447 RUN create table t1 (
1448 a date not null,
1449 b mediumtext generated always as ((a not in (a,a))) virtual,
1450 c timestamp generated always as ((a not in (b,b))) stored not null
1451 )
1452
1453 0 rows affected
1454 RUN insert t1(a) values(7777777777)
1455
1456 1 rows affected
1457 Records: 1 Duplicates: 0 Warnings: 2
1458 Warnings generated:
1459 WARNING | 1265 | Data truncated for column 'a' at row 1
1460 WARNING | 1292 | Incorrect date value: '0' for column 'a' at row 1
1461 Got expected warnings: 1265 1292
1462 RUN drop table t1
1463
1464 0 rows affected
1465 RUN SET sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION'
1466
1467 0 rows affected
1468 Warnings generated:
1469 WARNING | 3135 | 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
1470 Got expected warning: 3135
1471
1472 ##
1473 ## Checking warnings while creating index which is more than row size
1474 RUN use test
1475
1476 0 rows affected
1477 RUN create table worklog5743_1(a1 int, a2 TEXT not null) KEY_BLOCK_SIZE=1
1478
1479 0 rows affected
1480 RUN create table worklog5743_2(a1 int, a2 TEXT not null) KEY_BLOCK_SIZE=2
1481
1482 0 rows affected
1483 RUN create table worklog5743_4(a1 int, a2 TEXT not null) KEY_BLOCK_SIZE=4
1484
1485 0 rows affected
1486 RUN create table worklog5743_8(a1 int, a2 TEXT, a3 TEXT) KEY_BLOCK_SIZE=8
1487
1488 0 rows affected
1489
1490 ##
1491 ## Below statement throws warning as Error and actual error is missing
1492 ## Change result file once Bug#21529270 fixed
1493 RUN create index idx1 on worklog5743_1(a2(4000))
1494 While executing create index idx1 on worklog5743_1(a2(4000)):
1495 Got expected error: Specified key was too long; max key length is 3072 bytes (code 1071)
1496 RUN set global innodb_large_prefix=1
1497 While executing set global innodb_large_prefix=1:
1498 Got expected error: Unknown system variable 'innodb_large_prefix' (code 1193)
1499 RUN drop table worklog5743_1
1500
1501 0 rows affected
1502 RUN drop table worklog5743_2
1503
1504 0 rows affected
1505 RUN drop table worklog5743_4
1506
1507 0 rows affected
1508 RUN drop table worklog5743_8
1509
1510 0 rows affected
1511
1512 ##
1513 ## Checking warnings with different innodb file format
1514 RUN use test
1515
1516 0 rows affected
1517 RUN set innodb_strict_mode = off
1518
1519 0 rows affected
1520 RUN set global innodb_file_per_table = 0
1521
1522 0 rows affected
1523 RUN create temporary table t (i int) engine = innodb row_format = compressed
1524
1525 0 rows affected
1526 Warnings generated:
1527 WARNING | 1478 | InnoDB: ROW_FORMAT=COMPRESSED is ignored for TEMPORARY TABLE.
1528 WARNING | 1478 | InnoDB: assuming ROW_FORMAT=DYNAMIC.
1529 Got expected warning: 1478
1530 RUN drop table t
1531
1532 0 rows affected
1533 RUN set innodb_strict_mode = on
1534
1535 0 rows affected
1536 RUN set @@global.innodb_file_per_table = 1
1537
1538 0 rows affected
1539
1540 ##
1541 ## Checking warnings with different innodb row format
1542 RUN use test
1543
1544 0 rows affected
1545
1546 ##
1547 ## Expect one Error and Warning
1548 RUN create table t2 (id int primary key) engine = innodb key_block_size = 9
1549 Warnings generated:
1550 WARNING | 1478 | InnoDB: invalid KEY_BLOCK_SIZE = 9. Valid values are [1, 2, 4, 8, 16]
1551 While executing create table t2 (id int primary key) engine = innodb key_block_size = 9:
1552 Got expected error: Table storage engine for 't2' doesn't have this option (code 1031)
1553 Got expected warning: 1478
1554
1555 ##
1556 ## Expect 2 warnings and 1 Error
1557 RUN create table t2 (id int primary key) engine = innodb key_block_size = 9 row_format = redundant
1558 Warnings generated:
1559 WARNING | 1478 | InnoDB: invalid KEY_BLOCK_SIZE = 9. Valid values are [1, 2, 4, 8, 16]
1560 WARNING | 1478 | InnoDB: cannot specify ROW_FORMAT=REDUNDANT with KEY_BLOCK_SIZE.
1561 While executing create table t2 (id int primary key) engine = innodb key_block_size = 9 row_format = redundant:
1562 Got expected error: Table storage engine for 't2' doesn't have this option (code 1031)
1563 Got expected warning: 1478
1564
1565 ##
1566 ## Expect 1 warning and 2 Error
1567 RUN create table bug46000(`id` int, key `GEN_clust_INDEX`(`id`))engine=innodb
1568 Warnings generated:
1569 WARNING | 1280 | Cannot Create Index with name 'GEN_CLUST_INDEX'. The name is reserved for the system default primary index.
1570 WARNING | 1280 | Incorrect index name 'GEN_CLUST_INDEX'
1571 WARNING | 1030 | Got error 124 - 'Wrong index given to function' from storage engine
1572 While executing create table bug46000(`id` int, key `GEN_clust_INDEX`(`id`))engine=innodb:
1573 Got expected error: Incorrect index name 'GEN_CLUST_INDEX' (code 1280)
1574 Got expected warnings: 1030 1280
1575
1576 ##
1577 ## Check with show variables like versio and expect warning related to GTID session
1578 RUN show variables like 'versio'
1579 Variable_name Value
1580 0 rows affected
1581
1582 ##
1583 ## Check with show variables like versio and expect warning related to GTID session
1584 RUN show session variables like 'max_join_size'
1585 Variable_name Value
1586 max_join_size 18446744073709551615
1587 0 rows affected
1588 RUN show session variables like 'concurrent_insert'
1589 Variable_name Value
1590 concurrent_insert AUTO
1591 0 rows affected
1592 RUN show session variables like 'default_storage_engine'
1593 Variable_name Value
1594 default_storage_engine InnoDB
1595 0 rows affected
1596
1597 ##
1598 ## Verify the notices statistics
1599 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 855]
1600 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 168]
1601 Verify [Status variable "Mysqlx_stmt_disable_notices" needs to have a value of 0]
1602 Verify [Status variable "Mysqlx_stmt_enable_notices" needs to have a value of 1]
1603 Verify [Status variable "Mysqlx_stmt_list_notices" needs to have a value of 0]
1604 Mysqlx.Ok {
1605 msg: "bye!"
1606 }
1607 ok
1608 checking warnings with procedure execution
1609
1610 0 rows affected
1611 @start_global_value
1612 1024
1613 0 rows affected
1614
1615 0 rows affected
1616 @start_session_value
1617 1024
1618 0 rows affected
1619
1620 0 rows affected
1621
1622 1 rows affected
1623
1624 0 rows affected
1625
1626 0 rows affected
1627
1628 0 rows affected
1629
1630 0 rows affected
1631
1632 0 rows affected
1633
1634 0 rows affected
1635
1636 0 rows affected
1637
1638 0 rows affected
1639
1640 0 rows affected
1641
1642 0 rows affected
1643 Got expected error: Oops in proc_1 (code 1644)
1644
1645 0 rows affected
1646 @@session.max_error_count
1647 5
1648 0 rows affected
1649 Got expected error: Oops in proc_1 (code 1644)
1650
1651 0 rows affected
1652 @@session.max_error_count
1653 7
1654 0 rows affected
1655 Got expected error: Oops in proc_1 (code 1644)
1656
1657 0 rows affected
1658 @@session.max_error_count
1659 9
1660 0 rows affected
1661 Got expected error: Oops in proc_1 (code 1644)
1662
1663 0 rows affected
1664
1665 0 rows affected
1666 @@global.max_error_count
1667 1024
1668 0 rows affected
1669
1670 0 rows affected
1671 @@session.max_error_count
1672 1024
1673 0 rows affected
1674 checking warnings while creating index with more than row size
1675
1676 0 rows affected
1677
1678 0 rows affected
1679
1680 0 rows affected
1681
1682 0 rows affected
1683
1684 0 rows affected
1685 below statement throwing warning as an Error and actual error is missing
1686 change result file once Bug#21529270 is fixed
1687 Got expected error: Specified key was too long; max key length is 3072 bytes (code 1071)
1688
1689 0 rows affected
1690
1691 0 rows affected
1692
1693 0 rows affected
1694
1695 0 rows affected
1696 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 32]
1697 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 38]
1698 Verify [Status variable "Mysqlx_stmt_disable_notices" needs to have a value of 0]
1699 Verify [Status variable "Mysqlx_stmt_enable_notices" needs to have a value of 0]
1700 Verify [Status variable "Mysqlx_stmt_list_notices" needs to have a value of 0]
1701 Mysqlx.Ok {
1702 msg: "bye!"
1703 }
1704 ok
1705 Try enable warnings
1706
1707 command ok
1708 Try enable account_expired
1709
1710 command ok
1711 Try enable generated_insert_id
1712
1713 command ok
1714 Try enable rows_affected
1715
1716 command ok
1717 Try enable produced_message
1718
1719 command ok
1720 Verify [Status variable "Mysqlx_notice_global_sent" needs to have a value of 1]
1721 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 0]
1722 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 3]
1723 Verify [Status variable "Mysqlx_stmt_disable_notices" needs to have a value of 0]
1724 Verify [Status variable "Mysqlx_stmt_enable_notices" needs to have a value of 5]
1725 Verify [Status variable "Mysqlx_stmt_list_notices" needs to have a value of 0]
1726 Mysqlx.Ok {
1727 msg: "bye!"
1728 }
1729 ok
1730 create user xplugin@localhost identified by 'xplugin';
1731 Try enable warnings
1732
1733 command ok
1734 Try enable account_expired
1735
1736 command ok
1737 Try enable generated_insert_id
1738
1739 command ok
1740 Try enable rows_affected
1741
1742 command ok
1743 Try enable produced_message
1744
1745 command ok
1746 Verify [Status variable "Mysqlx_notice_global_sent" needs to have a value of 1]
1747 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 0]
1748 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 3]
1749 Verify [Status variable "Mysqlx_stmt_disable_notices" needs to have a value of 0]
1750 Verify [Status variable "Mysqlx_stmt_enable_notices" needs to have a value of 5]
1751 Verify [Status variable "Mysqlx_stmt_list_notices" needs to have a value of 0]
1752 Mysqlx.Ok {
1753 msg: "bye!"
1754 }
1755 ok
1756 Enable multiple notices both read-only and read-write with single StmtExecute,expect success
1757
1758 command ok
1759 notice enabled
1760 warnings 1
1761 group_replication/membership/quorum_loss 0
1762 group_replication/membership/view 0
1763 group_replication/status/role_change 0
1764 group_replication/status/state_change 0
1765 account_expired 1
1766 generated_insert_id 1
1767 rows_affected 1
1768 produced_message 1
1769 command ok
1770 Verify [Status variable "Mysqlx_notice_global_sent" needs to have a value of 1]
1771 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 0]
1772 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 3]
1773 Verify [Status variable "Mysqlx_stmt_disable_notices" needs to have a value of 0]
1774 Verify [Status variable "Mysqlx_stmt_enable_notices" needs to have a value of 1]
1775 Verify [Status variable "Mysqlx_stmt_list_notices" needs to have a value of 1]
1776 Mysqlx.Ok {
1777 msg: "bye!"
1778 }
1779 ok
1780
1781 0 rows affected
1782
1783 0 rows affected
1784 Warnings generated:
1785 NOTE | 1051 | Unknown table 'mysql.t1'
1786 expect Mysqlx_notice_other_sent=8 and Mysqlx_notice_warning_sent=3
1787 seems like some problem with these stats, need to change values once issues fixed
1788 disable warnings notice and observe stats
1789
1790 command ok
1791 enable account_expired notice and check stats
1792
1793 command ok
1794 enable account_expired notice and check stats
1795
1796 command ok
1797 listing notices after enabling warnings,account_expired notices
1798 notice enabled
1799 warnings 1
1800 group_replication/membership/quorum_loss 0
1801 group_replication/membership/view 0
1802 group_replication/status/role_change 0
1803 group_replication/status/state_change 0
1804 account_expired 1
1805 generated_insert_id 1
1806 rows_affected 1
1807 produced_message 1
1808 command ok
1809 listing notices with mixed case
1810 notice enabled
1811 warnings 1
1812 group_replication/membership/quorum_loss 0
1813 group_replication/membership/view 0
1814 group_replication/status/role_change 0
1815 group_replication/status/state_change 0
1816 account_expired 1
1817 generated_insert_id 1
1818 rows_affected 1
1819 produced_message 1
1820 command ok
1821 Verify [Status variable "Mysqlx_notice_global_sent" needs to have a value of 1]
1822 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 1]
1823 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 5]
1824 Verify [Status variable "Mysqlx_stmt_disable_notices" needs to have a value of 1]
1825 Verify [Status variable "Mysqlx_stmt_enable_notices" needs to have a value of 2]
1826 Verify [Status variable "Mysqlx_stmt_list_notices" needs to have a value of 2]
1827 Mysqlx.Ok {
1828 msg: "bye!"
1829 }
1830 ok
1831 # restart:
1832
1833 0 rows affected
1834
1835 0 rows affected
1836 Warnings generated:
1837 NOTE | 1051 | Unknown table 'mysql.t1'
1838 Verify [Status variable "Mysqlx_notice_global_sent" needs to have a value of 1]
1839 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 1]
1840 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 5]
1841 Mysqlx.Ok {
1842 msg: "bye!"
1843 }
1844 ok
1845 # restart:
1846 create user noti@localhost identified by 'noti';
1847 While executing use mysql:
1848 Got expected error: Access denied for user 'noti'@'localhost' to database 'mysql' (code 1044)
1849 Got expected error: No database selected (code 1046)
1850 Verify [Status variable "Mysqlx_notice_global_sent" needs to have a value of 1]
1851 Verify [Status variable "Mysqlx_notice_warning_sent" needs to have a value of 0]
1852 Verify [Status variable "Mysqlx_notice_other_sent" needs to have a value of 3]
1853 Verify [Status variable "Mysqlx_stmt_disable_notices" needs to have a value of 0]
1854 Verify [Status variable "Mysqlx_stmt_enable_notices" needs to have a value of 0]
1855 Verify [Status variable "Mysqlx_stmt_list_notices" needs to have a value of 0]
1856 Mysqlx.Ok {
1857 msg: "bye!"
1858 }
1859 ok
1860 drop user noti@localhost;
1861 drop user xplugin@localhost;