Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/include/reload.inc

raw
1 --echo #
2 --echo # Reinstalls the plugin while keeping the rules table.
3 --echo #
4
5 CREATE TABLE t1 ( c1 VARCHAR(10), c2 VARCHAR(10) );
6 INSERT INTO t1 VALUES ( 'abc', 'def' ), ( 'ghi', 'klm' ), ( 'nop', 'qrs' );
7
8 CREATE TABLE t2 ( c1 VARCHAR(10) );
9 INSERT INTO t2 VALUES ( 'abc' ), ( 'klm' );
10
11 --source suite/query_rewrite_plugins/include/install_rewriter.inc
12
13 --echo # Insert some rewrite rules in the plugin
14 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
15 VALUES ( 'SELECT * FROM test.t2',
16 'SELECT * FROM test.t1 JOIN test.t2 ON test.t1.c1 = test.t2.c1' );
17
18 CALL query_rewrite.flush_rewrite_rules();
19
20 --echo # Check a query that doesn't have a rewrite rule doesn't get rewritten.
21 SELECT c2 FROM test.t1;
22
23 --echo # Check that we can execute a rewrite rule.
24 SELECT * FROM test.t2;
25
26 DROP PROCEDURE query_rewrite.flush_rewrite_rules;
27 DROP FUNCTION load_rewrite_rules;
28 UNINSTALL PLUGIN rewriter;
29 --source include/disconnect_connections.inc
30
31 --echo # Check that the table is still present and didn't get dropped.
32 SELECT pattern, replacement FROM query_rewrite.rewrite_rules;
33
34 --echo # Check that when the plugin is inactive the queries don't get rewritten.
35 SELECT * FROM test.t2;
36
37 --echo # Reinstall the plugin. All the rules should still be here from the
38 --echo # previous installation.
39 --source suite/query_rewrite_plugins/include/install_rewriter.inc
40
41 --echo # Check that a query that doesn't have a rewrite rule doesn't get
42 --echo # rewritten.
43 SELECT c2 FROM test.t1;
44
45 --echo # Check that we can still execute a rewrite rule.
46 SELECT * FROM test.t2;
47
48 DROP TABLE t1, t2;
49
50 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc