Debian Codegraph @

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

raw
1 #
2 # Tests of touching the rules table from different transactions.
3 #
4 # Query rewrite plugin was installed.
5 SET autocommit = 0;
6 SELECT @@autocommit;
7 @@autocommit
8 0
9 START TRANSACTION;
10 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
11 VALUES ( 'SELECT "Rewrite me conn 1"', 'SELECT "Rewritten conn 1 rule 1"' );
12 COMMIT;
13 START TRANSACTION;
14 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
15 VALUES ( 'SELECT "Rewrite me conn 2"', 'SELECT "Rewritten conn 2 rule 1"' );
16 COMMIT;
17 CALL query_rewrite.flush_rewrite_rules();
18 SELECT "Rewrite me conn 1";
19 Rewritten conn 1 rule 1
20 Rewritten conn 1 rule 1
21 Warnings:
22 Note 1105 Query 'SELECT "Rewrite me conn 1"' rewritten to 'SELECT "Rewritten conn 1 rule 1"' by a query rewrite plugin
23 SELECT "Rewrite me conn 2";
24 Rewritten conn 2 rule 1
25 Rewritten conn 2 rule 1
26 Warnings:
27 Note 1105 Query 'SELECT "Rewrite me conn 2"' rewritten to 'SELECT "Rewritten conn 2 rule 1"' by a query rewrite plugin
28 CALL query_rewrite.flush_rewrite_rules();
29 SELECT "Rewrite me conn 1";
30 Rewritten conn 1 rule 1
31 Rewritten conn 1 rule 1
32 Warnings:
33 Note 1105 Query 'SELECT "Rewrite me conn 1"' rewritten to 'SELECT "Rewritten conn 1 rule 1"' by a query rewrite plugin
34 SELECT "Rewrite me conn 2";
35 Rewritten conn 2 rule 1
36 Rewritten conn 2 rule 1
37 Warnings:
38 Note 1105 Query 'SELECT "Rewrite me conn 2"' rewritten to 'SELECT "Rewritten conn 2 rule 1"' by a query rewrite plugin
39 SELECT "Rewrite me conn 1";
40 Rewritten conn 1 rule 1
41 Rewritten conn 1 rule 1
42 Warnings:
43 Note 1105 Query 'SELECT "Rewrite me conn 1"' rewritten to 'SELECT "Rewritten conn 1 rule 1"' by a query rewrite plugin
44 SELECT "Rewrite me conn 2";
45 Rewritten conn 2 rule 1
46 Rewritten conn 2 rule 1
47 Warnings:
48 Note 1105 Query 'SELECT "Rewrite me conn 2"' rewritten to 'SELECT "Rewritten conn 2 rule 1"' by a query rewrite plugin
49 # This would cause failed assertion unless the mdl locks are released.
50 SELECT xxx(pattern) FROM query_rewrite.rewrite_rules;
51 ERROR 42000: FUNCTION test.xxx does not exist
52 Warnings:
53 Warning 1620 Plugin is busy and will be uninstalled on shutdown
54 # Query rewrite plugin was queued for uninstalling.
55 #
56 # Now make sure that everything works as long we do as we're supposed
57 # to, even with autocommit = 0.
58 #
59 SET autocommit = 0;
60 SELECT @@autocommit;
61 @@autocommit
62 0
63 # Query rewrite plugin was installed.
64 START TRANSACTION;
65 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
66 VALUES ( 'SELECT "Rewrite me"', 'SELECT "Rewritten w/rule 1"' );
67 CALL query_rewrite.flush_rewrite_rules();
68 SELECT 'Rewrite me';
69 Rewritten w/rule 1
70 Rewritten w/rule 1
71 Warnings:
72 Note 1105 Query 'SELECT 'Rewrite me'' rewritten to 'SELECT "Rewritten w/rule 1"' by a query rewrite plugin
73 SHOW STATUS LIKE 'Rewriter_%';
74 Variable_name Value
75 Rewriter_number_loaded_rules 1
76 Rewriter_number_reloads 2
77 Rewriter_number_rewritten_queries 1
78 Rewriter_reload_error OFF
79 Warnings:
80 Warning 1620 Plugin is busy and will be uninstalled on shutdown
81 # Query rewrite plugin was queued for uninstalling.
82 #
83 # Now check that we don't fail even if @@autocommit is 0. In this case
84 # InnoDB times out waiting for a lock, the plugin can't load the rules,
85 # and we expect a message in the error log.
86 #
87 SET autocommit = 0;
88 SELECT @@autocommit;
89 @@autocommit
90 0
91 # Query rewrite plugin was installed.
92 CALL mtr.add_suppression("Got error from storage engine while refreshing rewrite rules.");
93 # This would cause failed assertion unless the mdl locks are released.
94 SELECT xxx(pattern) FROM query_rewrite.rewrite_rules;
95 ERROR 42000: FUNCTION test.xxx does not exist
96 START TRANSACTION;
97 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
98 VALUES ( 'SELECT "Rewrite me"', 'SELECT "Rewritten w/rule 1"' );
99 SET @@global.innodb_lock_wait_timeout = 1;
100 SELECT load_rewrite_rules();
101 load_rewrite_rules()
102 Loading of some rule(s) failed.
103 SET @@global.innodb_lock_wait_timeout = DEFAULT;
104 SELECT 'Rewrite me';
105 Rewrite me
106 Rewrite me
107 SHOW STATUS LIKE 'Rewriter_%';
108 Variable_name Value
109 Rewriter_number_loaded_rules 0
110 Rewriter_number_reloads 2
111 Rewriter_number_rewritten_queries 0
112 Rewriter_reload_error ON
113 COMMIT;
114 SELECT 'Rewrite me';
115 Rewrite me
116 Rewrite me
117 SHOW STATUS LIKE 'Rewriter_%';
118 Variable_name Value
119 Rewriter_number_loaded_rules 0
120 Rewriter_number_reloads 2
121 Rewriter_number_rewritten_queries 0
122 Rewriter_reload_error ON
123 SELECT load_rewrite_rules();
124 load_rewrite_rules()
125 NULL
126 SELECT 'Rewrite me';
127 Rewritten w/rule 1
128 Rewritten w/rule 1
129 Warnings:
130 Note 1105 Query 'SELECT 'Rewrite me'' rewritten to 'SELECT "Rewritten w/rule 1"' by a query rewrite plugin
131 SHOW STATUS LIKE 'Rewriter_%';
132 Variable_name Value
133 Rewriter_number_loaded_rules 1
134 Rewriter_number_reloads 3
135 Rewriter_number_rewritten_queries 1
136 Rewriter_reload_error OFF
137 Warnings:
138 Warning 1620 Plugin is busy and will be uninstalled on shutdown
139 # Query rewrite plugin was queued for uninstalling.
140 #
141 # Now let's make sure that everything works fine if we run with
142 # autocommit.
143 #
144 SET autocommit = 1;
145 SELECT @@autocommit;
146 @@autocommit
147 1
148 # Query rewrite plugin was installed.
149 # This would cause failed assertion unless the mdl locks are released.
150 SELECT xxx(pattern) FROM query_rewrite.rewrite_rules;
151 ERROR 42000: FUNCTION test.xxx does not exist
152 START TRANSACTION;
153 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
154 VALUES ( 'SELECT "Rewrite me"', 'SELECT "Rewritten w/rule 1"' );
155 SET @@global.innodb_lock_wait_timeout = 1;
156 SELECT load_rewrite_rules();
157 load_rewrite_rules()
158 Loading of some rule(s) failed.
159 SET @@global.innodb_lock_wait_timeout = DEFAULT;
160 SELECT 'Rewrite me';
161 Rewrite me
162 Rewrite me
163 COMMIT;
164 SELECT 'Rewrite me';
165 Rewrite me
166 Rewrite me
167 SELECT load_rewrite_rules();
168 load_rewrite_rules()
169 NULL
170 SELECT 'Rewrite me';
171 Rewritten w/rule 1
172 Rewritten w/rule 1
173 Warnings:
174 Note 1105 Query 'SELECT 'Rewrite me'' rewritten to 'SELECT "Rewritten w/rule 1"' by a query rewrite plugin
175 SET autocommit = DEFAULT;
176 Warnings:
177 Warning 1620 Plugin is busy and will be uninstalled on shutdown
178 # Query rewrite plugin was queued for uninstalling.
179 #
180 # Bug#36784795 Query rewrite plugin not working when server runs with
181 # autocommit=OFF
182 #
183 # Query rewrite plugin was installed.
184 SET GLOBAL autocommit = 0;
185 SET SESSION autocommit = ON;
186 DELETE FROM query_rewrite.rewrite_rules;
187 INSERT INTO query_rewrite.rewrite_rules (pattern, replacement)
188 VALUES('SELECT ?', 'SELECT ? + 1');
189 SELECT * FROM query_rewrite.rewrite_rules;
190 id pattern pattern_database replacement enabled message pattern_digest normalized_pattern
191 1 SELECT ? NULL SELECT ? + 1 YES NULL NULL NULL
192 CALL query_rewrite.flush_rewrite_rules();
193 SELECT * FROM query_rewrite.rewrite_rules;
194 id pattern pattern_database replacement enabled message pattern_digest normalized_pattern
195 1 SELECT ? NULL SELECT ? + 1 YES NULL d1b44b0c19af710b5a679907e284acd2ddc285201794bc69a2389d77baedddae select ?
196 SET GLOBAL autocommit = DEFAULT;
197 SET SESSION autocommit = DEFAULT;
198 Warnings:
199 Warning 1620 Plugin is busy and will be uninstalled on shutdown
200 # Query rewrite plugin was queued for uninstalling.