diff options
Diffstat (limited to 'mysql-test/suite/percona/percona_slow_extended-min_examined_row_limit.result')
-rw-r--r-- | mysql-test/suite/percona/percona_slow_extended-min_examined_row_limit.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/suite/percona/percona_slow_extended-min_examined_row_limit.result b/mysql-test/suite/percona/percona_slow_extended-min_examined_row_limit.result new file mode 100644 index 00000000000..1e8bc0723ac --- /dev/null +++ b/mysql-test/suite/percona/percona_slow_extended-min_examined_row_limit.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 min_examined_row_limit=5; +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 |