diff options
Diffstat (limited to 'mysql-test/suite/perfschema/t/start_server_low_digest_sql_length.test')
-rw-r--r-- | mysql-test/suite/perfschema/t/start_server_low_digest_sql_length.test | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema/t/start_server_low_digest_sql_length.test b/mysql-test/suite/perfschema/t/start_server_low_digest_sql_length.test new file mode 100644 index 00000000000..ba7f06dc7b9 --- /dev/null +++ b/mysql-test/suite/perfschema/t/start_server_low_digest_sql_length.test @@ -0,0 +1,22 @@ +# ----------------------------------------------------------------------- +# Tests for the performance schema statement Digests. +# ----------------------------------------------------------------------- + +--source include/not_embedded.inc +--source include/have_perfschema.inc +--source include/no_protocol.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 +# - performance_schema_max_sql_text_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; |