Debian Codegraph @

mysql-test/suite/perfschema/t/digest_null_literal.test

raw
1 # ----------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # ----------------------------------------------------
4
5 # Test case to show behavior of statements digest when
6 # parsing a NULL literal
7
8 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
9 --source include/no_protocol.inc
10
11 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
12
13 --disable_query_log
14
15 select NULL;
16 select NULL FROM DUAL;
17 select NULL, NULL;
18 select NULL, NULL, NULL, 1, 2, 3, NULL, NULL;
19
20 select 1 IS NULL;
21 select 2 IS NOT NULL;
22 select 1 IS NULL, 2 IS NULL, 3 IS NOT NULL, 4 IS NOT NULL;
23
24 create table foo (a int DEFAULT NULL, b int NOT NULL DEFAULT 1, c int NOT NULL);
25 drop table foo;
26
27 --enable_query_log
28
29 SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR
30 FROM performance_schema.events_statements_summary_by_digest;
31