Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test of multiple query rewrite plugins. This will only work on an
3 --echo # installation, where all plugins are in the same directory.
4 --echo #
5
6
7 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
8 --source include/no_protocol.inc
9 --source include/no_opt_trace_protocol.inc
10 --source include/no_explain_protocol.inc
11 --source include/no_json_explain_protocol.inc
12
13 --let plugins= REWRITER,REWRITE_EXAMPLE
14 --source include/check_plugin_dir.inc
15
16 --source suite/query_rewrite_plugins/include/install_rewriter.inc
17 --source suite/query_rewrite_plugins/include/install_pre_parse_plugin.inc
18
19 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
20 VALUES ( 'SELECT "abc"', 'SELECT "Rewritten"' );
21
22 CALL query_rewrite.flush_rewrite_rules();
23
24 SELECT * FROM query_rewrite.rewrite_rules;
25
26 SELECT 'abc';
27 SELECT 'ABC';
28
29 UNINSTALL PLUGIN rewrite_example;
30 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc