Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test of stored procedures. Queries within them will not be 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 ?, ?, ?', 'SELECT ?, ?' );
14
15 CALL query_rewrite.flush_rewrite_rules();
16
17 SELECT 1, 2, 3;
18
19 DELIMITER //;
20
21 CREATE PROCEDURE p1() SELECT 1, 2, 3//
22
23 CREATE PROCEDURE p2()
24 BEGIN
25 SELECT 1, 2, 3;
26 SELECT 4, 5, 6;
27 END//
28
29 DELIMITER ;//
30
31 CALL p1();
32 CALL p2();
33
34 DROP PROCEDURE p1;
35 DROP PROCEDURE p2;
36 DROP TABLE t1;
37 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc