Debian Codegraph @

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

raw
1 ## 1. Setup the test
2 ## 2. Trigger warnings
3 ## a. trigger small amount of warnings (2)
4 ## b. trigger large amount of warnings (14998)
5
6 # Ad 1.
7 #
8 RUN USE test
9 RUN CREATE TABLE table_with_ints(i INTEGER)
10 RUN SET max_error_count=20000
11
12 # Ad 2.a.
13 #
14 RUN INSERT INTO table_with_ints(i) VALUES(1),(0),(1),(0)
15 RUN SELECT 1/i FROM table_with_ints
16 Got expected warning: 1365
17 [ASSERT Mysqlx.Notice.Warning == 2]
18
19 # Ad 2.b.
20 #
21 RUN DELETE FROM table_with_ints WHERE TRUE
22 RUN INSERT INTO table_with_ints(i) VALUES(1)
23 RUN SELECT %FIELDS% FROM table_with_ints
24 Got expected warnings: 1292 1365
25 [ASSERT Mysqlx.Notice.Warning == 15000]
26 Mysqlx.Ok {
27 msg: "bye!"
28 }
29 ok
30 DROP TABLE table_with_ints;