Debian Codegraph @

mysql-test/suite/perfschema/r/statement_digest_query_sample_short_text.result

raw
1
2 #### Test 1 - VERIFY QUERY_SAMPLE_TEXT LENGTH IS LIMITED BY PERFORMANCE_SCHEMA_MAX_SQL_TEXT_LENGTH
3
4
5 # 1.1 Verify sql text length = 10
6 SELECT @@global.performance_schema_max_sql_text_length;
7 @@global.performance_schema_max_sql_text_length
8 10
9
10 USE test;
11 DROP TABLE IF EXISTS t1;
12 CREATE TABLE t1 (s1 int);
13 INSERT INTO t1 values (100), (200), (300);
14 TRUNCATE TABLE performance_schema.events_statements_summary_by_digest;
15 UPDATE t1 SET s1 = 500;
16
17 ## 1.2 Verify that QUERY_SAMPLE_TEXT is truncated to 10 bytes
18
19 SELECT length(query_sample_text) = 10 AS 'Expect 1 as QUERY_SAMPLE_TEXT is 10'
20 FROM performance_schema.events_statements_summary_by_digest
21 WHERE digest_text = "UPDATE `t1` SET `s1` = ?";
22 Expect 1 as QUERY_SAMPLE_TEXT is 10
23 1
24
25 ## CLEANUP
26
27 DROP TABLE t1;