Debian Codegraph @

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

raw
1 # -----------------------------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # -----------------------------------------------------------------------
4
5 SET sql_mode='NO_ENGINE_SUBSTITUTION';
6 # Initial Setup for Digest
7 --source ../include/digest_setup.inc
8
9 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
10
11 # Executing queries
12 --source ../include/digest_execution.inc
13
14 --echo ####################################
15 --echo # QUERYING PS STATEMENT DIGEST
16 --echo ####################################
17 SELECT SCHEMA_NAME, DIGEST, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
18 SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
19
20 # Cleanup for Digest
21 --source ../include/digest_cleanup.inc
22 SET sql_mode=default;