diff options
Diffstat (limited to 'mysql-test/suite/percona/slow_extended.patch/percona_slow_extended-log_slow_filter.result')
-rw-r--r-- | mysql-test/suite/percona/slow_extended.patch/percona_slow_extended-log_slow_filter.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/suite/percona/slow_extended.patch/percona_slow_extended-log_slow_filter.result b/mysql-test/suite/percona/slow_extended.patch/percona_slow_extended-log_slow_filter.result new file mode 100644 index 00000000000..2f22ef5457b --- /dev/null +++ b/mysql-test/suite/percona/slow_extended.patch/percona_slow_extended-log_slow_filter.result @@ -0,0 +1,25 @@ +drop table if exists t; +# Create test table +create table t(id INT PRIMARY KEY) engine=InnoDB; +# Insert two rows to test table +insert into t values(1); +insert into t values(2); +insert into t values(3); +SET GLOBAL SLOW_QUERY_LOG=ON; +SELECT sleep(2); +sleep(2) +0 +set log_slow_filter=full_join; +SELECT sleep(2) union select t2.id from t as t1,t as t2; +sleep(2) +0 +1 +2 +3 +SELECT sleep(2); +sleep(2) +0 +SET GLOBAL SLOW_QUERY_LOG=OFF; +drop table if exists t; +FLUSH LOGS; +2 |