2
# This test is executed once after each test to check the servers
3
# for unexpected warnings found in the servers error log
5
# NOTE! mysql-test-run.pl has already done a rough filtering
6
# of the file and written any suspicious lines
7
# to $error_log.warnings file
11
# Don't write these queries to binlog
14
# Turn off any debug crashes, allow the variable to be
15
# non existent in release builds
21
create temporary table error_log (
22
row int auto_increment primary key,
23
suspicious int default 1,
24
file_name varchar(255),
25
line varchar(1024) default null
28
# Get the name of servers error log
29
let $log_error= $MTR_LOG_ERROR;
30
let $log_warning= $log_error.warnings;
32
# Try tload the warnings into a temporary table,
33
# it might fail with error saying "The MySQL server is
34
# running with the --secure-file-priv" in which case
35
# an attempt to load the file using LOAD DATA LOCAL is made
37
eval load data infile '$log_warning' into table error_log
38
fields terminated by 'xykls37' escaped by ''
41
set file_name='$log_error';
46
eval load data local infile '$log_warning' into table error_log
47
fields terminated by 'xykls37' escaped by ''
50
set file_name='$log_error';
53
# Call check_warnings to filter out any warning in
55
call mtr.check_warnings(@result);
56
if (`select @result = 0`){
60
echo ^ Found warnings!!;