Debian Codegraph @

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

raw
1 #
2 # Test of how rewritten queries are logged with --log-raw logging.
3 #
4 # Query rewrite plugin was installed.
5 INSERT INTO query_rewrite.rewrite_rules ( pattern, replacement )
6 VALUES ( 'SELECT"The_original_query"', 'SELECT"The_rewritten_query"' );
7 CALL query_rewrite.flush_rewrite_rules();
8 SET @old_log_output= @@global.log_output;
9 SET @old_general_log= @@global.general_log;
10 SET @old_general_log_file= @@global.general_log_file;
11 SET GLOBAL general_log_file = '.../log/rewrite_general.log';
12 SET GLOBAL log_output = 'FILE,TABLE';
13 SET GLOBAL general_log= 'ON';
14 SELECT 'The_original_query';
15 The_rewritten_query
16 The_rewritten_query
17 Warnings:
18 Note 1105 Query 'SELECT 'The_original_query'' rewritten to 'SELECT"The_rewritten_query"' by a query rewrite plugin
19 CREATE TABLE test_log ( line TEXT );
20 LOAD DATA LOCAL INFILE '.../log/rewrite_general.log'
21 INTO TABLE test_log FIELDS TERMINATED BY '\n'
22 IGNORE 3 LINES;
23 SELECT substring_index( line, ' ', -1 ) AS incoming_query
24 FROM test_log
25 WHERE line LIKE ( '%SELECT%' );
26 incoming_query
27 'The_original_query'
28 DROP TABLE test_log;
29 SET GLOBAL general_log = DEFAULT;
30 SET GLOBAL general_log_file= @old_general_log_file;
31 SET GLOBAL general_log= @old_general_log;
32 SET GLOBAL log_output= @old_log_output;
33 Warnings:
34 Warning 1620 Plugin is busy and will be uninstalled on shutdown
35 # Query rewrite plugin was queued for uninstalling.
36 SET @@global.log_output = @old_log_output;
37 SET @@global.general_log = @old_general_log;
38 SET @@global.general_log_file = @old_general_log_file;
39 TRUNCATE TABLE mysql.general_log;