Debian Codegraph @

mysql-test/suite/perfschema/r/rewritten_queries.result

raw
1
2 # Connection 1
3
4 CREATE TABLE test.t1(a int, b varchar(80));
5 INSERT INTO test.t1 VALUES (1, "a"), (2, "b"), (3, "c");
6 SELECT * FROM test.t1;
7 a b
8 1 a
9 2 b
10 3 c
11 BEGIN;
12 SELECT * FROM test.t1 FOR UPDATE;
13 a b
14 1 a
15 2 b
16 3 c
17
18 # Regular query
19
20 SELECT "This is not secret" as normal_query;
21 normal_query
22 This is not secret
23 mark PROCESSLIST_INFO
24 thread NULL
25 mark INFO
26 processlist NULL
27 mark INFO
28 I_S.PROCESSLIST NULL
29 Warnings:
30 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
31 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
32 current statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
33 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
34 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
35 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
36 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
37 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
38 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
39 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
40 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
41
42 # Regular query (in flight)
43
44 INSERT INTO test.t1 VALUES (4, "This is not secret");;
45 mark PROCESSLIST_INFO
46 thread INSERT INTO test.t1 VALUES (4, "This is not secret")
47 mark INFO
48 processlist INSERT INTO test.t1 VALUES (4, "This is not secret")
49 mark INFO
50 I_S.PROCESSLIST INSERT INTO test.t1 VALUES (4, "This is not secret")
51 Warnings:
52 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
53 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
54 current statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
55 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
56 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
57 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
58 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
59 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
60 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
61 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
62 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
63 COMMIT;
64 mark PROCESSLIST_INFO
65 thread NULL
66 mark INFO
67 processlist NULL
68 mark INFO
69 I_S.PROCESSLIST NULL
70 Warnings:
71 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
72 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
73 current statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
74 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
75 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
76 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
77 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
78 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
79 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
80 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
81 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
82 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
83 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
84
85 # Sensitive query
86
87 CREATE USER alice IDENTIFIED BY 'thisisapassword';
88 mark PROCESSLIST_INFO
89 thread NULL
90 mark INFO
91 processlist NULL
92 mark INFO
93 I_S.PROCESSLIST NULL
94 Warnings:
95 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
96 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
97 current statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
98 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
99 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
100 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
101 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
102 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
103 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
104 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
105 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
106 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
107 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
108 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
109 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
110
111 # Regular prepared statement (prepare)
112
113 PREPARE stmt FROM "SELECT 'This is not a secret either' as prepared_query";
114 mark PROCESSLIST_INFO
115 thread NULL
116 mark INFO
117 processlist NULL
118 mark INFO
119 I_S.PROCESSLIST NULL
120 Warnings:
121 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
122 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
123 current statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
124 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
125 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
126 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
127 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
128 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
129 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
130 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
131 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
132 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
133 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
134 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
135 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
136 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
137 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
138
139 # Regular prepared statement (execute)
140
141 EXECUTE stmt;
142 prepared_query
143 This is not a secret either
144 mark PROCESSLIST_INFO
145 thread NULL
146 mark INFO
147 processlist NULL
148 mark INFO
149 I_S.PROCESSLIST NULL
150 Warnings:
151 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
152 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
153 current statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
154 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
155 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
156 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
157 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
158 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
159 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
160 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
161 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
162 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
163 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
164 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
165 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
166 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
167 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
168 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
169 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
170
171 # Regular prepared statement (deallocate)
172
173 DEALLOCATE PREPARE stmt;
174 mark PROCESSLIST_INFO
175 thread NULL
176 mark INFO
177 processlist NULL
178 mark INFO
179 I_S.PROCESSLIST NULL
180 Warnings:
181 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
182 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
183 current statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
184 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
185 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
186 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
187 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
188 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
189 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
190 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
191 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
192 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
193 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
194 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
195 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
196 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
197 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
198 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
199 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
200 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
201 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
202 BEGIN;
203 SELECT * FROM test.t1 FOR UPDATE;
204 a b
205 1 a
206 2 b
207 3 c
208 4 This is not secret
209
210 # Regular prepared statement (prepare)
211
212 PREPARE stmt FROM "INSERT INTO test.t1 VALUES (5, 'This is not secret either')";
213 mark PROCESSLIST_INFO
214 thread NULL
215 mark INFO
216 processlist NULL
217 mark INFO
218 I_S.PROCESSLIST NULL
219 Warnings:
220 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
221 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
222 current statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
223 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
224 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
225 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
226 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
227 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
228 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
229 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
230 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
231 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
232 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
233 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
234 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
235 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
236 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
237 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
238 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
239 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
240 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
241 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
242 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
243
244 # Regular prepared statement (execute, in flight)
245
246 EXECUTE stmt;;
247 mark PROCESSLIST_INFO
248 thread INSERT INTO test.t1 VALUES (5, 'This is not secret either')
249 mark INFO
250 processlist INSERT INTO test.t1 VALUES (5, 'This is not secret either')
251 mark INFO
252 I_S.PROCESSLIST INSERT INTO test.t1 VALUES (5, 'This is not secret either')
253 Warnings:
254 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
255 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
256 current statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
257 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
258 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
259 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
260 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
261 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
262 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
263 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
264 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
265 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
266 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
267 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
268 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
269 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
270 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
271 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
272 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
273 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
274 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
275 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
276 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
277 COMMIT;
278 mark PROCESSLIST_INFO
279 thread NULL
280 mark INFO
281 processlist NULL
282 mark INFO
283 I_S.PROCESSLIST NULL
284 Warnings:
285 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
286 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
287 current statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
288 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
289 history statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
290 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
291 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
292 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
293 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
294 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
295 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
296 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
297 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
298 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
299 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
300 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
301 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
302 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
303 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
304 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
305 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
306 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
307 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
308 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
309 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
310
311 # Regular prepared statement (deallocate)
312
313 DEALLOCATE PREPARE stmt;
314 mark PROCESSLIST_INFO
315 thread NULL
316 mark INFO
317 processlist NULL
318 mark INFO
319 I_S.PROCESSLIST NULL
320 Warnings:
321 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
322 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
323 current statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
324 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
325 history statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
326 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
327 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
328 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
329 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
330 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
331 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
332 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
333 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
334 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
335 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
336 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
337 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
338 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
339 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
340 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
341 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
342 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
343 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
344 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
345 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
346 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
347
348 # Sensitive prepared statement (prepare)
349
350 PREPARE stmt FROM "CREATE USER bob IDENTIFIED BY 'thisisapassword'";
351 mark PROCESSLIST_INFO
352 thread NULL
353 mark INFO
354 processlist NULL
355 mark INFO
356 I_S.PROCESSLIST NULL
357 Warnings:
358 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
359 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
360 current statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
361 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
362 history statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
363 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
364 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
365 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
366 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
367 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
368 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
369 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
370 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
371 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
372 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
373 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
374 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
375 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
376 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
377 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
378 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
379 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
380 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
381 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
382 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
383 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
384 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
385
386 # Sensitive prepared statement (execute)
387
388 EXECUTE stmt;
389 mark PROCESSLIST_INFO
390 thread NULL
391 mark INFO
392 processlist NULL
393 mark INFO
394 I_S.PROCESSLIST NULL
395 Warnings:
396 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
397 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
398 current statement/sql/execute_sql CREATE USER 'bob'@'%' IDENTIFIED BY <secret> EXECUTE `stmt`
399 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
400 history statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
401 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
402 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
403 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
404 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
405 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
406 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
407 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
408 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
409 history statement/sql/execute_sql CREATE USER 'bob'@'%' IDENTIFIED BY <secret> EXECUTE `stmt`
410 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
411 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
412 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
413 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
414 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
415 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
416 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
417 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
418 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
419 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
420 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
421 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
422 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
423 history_long statement/sql/execute_sql CREATE USER 'bob'@'%' IDENTIFIED BY <secret> EXECUTE `stmt`
424
425 # Sensitive prepared statement (deallocate)
426
427 DEALLOCATE PREPARE stmt;
428 mark PROCESSLIST_INFO
429 thread NULL
430 mark INFO
431 processlist NULL
432 mark INFO
433 I_S.PROCESSLIST NULL
434 Warnings:
435 Warning 1287 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release. Please use performance_schema.processlist instead
436 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
437 current statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
438 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
439 history statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
440 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
441 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
442 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
443 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
444 history statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
445 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
446 history statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
447 history statement/sql/execute_sql CREATE USER 'bob'@'%' IDENTIFIED BY <secret> EXECUTE `stmt`
448 history statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
449 mark EVENT_NAME SQL_TEXT DIGEST_TEXT
450 history_long statement/sql/select SELECT ps_current_thread_id() SELECT `ps_current_thread_id` ( )
451 history_long statement/sql/select SELECT connection_id() SELECT `connection_id` ( )
452 history_long statement/sql/select SELECT "This is not secret" as normal_query SELECT ? AS `normal_query`
453 history_long statement/sql/insert INSERT INTO test.t1 VALUES (4, "This is not secret") INSERT INTO `test` . `t1` VALUES (...)
454 history_long statement/sql/create_user CREATE USER 'alice'@'%' IDENTIFIED BY <secret> CREATE SYSTEM_USER `alice` IDENTIFIED BY ?
455 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
456 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
457 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
458 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
459 history_long statement/sql/execute_sql EXECUTE stmt EXECUTE `stmt`
460 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
461 history_long statement/sql/prepare_sql PREPARE stmt FROM ... PREPARE `stmt` FROM ?
462 history_long statement/sql/execute_sql CREATE USER 'bob'@'%' IDENTIFIED BY <secret> EXECUTE `stmt`
463 history_long statement/sql/dealloc_sql DEALLOCATE PREPARE stmt DEALLOCATE PREPARE `stmt`
464 DROP USER alice;
465 DROP USER bob;
466 DROP TABLE test.t1;