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 --source include/not_embedded.inc
6 --source include/have_perfschema.inc
7 --source include/no_protocol.inc
8 --source include/check_digest.inc
9
10 USE performance_schema;
11 truncate table events_statements_history_long;
12
13 # -----------------------------------------------------------------------
14 # Test to show how the digest behaves with low value of
15 # - performance_schema_max_digest_length
16 # - performance_schema_max_sql_text_length
17 # -----------------------------------------------------------------------
18 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;
19
20 --echo ####################################
21 --echo # QUERYING PS STATEMENT DIGEST
22 --echo ####################################
23 create table test.events_long select * from events_statements_history_long;
24 --sorted_result
25 SELECT event_name, test.check_digest(digest), digest_text, sql_text FROM test.events_long;
26 --source include/check_digest_end.inc
27 drop table test.events_long;