Debian Codegraph @

mysql-test/suite/query_rewrite_plugins/include/show_general_log.inc

raw
1 CREATE TABLE test_log ( line TEXT );
2
3 --replace_result $MYSQLTEST_VARDIR ...
4 eval LOAD DATA LOCAL INFILE '$MYSQLTEST_VARDIR/log/rewrite_general.log'
5 INTO TABLE test_log FIELDS TERMINATED BY '\n'
6 IGNORE 3 LINES;
7
8 SELECT substring_index( line, ' ', -1 ) AS incoming_query
9 FROM test_log
10 WHERE line LIKE ( '%SELECT%' );
11
12 DROP TABLE test_log;
13
14 SET GLOBAL general_log = DEFAULT;
15 SET GLOBAL general_log_file= @old_general_log_file;
16 SET GLOBAL general_log= @old_general_log;
17 SET GLOBAL log_output= @old_log_output;