Debian Codegraph @

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

raw
1
2 command ok
3 check with dropping db which doesn't exists
4
5 0 rows affected
6 check with dropping table which doesn't exists
7
8 0 rows affected
9 check with dropping procedure which doesn't exists
10
11 0 rows affected
12 check with dropping function which doesn't exists
13
14 0 rows affected
15 check with dropping view which doesn't exists
16
17 0 rows affected
18 out of range values for INT,UNSIGN INT
19
20 0 rows affected
21
22 1 rows affected
23
24 1 rows affected
25
26 0 rows affected
27 checking double data type
28
29 0 rows affected
30
31 1 rows affected
32
33 1 rows affected
34
35 1 rows affected
36
37 1 rows affected
38
39 1 rows affected
40
41 1 rows affected
42
43 1 rows affected
44
45 1 rows affected
46
47 1 rows affected
48 grp group_concat(a order by a,d+c-ascii(c)-a)
49 1 1
50 2 2,3
51 3 4,5,6,7,8,9
52 0 rows affected
53 grp group_concat(a order by d+c-ascii(c),a)
54 1 1
55 2 3,2
56 3 7,8,4,6,9,5
57 0 rows affected
58
59 0 rows affected
60 grp group_concat(c order by c)
61 1 a
62 2 b,c
63 3 C,D,
64 0 rows affected
65
66 0 rows affected
67 checking character data type
68 Error is returned instead of warning for insert operation with xplugin
69
70 0 rows affected
71
72 0 rows affected
73 Statement prepared
74
75 0 rows affected
76
77 1 rows affected
78 length(a)
79 10
80 0 rows affected
81
82 0 rows affected
83
84 0 rows affected
85 checking directly from IS tables
86 VARIABLE_NAME VARIABLE_VALUE
87 max_join_size 18446744073709551615
88 0 rows affected
89 VARIABLE_NAME VARIABLE_VALUE
90 concurrent_insert AUTO
91 0 rows affected
92 VARIABLE_NAME VARIABLE_VALUE
93 default_storage_engine InnoDB
94 0 rows affected
95 checking errors and warnings with duplicate table
96
97 0 rows affected
98 checking errors and warnings with duplicate table names
99
100 0 rows affected
101 Got expected error: Table 'dup' already exists (code 1050)
102 @@session.error_count
103 1
104 0 rows affected
105 Level Code Message
106 Error 1050 Table 'dup' already exists
107 0 rows affected
108
109 0 rows affected
110 checking creating table with if not exists
111
112 0 rows affected
113
114 0 rows affected
115 Got expected error: Table 't1' already exists (code 1050)
116
117 0 rows affected
118 a
119 0 rows affected
120
121 0 rows affected
122 Variable_name Value
123 Opened_tables 1
124 0 rows affected
125 a
126 0 rows affected
127
128 0 rows affected
129 try droping mutliplt tables with if exists and check multiple warnings
130
131 0 rows affected
132
133 0 rows affected
134 try checking may warnings
135
136 0 rows affected
137 try dropping same table with if exists and observe error/wrarnings
138 Got expected error: Not unique table/alias: 't1' (code 1066)
139
140 0 rows affected
141 check more than 64 warnings returned
142
143 0 rows affected
144 check no warnings based on max_error_count parameter set
145
146 0 rows affected
147
148 0 rows affected
149
150 0 rows affected
151 Variable_name Value
152 max_error_count 0
153 0 rows affected
154
155 0 rows affected
156 checking creating temporary table when normal and temp table exists
157
158 0 rows affected
159
160 1 rows affected
161 Records: 1 Duplicates: 0 Warnings: 0
162
163 1 rows affected
164 Records: 1 Duplicates: 0 Warnings: 0
165 a
166 2
167 0 rows affected
168
169 0 rows affected
170 a
171 2
172 0 rows affected
173
174 0 rows affected
175
176 0 rows affected
177 checking data truncation warnings for default values
178
179 0 rows affected
180
181 1 rows affected
182 Records: 1 Duplicates: 0 Warnings: 1
183
184 0 rows affected
185 checking data truncation warnings while creating table with expression
186
187 0 rows affected
188
189 1 rows affected
190 Records: 1 Duplicates: 0 Warnings: 1
191
192 0 rows affected
193 checking warnings with insert and select operations
194 below insert into t1 returns 17775 warnings,checking only limited warnings as test takes more time to render the warnings
195
196 0 rows affected
197
198 0 rows affected
199
200 8 rows affected
201 Records: 8 Duplicates: 0 Warnings: 0
202
203 8 rows affected
204 Records: 8 Duplicates: 0 Warnings: 0
205
206 0 rows affected
207 checking for more than default 64 warnings
208
209 0 rows affected
210
211 65536 rows affected
212 Records: 65536 Duplicates: 0 Warnings: 17775
213
214 0 rows affected
215
216 0 rows affected
217 checking warnigns with prepare and execute statmenets
218
219 0 rows affected
220
221 0 rows affected
222
223 1 rows affected
224 1
225 1
226 0 rows affected
227
228 0 rows affected
229 Statement prepared
230 1
231 1
232 0 rows affected
233 1
234 1
235 0 rows affected
236
237 0 rows affected
238
239 0 rows affected
240 Statement prepared
241 1
242 1
243 0 rows affected
244 1
245 1
246 0 rows affected
247
248 0 rows affected
249
250 0 rows affected
251 checking warnings with group by when sql_mode is no_engine_substitution
252
253 0 rows affected
254
255 0 rows affected
256
257 0 rows affected
258
259 0 rows affected
260
261 2 rows affected
262 Records: 2 Duplicates: 0 Warnings: 0
263
264 2 rows affected
265 Records: 2 Duplicates: 0 Warnings: 0
266 c2
267 aaa
268 aaa
269 0 rows affected
270 c2
271 aaa
272 0 rows affected
273
274 0 rows affected
275 setting back to default of sql_mode
276
277 0 rows affected
278 checking with group by where both error and warnings expected with default sql_mode
279
280 0 rows affected
281
282 0 rows affected
283
284 0 rows affected
285
286 2 rows affected
287 Records: 2 Duplicates: 0 Warnings: 0
288
289 2 rows affected
290 Records: 2 Duplicates: 0 Warnings: 0
291 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)
292 expect both error and warning
293 change result file once Bug#21524666 is fixed
294 c2
295 aaa
296 0 rows affected
297
298 0 rows affected
299 checking warnings with rollback on non-transactional tables
300
301 0 rows affected
302
303 0 rows affected
304
305 0 rows affected
306
307 1 rows affected
308
309 1 rows affected
310
311 0 rows affected
312 Level Code Message
313 Warning 1196 Some non-transactional changed tables couldn't be rolled back
314 0 rows affected
315 Level Code Message
316 0 rows affected
317 @@warning_count @@error_count
318 1 0
319 0 rows affected
320 n
321 4
322 5
323 0 rows affected
324 Level Code Message
325 0 rows affected
326 @@warning_count
327 0
328 0 rows affected
329
330 0 rows affected
331 expect 2 warnings for insert related to truncation and incorrect date value
332
333 0 rows affected
334
335 0 rows affected
336
337 0 rows affected
338
339 1 rows affected
340 Records: 1 Duplicates: 0 Warnings: 2
341
342 0 rows affected
343
344 0 rows affected
345 checking warnings while creating index which is more than row size
346
347 0 rows affected
348
349 0 rows affected
350
351 0 rows affected
352
353 0 rows affected
354
355 0 rows affected
356 below statement throws warning as Error and actual error is missing
357 change result file once Bug#21529270 fixed
358 Got expected error: Specified key was too long; max key length is 3072 bytes (code 1071)
359
360 0 rows affected
361
362 0 rows affected
363
364 0 rows affected
365
366 0 rows affected
367 checking warnings with different innodb file format
368
369 0 rows affected
370
371 0 rows affected
372
373 0 rows affected
374
375 0 rows affected
376
377 0 rows affected
378
379 0 rows affected
380
381 0 rows affected
382 checking warnings with different innodb row format
383
384 0 rows affected
385 expect one Error and Warning
386 modify the result file once Bug#21524666 is fixed
387 Got expected error: Table storage engine for 't2' doesn't have this option (code 1031)
388 expect 2 warnings and 1 Error
389 modify the result file once Bug#21524666 is fixed
390 Got expected error: Table storage engine for 't2' doesn't have this option (code 1031)
391 expect 1 warning and 2 Error
392 modify the result file once Bug#21524666 is fixed
393 Got expected error: Incorrect index name 'GEN_CLUST_INDEX' (code 1280)
394 Got expected error: Cannot disable notice account_expired (code 5164)
395 Mysqlx.Ok {
396 msg: "bye!"
397 }
398 ok
399 Try Disable warnings
400
401 command ok
402 Try Disable account_expired
403 Got expected error: Cannot disable notice account_expired (code 5164)
404 Try Disable generated_insert_id
405 Got expected error: Cannot disable notice generated_insert_id (code 5164)
406 Try Disable rows_affected
407 Got expected error: Cannot disable notice rows_affected (code 5164)
408 Try Disable produced_message
409 Got expected error: Cannot disable notice produced_message (code 5164)
410 expect Mysqlx_stmt_disable_notices=5 and remaining are 0
411 Variable_name Value
412 Mysqlx_notice_global_sent 1
413 Mysqlx_notice_other_sent 1
414 Mysqlx_notice_warning_sent 0
415 Mysqlx_stmt_disable_notices 5
416 Mysqlx_stmt_enable_notices 0
417 Mysqlx_stmt_list_notices 0
418 0 rows affected
419 Mysqlx.Ok {
420 msg: "bye!"
421 }
422 ok
423 create user xplugin@localhost identified by 'xplugin';
424 Try Disable warnings
425
426 command ok
427 Try Disable account_expired
428 Got expected error: Cannot disable notice account_expired (code 5164)
429 Try Disable generated_insert_id
430 Got expected error: Cannot disable notice generated_insert_id (code 5164)
431 Try Disable rows_affected
432 Got expected error: Cannot disable notice rows_affected (code 5164)
433 Try Disable produced_message
434 Got expected error: Cannot disable notice produced_message (code 5164)
435 expect Mysqlx_stmt_disable_notices=5 and remaining are 0
436 Variable_name Value
437 Mysqlx_notice_global_sent 1
438 Mysqlx_notice_other_sent 1
439 Mysqlx_notice_warning_sent 0
440 Mysqlx_stmt_disable_notices 5
441 Mysqlx_stmt_enable_notices 0
442 Mysqlx_stmt_list_notices 0
443 0 rows affected
444 Mysqlx.Ok {
445 msg: "bye!"
446 }
447 ok
448
449 command ok
450 checking warnings with procedure execution
451
452 0 rows affected
453 @start_global_value
454 1024
455 0 rows affected
456
457 0 rows affected
458 @start_session_value
459 1024
460 0 rows affected
461
462 0 rows affected
463
464 1 rows affected
465
466 0 rows affected
467
468 0 rows affected
469
470 0 rows affected
471
472 0 rows affected
473
474 0 rows affected
475
476 0 rows affected
477
478 0 rows affected
479
480 0 rows affected
481
482 0 rows affected
483
484 0 rows affected
485 Got expected error: Oops in proc_1 (code 1644)
486
487 0 rows affected
488 @@session.max_error_count
489 5
490 0 rows affected
491 Got expected error: Oops in proc_1 (code 1644)
492
493 0 rows affected
494 @@session.max_error_count
495 7
496 0 rows affected
497 Got expected error: Oops in proc_1 (code 1644)
498
499 0 rows affected
500 @@session.max_error_count
501 9
502 0 rows affected
503 Got expected error: Oops in proc_1 (code 1644)
504
505 0 rows affected
506
507 0 rows affected
508 @@global.max_error_count
509 1024
510 0 rows affected
511
512 0 rows affected
513 @@session.max_error_count
514 1024
515 0 rows affected
516 checking warnings while creating index with more than row size
517
518 0 rows affected
519
520 0 rows affected
521
522 0 rows affected
523
524 0 rows affected
525
526 0 rows affected
527 below statement throwing warning as an Error and actual error is missing
528 Change result file once Bug#21529270 fixed
529 Got expected error: Specified key was too long; max key length is 3072 bytes (code 1071)
530
531 0 rows affected
532
533 0 rows affected
534
535 0 rows affected
536
537 0 rows affected
538 Mysqlx.Ok {
539 msg: "bye!"
540 }
541 ok
542 Disable multiple notices both read-only and read-write with single StmtExecute,expect error from the first error is sees
543 expect error from account_expired onwards as it is read-only though warnings returns success as it is rea-write
544 Got expected error: Cannot disable notice account_expired (code 5164)
545 notice enabled
546 warnings 1
547 group_replication/membership/quorum_loss 0
548 group_replication/membership/view 0
549 group_replication/status/role_change 0
550 group_replication/status/state_change 0
551 account_expired 1
552 generated_insert_id 1
553 rows_affected 1
554 produced_message 1
555 command ok
556 expect error as disabling account_expired returns error as expected since it is read-ony
557 Got expected error: Cannot disable notice account_expired (code 5164)
558 notice enabled
559 warnings 1
560 group_replication/membership/quorum_loss 0
561 group_replication/membership/view 0
562 group_replication/status/role_change 0
563 group_replication/status/state_change 0
564 account_expired 1
565 generated_insert_id 1
566 rows_affected 1
567 produced_message 1
568 command ok
569 Mysqlx.Ok {
570 msg: "bye!"
571 }
572 ok
573 drop user xplugin@localhost;