Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test of deletion of rules.
3 --echo #
4
5 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
6
7 CREATE TABLE t1 ( c1 VARCHAR(10) );
8 INSERT INTO t1 VALUES ( 'abc' ), ( 'def' );
9
10 CREATE TABLE t2 ( c1 VARCHAR(10) );
11 INSERT INTO t2 VALUES ( '123' ), ( '456' );
12
13 --source suite/query_rewrite_plugins/include/install_rewriter.inc
14
15 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
16 VALUES ( 'SELECT * FROM test.t1', 'SELECT * FROM test.t2' );
17
18 CALL query_rewrite.flush_rewrite_rules();
19
20 --echo # Check that the rewrite rule is executed.
21 SELECT * FROM test.t1;
22
23 DELETE FROM query_rewrite.rewrite_rules
24 WHERE pattern = 'SELECT * FROM test.t1';
25
26 CALL query_rewrite.flush_rewrite_rules();
27
28 --echo # Check that the rewrite rule is not executed.
29 SELECT * FROM test.t1;
30
31 DROP TABLE t1, t2;
32
33 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc