| 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 |