Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/t/performance_schema.test

raw
1 --echo #
2 --echo # Verifies that the original query ends up in the statements history in
3 --echo # performance_schema, and that digests are calculated even though the
4 --echo # statements_digest consumer is disabled.
5 --echo #
6
7 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
8
9 --echo
10 SELECT enabled INTO @original_setting
11 FROM performance_schema.setup_consumers
12 WHERE NAME = 'statements_digest';
13
14 --echo
15 UPDATE performance_schema.setup_consumers
16 SET enabled = 'NO'
17 WHERE NAME = 'statements_digest';
18
19 --echo
20 SELECT 'original';
21
22 --echo
23 --echo # The digest column is now NULL since no digest was asked for.
24 SELECT sql_text, digest
25 FROM performance_schema.events_statements_history
26 WHERE sql_text = "SELECT 'original'";
27
28 --echo
29 --source suite/query_rewrite_plugins/include/install_rewriter.inc
30
31 --echo
32 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
33 VALUES ( 'SELECT "original"', 'SELECT "rewritten"' );
34
35 --echo
36 CALL query_rewrite.flush_rewrite_rules();
37
38 --echo
39 SELECT 'original';
40
41 --echo
42 --echo # Statements history displays queries after they've been parsed and rewritten
43 SELECT sql_text, digest
44 FROM performance_schema.events_statements_history
45 WHERE sql_text LIKE 'SELECT %' AND sql_text NOT LIKE '%@@skip_networking%@@skip_name_resolve%' ORDER BY event_id;
46
47 --echo
48 UPDATE performance_schema.setup_consumers
49 SET enabled = @original_setting
50 WHERE NAME = 'statements_digest';
51
52 --echo
53 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc