Debian Codegraph @

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

raw
1
2 ##### TEST 1 - VERIFY QUERY_SAMPLE_TEXT LENGTH RETURNS NULL WHEN SQL TEXT LENGTH IS SET TO 0
3
4
5 # Verify sql text length = 0
6 SELECT @@global.performance_schema_max_sql_text_length;
7 @@global.performance_schema_max_sql_text_length
8 0
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 = 400;
16
17 ## 1.3 Verify that QUERY_SAMPLE_TEXT has zero length
18
19 SELECT query_sample_text
20 FROM performance_schema.events_statements_summary_by_digest
21 WHERE digest_text = "UPDATE `t1` SET `s1` = ?";
22 query_sample_text
23 NULL
24
25 #### CLEANUP
26
27 DROP TABLE t1;