Debian Codegraph @

mysql-test/suite/events/events_logs_tests.test

raw
1 # Can't test with embedded server that doesn't support grants
2 -- source include/not_embedded.inc
3 -- source include/no_view_protocol.inc
4
5 set @save_long_query_time=@@long_query_time;
6 --disable_warnings
7 drop database if exists events_test;
8 --enable_warnings
9 create database if not exists events_test;
10 use events_test;
11 --echo
12 --echo We use procedure here because its statements won't be
13 --echo logged into the general log. If we had used normal select
14 --echo that are logged in different ways depending on whether the
15 --echo test suite is run in normal mode or with --ps-protocol
16 --echo
17 delimiter |;
18 create procedure select_general_log()
19 begin
20 select user_host, argument from mysql.general_log
21 where argument like '%events_logs_test%' AND
22 (command_type = 'Query' OR command_type = 'Execute');
23 end|
24 delimiter ;|
25 --echo
26 --echo Check that general query log works, but sub-statements
27 --echo of the stored procedure do not leave traces in it.
28 --echo
29 truncate mysql.general_log;
30 # Logging format in ps protocol is slightly different
31 --disable_ps_protocol
32 select 'events_logs_tests' as outside_event;
33 --enable_ps_protocol
34 --replace_column 1 USER_HOST
35 call select_general_log();
36 --echo
37 --echo Check that unlike sub-statements of stored procedures,
38 --echo sub-statements of events are present in the general log.
39 --echo
40 set global event_scheduler=on;
41 truncate mysql.general_log;
42 create event ev_log_general on schedule at now() on completion not preserve do select 'events_logs_test' as inside_event;
43 --let $wait_condition=select count(*)=0 from information_schema.events where event_name='ev_log_general'
44 --source include/wait_condition.inc
45 --replace_column 1 USER_HOST
46 call select_general_log();
47
48 --echo
49 --echo Check slow query log
50 --echo
51 --echo Ensure that slow logging is on
52 show variables like 'slow_query_log';
53 --echo
54 --echo Demonstrate that session value has no effect
55 --echo
56 set @@session.long_query_time=1;
57 set @@global.long_query_time=300;
58 truncate mysql.slow_log;
59 create event ev_log_general on schedule at now() on completion not preserve
60 do select 'events_logs_test' as inside_event, sleep(1.5);
61 --let $wait_condition=select count(*)=0 from information_schema.events where event_name='ev_log_general'
62 --source include/wait_condition.inc
63 --echo
64 --echo Nothing should be logged
65 --echo
66 --replace_column 1 USER_HOST
67 select user_host, db, sql_text from mysql.slow_log
68 where sql_text like 'select \'events_logs_test\'%';
69 set @@global.long_query_time=1;
70 truncate mysql.slow_log;
71 create event ev_log_general on schedule at now() on completion not preserve
72 do select 'events_logs_test' as inside_event, sleep(1.5);
73 --let $wait_condition=select count(*)=0 from information_schema.events where event_name='ev_log_general'
74 --source include/wait_condition.inc
75 --echo
76 --echo Event sub-statement should be logged.
77 --echo
78 --replace_column 1 USER_HOST
79 select user_host, db, sql_text from mysql.slow_log
80 where sql_text like 'select \'events_logs_test\'%';
81
82 drop database events_test;
83 set global event_scheduler=off;
84 set @@global.long_query_time=@save_long_query_time;
85 set @@session.long_query_time=@save_long_query_time;
86
87 #
88 # Safety
89 #
90 let $wait_condition=
91 select count(*) = 0 from information_schema.processlist
92 where db='events_test' and command = 'Connect' and user=current_user();
93 --source include/wait_condition.inc