Debian Codegraph @

mysql-test/suite/events/events_logs_tests.result

raw
1 set @save_long_query_time=@@long_query_time;
2 drop database if exists events_test;
3 create database if not exists events_test;
4 use events_test;
5
6 We use procedure here because its statements won't be
7 logged into the general log. If we had used normal select
8 that are logged in different ways depending on whether the
9 test suite is run in normal mode or with --ps-protocol
10
11 create procedure select_general_log()
12 begin
13 select user_host, argument from mysql.general_log
14 where argument like '%events_logs_test%' AND
15 (command_type = 'Query' OR command_type = 'Execute');
16 end|
17
18 Check that general query log works, but sub-statements
19 of the stored procedure do not leave traces in it.
20
21 truncate mysql.general_log;
22 select 'events_logs_tests' as outside_event;
23 outside_event
24 events_logs_tests
25 call select_general_log();
26 user_host argument
27 USER_HOST select 'events_logs_tests' as outside_event
28
29 Check that unlike sub-statements of stored procedures,
30 sub-statements of events are present in the general log.
31
32 set global event_scheduler=on;
33 truncate mysql.general_log;
34 create event ev_log_general on schedule at now() on completion not preserve do select 'events_logs_test' as inside_event;
35 call select_general_log();
36 user_host argument
37 USER_HOST create event ev_log_general on schedule at now() on completion not preserve do select 'events_logs_test' as inside_event
38 USER_HOST select 'events_logs_test' as inside_event
39
40 Check slow query log
41
42 Ensure that slow logging is on
43 show variables like 'slow_query_log';
44 Variable_name Value
45 slow_query_log ON
46
47 Demonstrate that session value has no effect
48
49 set @@session.long_query_time=1;
50 set @@global.long_query_time=300;
51 truncate mysql.slow_log;
52 create event ev_log_general on schedule at now() on completion not preserve
53 do select 'events_logs_test' as inside_event, sleep(1.5);
54
55 Nothing should be logged
56
57 select user_host, db, sql_text from mysql.slow_log
58 where sql_text like 'select \'events_logs_test\'%';
59 user_host db sql_text
60 set @@global.long_query_time=1;
61 truncate mysql.slow_log;
62 create event ev_log_general on schedule at now() on completion not preserve
63 do select 'events_logs_test' as inside_event, sleep(1.5);
64
65 Event sub-statement should be logged.
66
67 select user_host, db, sql_text from mysql.slow_log
68 where sql_text like 'select \'events_logs_test\'%';
69 user_host db sql_text
70 USER_HOST events_test select 'events_logs_test' as inside_event, sleep(1.5)
71 drop database events_test;
72 set global event_scheduler=off;
73 set @@global.long_query_time=@save_long_query_time;
74 set @@session.long_query_time=@save_long_query_time;