Debian Codegraph @

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

raw
1 #
2 # Include file that loads the error log into a table.
3 #
4
5 let $error_log_table_name=error_log;
6 let $log_error=`select @@log_error`;
7
8 disable_warnings;
9 eval CREATE TABLE IF NOT EXISTS $error_log_table_name ( line TEXT );
10 eval DELETE FROM $error_log_table_name;
11 enable_warnings;
12
13 replace_result $log_error ERROR_LOG;
14 eval LOAD DATA LOCAL INFILE '$log_error'
15 INTO TABLE $error_log_table_name FIELDS TERMINATED BY '\t';
16
17 # Fix line terminators for Windows.
18 eval UPDATE $error_log_table_name SET line = replace ( line, '\r', '' );
19
20 --disable_query_log
21 --disable_warnings
22 DROP FUNCTION IF EXISTS search_error_log;
23 --enable_warnings
24
25 DELIMITER //;
26
27 eval
28 CREATE FUNCTION search_error_log( level VARCHAR(10), pattern VARCHAR(100) )
29 RETURNS VARCHAR(400)
30 BEGIN
31 SELECT DISTINCT substring( line FROM instr(line, level) ) INTO @res
32 FROM $error_log_table_name WHERE line LIKE pattern;
33 RETURN @res;
34 END//
35
36 DELIMITER ;//
37
38 --enable_query_log