Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/r/performance_schema.result

raw
1 #
2 # Verifies that the original query ends up in the statements history in
3 # performance_schema, and that digests are calculated even though the
4 # statements_digest consumer is disabled.
5 #
6
7 SELECT enabled INTO @original_setting
8 FROM performance_schema.setup_consumers
9 WHERE NAME = 'statements_digest';
10
11 UPDATE performance_schema.setup_consumers
12 SET enabled = 'NO'
13 WHERE NAME = 'statements_digest';
14
15 SELECT 'original';
16 original
17 original
18
19 # The digest column is now NULL since no digest was asked for.
20 SELECT sql_text, digest
21 FROM performance_schema.events_statements_history
22 WHERE sql_text = "SELECT 'original'";
23 sql_text digest
24 SELECT 'original' NULL
25
26 # Query rewrite plugin was installed.
27
28 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
29 VALUES ( 'SELECT "original"', 'SELECT "rewritten"' );
30
31 CALL query_rewrite.flush_rewrite_rules();
32
33 SELECT 'original';
34 rewritten
35 rewritten
36 Warnings:
37 Note 1105 Query 'SELECT 'original'' rewritten to 'SELECT "rewritten"' by a query rewrite plugin
38
39 # Statements history displays queries after they've been parsed and rewritten
40 SELECT sql_text, digest
41 FROM performance_schema.events_statements_history
42 WHERE sql_text LIKE 'SELECT %' AND sql_text NOT LIKE '%@@skip_networking%@@skip_name_resolve%' ORDER BY event_id;
43 sql_text digest
44 SELECT load_rewrite_rules() INTO message_text NULL
45 SELECT "rewritten" NULL
46
47 UPDATE performance_schema.setup_consumers
48 SET enabled = @original_setting
49 WHERE NAME = 'statements_digest';
50
51 Warnings:
52 Warning 1620 Plugin is busy and will be uninstalled on shutdown
53 # Query rewrite plugin was queued for uninstalling.