Debian Codegraph @

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

raw
1 # -----------------------------------------------------------------------
2 # Tests for the performance schema statement Digests.
3 # -----------------------------------------------------------------------
4
5 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
6 --source include/no_protocol.inc
7
8 USE performance_schema;
9 truncate table events_statements_history_long;
10
11 # -----------------------------------------------------------------------
12 # Test to show how the digest behaves with low value of
13 # - performance_schema_max_digest_length
14 # - performance_schema_max_sql_text_length
15 # -----------------------------------------------------------------------
16 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;
17
18 --echo ####################################
19 --echo # QUERYING PS STATEMENT DIGEST
20 --echo ####################################
21 SELECT event_name, digest, digest_text, sql_text FROM events_statements_history_long;