Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/r/stored_procedures.result

raw
1 #
2 # Test of stored procedures. Queries within them will not be rewritten.
3 #
4 CREATE TABLE t1 ( a INTEGER, b CHAR(1) );
5 INSERT INTO t1 VALUES ( 1, 'a' ), ( 2, 'b' ), ( 3, 'c' );
6 # Query rewrite plugin was installed.
7 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
8 VALUES ( 'SELECT ?, ?, ?', 'SELECT ?, ?' );
9 CALL query_rewrite.flush_rewrite_rules();
10 SELECT 1, 2, 3;
11 1 2
12 1 2
13 Warnings:
14 Note 1105 Query 'SELECT 1, 2, 3' rewritten to 'SELECT 1, 2' by a query rewrite plugin
15 CREATE PROCEDURE p1() SELECT 1, 2, 3//
16 CREATE PROCEDURE p2()
17 BEGIN
18 SELECT 1, 2, 3;
19 SELECT 4, 5, 6;
20 END//
21 CALL p1();
22 1 2 3
23 1 2 3
24 CALL p2();
25 1 2 3
26 1 2 3
27 4 5 6
28 4 5 6
29 DROP PROCEDURE p1;
30 DROP PROCEDURE p2;
31 DROP TABLE t1;
32 Warnings:
33 Warning 1620 Plugin is busy and will be uninstalled on shutdown
34 # Query rewrite plugin was queued for uninstalling.