mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
25 lines
879 B
Text
25 lines
879 B
Text
# -----------------------------------------------------------------------
|
|
# Tests for the performance schema statement Digests.
|
|
# -----------------------------------------------------------------------
|
|
|
|
--source include/not_embedded.inc
|
|
--source include/have_perfschema.inc
|
|
|
|
SET sql_mode='NO_ENGINE_SUBSTITUTION';
|
|
# Initial Setup for Digest
|
|
--source ../include/digest_setup.inc
|
|
|
|
TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
|
|
|
|
# Executing queries
|
|
--source ../include/digest_execution.inc
|
|
|
|
--echo ####################################
|
|
--echo # QUERYING PS STATEMENT DIGEST
|
|
--echo ####################################
|
|
SELECT SCHEMA_NAME, DIGEST_TEXT, COUNT_STAR, SUM_ROWS_AFFECTED, SUM_WARNINGS,
|
|
SUM_ERRORS FROM performance_schema.events_statements_summary_by_digest;
|
|
|
|
# Cleanup for Digest
|
|
--source ../include/digest_cleanup.inc
|
|
SET sql_mode=default;
|