Debian Codegraph @

mysql-test/suite/perfschema/r/digest_null_literal.result

raw
1 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
2 NULL
3 NULL
4 NULL
5 NULL
6 NULL NULL
7 NULL NULL
8 NULL NULL NULL 1 2 3 NULL NULL
9 NULL NULL NULL 1 2 3 NULL NULL
10 1 IS NULL
11 0
12 2 IS NOT NULL
13 1
14 1 IS NULL 2 IS NULL 3 IS NOT NULL 4 IS NOT NULL
15 0 0 1 1
16 SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR
17 FROM performance_schema.events_statements_summary_by_digest;
18 SCHEMA_NAME DIGEST_TEXT COUNT_STAR
19 test TRUNCATE TABLE `performance_schema` . `events_statements_summary_by_digest` 1
20 test SELECT ? 1
21 test SELECT ? FROM DUAL 1
22 test SELECT ?, ... 2
23 test SELECT ? IS NULL 1
24 test SELECT ? IS NOT NULL 1
25 test SELECT ? IS NULL , ? IS NULL , ? IS NOT NULL , ? IS NOT NULL 1
26 test CREATE TABLE `foo` ( `a` INTEGER DEFAULT ? , `b` INTEGER NOT NULL DEFAULT ? , `c` INTEGER NOT NULL ) 1
27 test DROP TABLE `foo` 1