Debian Codegraph @

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

raw
1 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
2 --source suite/query_rewrite_plugins/include/install_rewriter.inc
3
4 CREATE USER rewrite_skipper@localhost;
5 GRANT SKIP_QUERY_REWRITE on *.* to rewrite_skipper@localhost;
6
7 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
8 VALUES ( 'INSERT INTO test.t1 VALUES(?, ?, ?)',
9 'INSERT INTO test.t1 VALUES(?, NULL, ?)' );
10
11 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
12 VALUES ( 'REPLACE INTO test.t1 VALUES(?, ?, ?)',
13 'REPLACE INTO test.t1 VALUES(? + 1, ? + 1, ? + 1)' );
14
15 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
16 VALUES ( 'UPDATE test.t1 SET b = ? WHERE a = ?',
17 'UPDATE test.t1 SET b = 123 WHERE a = ?' );
18
19 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
20 VALUES ( 'DELETE FROM test.t1 WHERE a = ?',
21 'DELETE FROM test.t1' );
22
23 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
24 VALUES ( 'SELECT a, b FROM test.t1',
25 'SELECT a, b, c FROM test.t1' );
26
27 CALL query_rewrite.flush_rewrite_rules();
28
29 CREATE TABLE t1 (a INT, b INT, c INT);
30
31 --echo #
32 --echo # Rewrites skipped for user 'rewrite_skipper' with SKIP_QUERY_REWRITE
33 --echo #
34
35 --connect (conn1, localhost, rewrite_skipper, , test)
36 --connection conn1
37
38 --echo Connected as rewrite_skipper
39
40 SELECT a, b FROM test.t1;
41
42 INSERT INTO test.t1 VALUES (2, 2, 2);
43 SELECT * FROM test.t1;
44
45 REPLACE INTO test.t1 VALUES (2, 2, 2);
46 SELECT * FROM test.t1;
47
48 UPDATE test.t1 SET b = 3 WHERE a = 2;
49 SELECT * FROM test.t1;
50
51 DELETE FROM test.t1 WHERE a = 1;
52 SELECT * FROM test.t1;
53
54 DELETE FROM test.t1;
55
56 --echo #
57 --echo # Rewrites never skipped for users without SKIP_QUERY_REWRITE privilege
58 --echo #
59
60 --connection default
61
62 --echo Connected as default user
63
64 INSERT INTO test.t1 VALUES (2, 2, 2);
65 SELECT * FROM test.t1;
66
67 REPLACE INTO test.t1 VALUES (2, 2, 2);
68 SELECT * FROM test.t1;
69
70 UPDATE test.t1 SET b = 3 WHERE a = 2;
71 SELECT * FROM test.t1;
72
73 SELECT a, b FROM test.t1;
74
75 DELETE FROM test.t1 WHERE a = 1;
76 SELECT * FROM test.t1;
77
78 --connection default
79 DROP TABLE t1;
80 DROP USER rewrite_skipper@localhost;
81
82 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc
83 --source include/disconnect_connections.inc