Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test of prepared statements being rewritten.
3 --echo #
4
5 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
6
7 CREATE TABLE t1 ( a INTEGER, b CHAR(1) );
8 INSERT INTO t1 VALUES ( 1, 'a' ), ( 2, 'b' ), ( 3, 'c' );
9
10 --source suite/query_rewrite_plugins/include/install_rewriter.inc
11
12 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
13 VALUES ( 'SELECT a FROM test.t1 WHERE a = ?',
14 'SELECT b FROM test.t1 WHERE a = ?' ),
15 ( 'SELECT 1, ?', 'SELECT "rewritten"' );
16
17 CALL query_rewrite.flush_rewrite_rules();
18
19 SELECT a FROM test.t1 WHERE a = 1;
20
21 PREPARE stmt1 FROM 'SELECT a FROM test.t1 WHERE a = 1';
22 EXECUTE stmt1;
23
24 PREPARE stmt2 FROM 'SELECT a FROM test.t1 WHERE a = ?';
25
26 SET @var = 1;
27 EXECUTE stmt2 USING @var;
28
29 SET @var = 2;
30 EXECUTE stmt2 USING @var;
31
32 SET @var = 3;
33 EXECUTE stmt2 USING @var;
34
35 PREPARE stmt3 FROM 'SELECT 1, ?';
36 SET @var= 1;
37 EXECUTE stmt3;
38
39 --echo # Can't be rewritten. We rewrite at prepare time, when we don't know
40 --echo # the value of the first '?'.
41 PREPARE stmt3 FROM 'SELECT ?, ?';
42 SET @var= 1;
43 EXECUTE stmt3 USING @var, @var;
44
45 DROP TABLE t1;
46 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc