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 --source include/not_embedded.inc
9 --source include/have_perfschema.inc
10 --source include/no_protocol.inc
11
12 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
13
14 --disable_query_log
15
16 select NULL;
17 select NULL FROM DUAL;
18 select NULL, NULL;
19 select NULL, NULL, NULL, 1, 2, 3, NULL, NULL;
20
21 select 1 IS NULL;
22 select 2 IS NOT NULL;
23 select 1 IS NULL, 2 IS NULL, 3 IS NOT NULL, 4 IS NOT NULL;
24
25 create table foo (a int DEFAULT NULL, b int NOT NULL DEFAULT 1, c int NOT NULL);
26 drop table foo;
27
28 --enable_query_log
29
30 SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR
31 FROM performance_schema.events_statements_summary_by_digest;
32