Debian Codegraph @

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

raw
1 --echo #
2 --echo # Inserts some rules, tests them and then inserts another one.
3 --echo #
4
5 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
6
7 use test;
8
9 CREATE TABLE t1 ( c1 VARCHAR(10), c2 VARCHAR(10) );
10
11 INSERT INTO t1 VALUES ( 'abc', 'def' ),
12 ( 'ghi', 'klm' ),
13 ( 'nop', 'qrs' );
14
15
16 CREATE TABLE t2 ( c1 VARCHAR(10) );
17
18 INSERT INTO t2 VALUES ( 'abc' ),
19 ( 'klm' );
20
21 --source suite/query_rewrite_plugins/include/install_rewriter_with_optional_columns.inc
22
23 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
24
25 VALUES ( 'SELECT * FROM test.t1 WHERE ( c1 = ? AND TRUE ) OR c2 = ?',
26 'SELECT c1 FROM test.t1 WHERE c1 = ?' ),
27
28 ( 'SELECT * FROM test.t2',
29 'SELECT * FROM test.t1 JOIN test.t2 ON test.t1.c1 = t2.c1' );
30
31 CALL query_rewrite.flush_rewrite_rules();
32
33 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
34 SHOW STATUS LIKE 'Rewriter_number_reloads';
35
36 # checks a query without rewrite
37 SELECT c2 FROM test.t1;
38
39 --echo # Check that a rewrite works.
40 SELECT * FROM test.t2;
41
42 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
43 VALUES ( 'SELECT c2 FROM test.t1', 'SELECT * FROM test.t1' );
44
45 CALL query_rewrite.flush_rewrite_rules();
46
47 SHOW STATUS LIKE 'Rewriter_number_loaded_rules';
48 SHOW STATUS LIKE 'Rewriter_number_reloads';
49
50 SET @@global.rewriter_verbose = 2;
51
52 --echo # Check that the new rule works.
53 SELECT c2 FROM test.t1;
54
55 --echo # Check that the old rewrites still work.
56 SELECT * FROM test.t2;
57
58 DROP TABLE t1, t2;
59 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc