#################################################### # WL#9830 - PERFORMANCE_SCHEMA DIGEST QUERY SAMPLE # #################################################### # # # Test Author - Mohit Joshi # # Creation date - 18-Aug-2017 # #################################################### --source include/no_protocol.inc --echo --echo ##### TEST 1 - VERIFY QUERY_SAMPLE_TEXT LENGTH RETURNS NULL WHEN SQL TEXT LENGTH IS SET TO 0 --echo --echo --echo # Verify sql text length = 0 SELECT @@global.performance_schema_max_sql_text_length; --echo USE test; --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 (s1 int); INSERT INTO t1 values (100), (200), (300); TRUNCATE TABLE performance_schema.events_statements_summary_by_digest; UPDATE t1 SET s1 = 400; --echo --echo ## 1.3 Verify that QUERY_SAMPLE_TEXT has zero length --echo SELECT query_sample_text FROM performance_schema.events_statements_summary_by_digest WHERE digest_text = "UPDATE `t1` SET `s1` = ?"; --echo --echo #### CLEANUP --echo DROP TABLE t1;