Debian Codegraph @

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

raw
1 --echo #
2 --echo # Test of the various values of the verbose variable.
3 --echo #
4
5 SET sql_mode = 'PIPES_AS_CONCAT';
6 --source suite/query_rewrite_plugins/include/have_plugin_rewriter.inc
7 --source suite/query_rewrite_plugins/include/install_rewriter.inc
8
9 SHOW VARIABLES LIKE 'Rewriter_verbose';
10
11 --echo # We want notes to show in the error log.
12 SET @orig_log_error_verbosity= @@GLOBAL.log_error_verbosity;
13 SET @@global.log_error_verbosity=3;
14 SELECT @@log_error_verbosity;
15
16 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
17 VALUES ( 'SELECT 1', 'SELECT "rewritten"' );
18
19 CALL query_rewrite.flush_rewrite_rules();
20
21 UPDATE performance_schema.setup_consumers
22 SET enabled = 'YES'
23 WHERE NAME = 'events_statements_history';
24
25 SET @@global.rewriter_verbose = 2;
26
27 SELECT 1;
28 SELECT 'nonrewritten';
29
30 SET @@global.rewriter_verbose = DEFAULT;
31
32 --source suite/query_rewrite_plugins/include/load_error_log.inc
33 SELECT search_error_log( '[Note]', "%Plugin Rewriter reported: " ||
34 "'Statement \"SELECT 'nonrewritten'\"%" ) INTO @line;
35 SELECT @line;
36
37 SELECT digest INTO @pfs_digest
38 FROM performance_schema.events_statements_history_long
39 WHERE sql_text = "SELECT 'nonrewritten'"
40 LIMIT 1;
41
42 --echo # Mask out the digest from the message
43 SELECT substring_index(substring_index(@line, 'digest "', -1), '"', 1)
44 INTO @log_digest;
45
46 SELECT @pfs_digest = @log_digest AS digest_is_correct;
47
48 --source suite/query_rewrite_plugins/include/drop_error_log.inc
49 --source suite/query_rewrite_plugins/include/uninstall_rewriter.inc
50 SET sql_mode = DEFAULT;
51 SET @@global.log_error_verbosity= @orig_log_error_verbosity;