Debian Codegraph @

mysql-test/suite/plugins/t/sql_error_log_withdbinfo.test

raw
1 --source include/not_embedded.inc
2
3 if (!$SQL_ERRLOG_SO) {
4 skip No SQL_ERROR_LOG plugin;
5 }
6
7 show variables like 'sql_error_log%';
8 set global sql_error_log_rate=1;
9
10 let $MYSQLD_DATADIR= `SELECT @@datadir`;
11
12 --echo # Trying to set the variable at runtime
13
14 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
15 SET sql_error_log_with_db_and_thread_info=OFF;
16
17 --echo #
18 --echo # Using test database from mtr
19 --echo #
20
21 --error ER_DB_DROP_EXISTS
22 DROP DATABASE db;
23
24 --echo #
25 --echo # Using no database at all
26 --echo #
27
28
29 connect (con1,localhost,root,,*NO-ONE*);
30 --error ER_DB_DROP_EXISTS
31 DROP DATABASE dbnodb;
32 disconnect con1;
33 connection default;
34
35 --echo #
36 --echo # Using database with name `NULL`
37 --echo #
38 CREATE DATABASE `NULL`;
39 USE `NULL`;
40 --error ER_DB_DROP_EXISTS
41 DROP DATABASE db;
42
43
44 --let SEARCH_FILE= $MYSQLD_DATADIR/sql_errors.log
45 --let LINES_TO_READ=7
46 --replace_regex /[1-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [ 0-9][0-9]:[0-9][0-9]:[0-9][0-9] [0-9]* .* @ .* `mtr` /TIME THREAD_ID HOSTNAME `mtr` //[1-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [ 0-9][0-9]:[0-9][0-9]:[0-9][0-9] [0-9]* .* @ .* `test` /TIME THREAD_ID HOSTNAME `test` //[1-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [ 0-9][0-9]:[0-9][0-9]:[0-9][0-9] [0-9]* .* @ .* NULL /TIME THREAD_ID HOSTNAME NULL //[1-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9] [ 0-9][0-9]:[0-9][0-9]:[0-9][0-9] [0-9]* .* @ .* `NULL` /TIME THREAD_ID HOSTNAME `NULL` /
47 --source include/read_head.inc
48
49 DROP DATABASE `NULL`;