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