31 lines
683 B
Plaintext
31 lines
683 B
Plaintext
## 1. Setup the test
|
|
## 2. Trigger warnings
|
|
## a. trigger small amount of warnings (2)
|
|
## b. trigger large amount of warnings (14998)
|
|
|
|
# Ad 1.
|
|
#
|
|
RUN USE test
|
|
RUN CREATE TABLE table_with_ints(i INTEGER)
|
|
RUN SET max_error_count=20000
|
|
|
|
# Ad 2.a.
|
|
#
|
|
RUN INSERT INTO table_with_ints(i) VALUES(1),(0),(1),(0)
|
|
RUN SELECT 1/i FROM table_with_ints
|
|
Got expected warning: 1365
|
|
[ASSERT Mysqlx.Notice.Warning == 2]
|
|
|
|
# Ad 2.b.
|
|
#
|
|
RUN DELETE FROM table_with_ints WHERE TRUE
|
|
RUN INSERT INTO table_with_ints(i) VALUES(1)
|
|
RUN SELECT %FIELDS% FROM table_with_ints
|
|
Got expected warnings: 1292 1365
|
|
[ASSERT Mysqlx.Notice.Warning == 15000]
|
|
Mysqlx.Ok {
|
|
msg: "bye!"
|
|
}
|
|
ok
|
|
DROP TABLE table_with_ints;
|