Debian Codegraph @

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

raw
1 #
2 # Test of the various values of the verbose variable.
3 #
4 SET sql_mode = 'PIPES_AS_CONCAT';
5 # Query rewrite plugin was installed.
6 SHOW VARIABLES LIKE 'Rewriter_verbose';
7 Variable_name Value
8 rewriter_verbose 1
9 # We want notes to show in the error log.
10 SET @orig_log_error_verbosity= @@GLOBAL.log_error_verbosity;
11 SET @@global.log_error_verbosity=3;
12 SELECT @@log_error_verbosity;
13 @@log_error_verbosity
14 3
15 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
16 VALUES ( 'SELECT 1', 'SELECT "rewritten"' );
17 CALL query_rewrite.flush_rewrite_rules();
18 UPDATE performance_schema.setup_consumers
19 SET enabled = 'YES'
20 WHERE NAME = 'events_statements_history';
21 SET @@global.rewriter_verbose = 2;
22 SELECT 1;
23 rewritten
24 rewritten
25 Warnings:
26 Note 1105 Query 'SELECT 1' rewritten to 'SELECT "rewritten"' by a query rewrite plugin
27 SELECT 'nonrewritten';
28 nonrewritten
29 nonrewritten
30 SET @@global.rewriter_verbose = DEFAULT;
31 CREATE TABLE IF NOT EXISTS error_log ( line TEXT );
32 DELETE FROM error_log;
33 LOAD DATA LOCAL INFILE 'ERROR_LOG'
34 INTO TABLE error_log FIELDS TERMINATED BY '\t';
35 UPDATE error_log SET line = replace ( line, '\r', '' );
36 SELECT search_error_log( '[Note]', "%Plugin Rewriter reported: " ||
37 "'Statement \"SELECT 'nonrewritten'\"%" ) INTO @line;
38 SELECT @line;
39 @line
40 [Note] [MY-011235] [Server] Plugin Rewriter reported: 'Statement "SELECT 'nonrewritten'" with digest "d1b44b0c19af710b5a679907e284acd2ddc285201794bc69a2389d77baedddae" did not match any rule.'
41 SELECT digest INTO @pfs_digest
42 FROM performance_schema.events_statements_history_long
43 WHERE sql_text = "SELECT 'nonrewritten'"
44 LIMIT 1;
45 # Mask out the digest from the message
46 SELECT substring_index(substring_index(@line, 'digest "', -1), '"', 1)
47 INTO @log_digest;
48 SELECT @pfs_digest = @log_digest AS digest_is_correct;
49 digest_is_correct
50 1
51 DROP TABLE error_log;
52 DROP FUNCTION search_error_log;
53 Warnings:
54 Warning 1620 Plugin is busy and will be uninstalled on shutdown
55 # Query rewrite plugin was queued for uninstalling.
56 SET sql_mode = DEFAULT;
57 SET @@global.log_error_verbosity= @orig_log_error_verbosity;