24 lines
1.1 KiB
Plaintext
24 lines
1.1 KiB
Plaintext
# -----------------------------------------------------------------------
|
|
# Tests for the performance schema statement Digests.
|
|
# -----------------------------------------------------------------------
|
|
|
|
# Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
|
|
--source include/no_protocol.inc
|
|
|
|
# X plugin might increase counter thread_id_increment
|
|
source include/xplugin_wait_for_interfaces.inc;
|
|
|
|
USE performance_schema;
|
|
truncate table events_statements_history_long;
|
|
|
|
# -----------------------------------------------------------------------
|
|
# Test to show how the digest behaves with low value of
|
|
# - performance_schema_max_digest_length
|
|
# -----------------------------------------------------------------------
|
|
SELECT 1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1+1;
|
|
|
|
--echo ####################################
|
|
--echo # QUERYING PS STATEMENT DIGEST
|
|
--echo ####################################
|
|
SELECT event_name, digest, digest_text, sql_text FROM events_statements_history_long;
|