Debian Codegraph @

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

raw
1 # Query rewrite plugin was installed.
2 CREATE USER rewrite_skipper@localhost;
3 GRANT SKIP_QUERY_REWRITE on *.* to rewrite_skipper@localhost;
4 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
5 VALUES ( 'INSERT INTO test.t1 VALUES(?, ?, ?)',
6 'INSERT INTO test.t1 VALUES(?, NULL, ?)' );
7 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
8 VALUES ( 'REPLACE INTO test.t1 VALUES(?, ?, ?)',
9 'REPLACE INTO test.t1 VALUES(? + 1, ? + 1, ? + 1)' );
10 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
11 VALUES ( 'UPDATE test.t1 SET b = ? WHERE a = ?',
12 'UPDATE test.t1 SET b = 123 WHERE a = ?' );
13 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
14 VALUES ( 'DELETE FROM test.t1 WHERE a = ?',
15 'DELETE FROM test.t1' );
16 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
17 VALUES ( 'SELECT a, b FROM test.t1',
18 'SELECT a, b, c FROM test.t1' );
19 CALL query_rewrite.flush_rewrite_rules();
20 CREATE TABLE t1 (a INT, b INT, c INT);
21 #
22 # Rewrites skipped for user 'rewrite_skipper' with SKIP_QUERY_REWRITE
23 #
24 Connected as rewrite_skipper
25 SELECT a, b FROM test.t1;
26 a b
27 INSERT INTO test.t1 VALUES (2, 2, 2);
28 SELECT * FROM test.t1;
29 a b c
30 2 2 2
31 REPLACE INTO test.t1 VALUES (2, 2, 2);
32 SELECT * FROM test.t1;
33 a b c
34 2 2 2
35 2 2 2
36 UPDATE test.t1 SET b = 3 WHERE a = 2;
37 SELECT * FROM test.t1;
38 a b c
39 2 3 2
40 2 3 2
41 DELETE FROM test.t1 WHERE a = 1;
42 SELECT * FROM test.t1;
43 a b c
44 2 3 2
45 2 3 2
46 DELETE FROM test.t1;
47 #
48 # Rewrites never skipped for users without SKIP_QUERY_REWRITE privilege
49 #
50 Connected as default user
51 INSERT INTO test.t1 VALUES (2, 2, 2);
52 Warnings:
53 Note 1105 Query 'INSERT INTO test.t1 VALUES (2, 2, 2)' rewritten to 'INSERT INTO test.t1 VALUES(2, NULL, 2)' by a query rewrite plugin
54 SELECT * FROM test.t1;
55 a b c
56 2 NULL 2
57 REPLACE INTO test.t1 VALUES (2, 2, 2);
58 Warnings:
59 Note 1105 Query 'REPLACE INTO test.t1 VALUES (2, 2, 2)' rewritten to 'REPLACE INTO test.t1 VALUES(2 + 1, 2 + 1, 2 + 1)' by a query rewrite plugin
60 SELECT * FROM test.t1;
61 a b c
62 2 NULL 2
63 3 3 3
64 UPDATE test.t1 SET b = 3 WHERE a = 2;
65 Warnings:
66 Note 1105 Query 'UPDATE test.t1 SET b = 3 WHERE a = 2' rewritten to 'UPDATE test.t1 SET b = 123 WHERE a = 3' by a query rewrite plugin
67 SELECT * FROM test.t1;
68 a b c
69 2 NULL 2
70 3 123 3
71 SELECT a, b FROM test.t1;
72 a b c
73 2 NULL 2
74 3 123 3
75 Warnings:
76 Note 1105 Query 'SELECT a, b FROM test.t1' rewritten to 'SELECT a, b, c FROM test.t1' by a query rewrite plugin
77 DELETE FROM test.t1 WHERE a = 1;
78 Warnings:
79 Note 1105 Query 'DELETE FROM test.t1 WHERE a = 1' rewritten to 'DELETE FROM test.t1' by a query rewrite plugin
80 SELECT * FROM test.t1;
81 a b c
82 DROP TABLE t1;
83 DROP USER rewrite_skipper@localhost;
84 Warnings:
85 Warning 1620 Plugin is busy and will be uninstalled on shutdown
86 # Query rewrite plugin was queued for uninstalling.