1
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
8
NULL NULL NULL 1 2 3 NULL NULL
9
NULL NULL NULL 1 2 3 NULL NULL
14
1 IS NULL 2 IS NULL 3 IS NOT NULL 4 IS NOT NULL
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
21
test SELECT ? FROM DUAL 1
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