Debian Codegraph @

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

raw
1 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
2
3 --source suite/query_rewrite_plugins/include/install_rewriter.inc
4
5 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
6 VALUES ( 'SELECT "original"', 'SELECT "rewritten"' );
7
8 CALL query_rewrite.flush_rewrite_rules();
9
10 CREATE USER mysqluser1@localhost;
11 --connect (conn1, localhost, mysqluser1, , test)
12 --connection conn1
13
14 --error ER_TABLEACCESS_DENIED_ERROR
15 INSERT INTO query_rewrite.rewrite_rules ( pattern ) VALUES ( '' );
16 --error ER_TABLEACCESS_DENIED_ERROR
17 INSERT INTO query_rewrite.rewrite_rules ( replacement ) VALUES ( '' );
18 --error ER_TABLEACCESS_DENIED_ERROR
19 INSERT INTO query_rewrite.rewrite_rules ( enabled ) VALUES ( '' );
20 --error ER_TABLEACCESS_DENIED_ERROR
21 INSERT INTO query_rewrite.rewrite_rules ( message ) VALUES ( '' );
22
23 --error ER_TABLEACCESS_DENIED_ERROR
24 SELECT pattern FROM query_rewrite.rewrite_rules;
25 --error ER_TABLEACCESS_DENIED_ERROR
26 SELECT replacement FROM query_rewrite.rewrite_rules;
27 --error ER_TABLEACCESS_DENIED_ERROR
28 SELECT enabled FROM query_rewrite.rewrite_rules;
29 --error ER_TABLEACCESS_DENIED_ERROR
30 SELECT message FROM query_rewrite.rewrite_rules;
31
32 --error ER_TABLEACCESS_DENIED_ERROR
33 UPDATE query_rewrite.rewrite_rules SET pattern = '';
34 --error ER_TABLEACCESS_DENIED_ERROR
35 UPDATE query_rewrite.rewrite_rules SET replacement = '';
36 --error ER_TABLEACCESS_DENIED_ERROR
37 UPDATE query_rewrite.rewrite_rules SET enabled = '';
38 --error ER_TABLEACCESS_DENIED_ERROR
39 UPDATE query_rewrite.rewrite_rules SET message = '';
40
41 --error ER_PROCACCESS_DENIED_ERROR
42 CALL query_rewrite.flush_rewrite_rules();
43
44 SELECT 'original';
45
46 --disconnect conn1
47 --connection default
48 DROP USER mysqluser1@localhost;
49
50 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc