1
SET GLOBAL SLOW_QUERY_LOG=OFF;
2
drop table if exists t;
4
create table t(id INT PRIMARY KEY) engine=InnoDB;
5
# Insert two rows to test table
6
insert into t values(1);
7
insert into t values(2);
8
insert into t values(3);
9
SET GLOBAL SLOW_QUERY_LOG=ON;
13
set log_slow_filter=full_join;
14
SELECT sleep(2) union select t2.id from t as t1,t as t2;
23
drop table if exists t;