diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2014-02-01 09:34:07 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2014-02-01 09:34:07 +0100 |
| commit | ba26b71d316e31ae6f5db57e13800f514ac83ec5 (patch) | |
| tree | 2fb522edcaf99f94040b8049c080cae436043dd2 /mysql-test/r/select_found.result | |
| parent | 27d45e46968e4bd623565688a997b83b0a5cc1a8 (diff) | |
| download | mariadb-git-ba26b71d316e31ae6f5db57e13800f514ac83ec5.tar.gz | |
MDEV-5549 Wrong row counter in found_rows() result
only let filesort() count rows for SQL_CALC_ROWS if it's using priority queue
Diffstat (limited to 'mysql-test/r/select_found.result')
| -rw-r--r-- | mysql-test/r/select_found.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result index 7896f8a9f4e..ee6d309f005 100644 --- a/mysql-test/r/select_found.result +++ b/mysql-test/r/select_found.result @@ -280,3 +280,14 @@ SELECT FOUND_ROWS(); FOUND_ROWS() 1 DROP TABLE t1; +create table t1 (f1 int primary key, f2 tinyint) engine=myisam; +insert t1 values (10,3),(11,2),(12,3); +create table t2 (f3 int primary key) engine=myisam; +insert t2 values (11),(12),(13); +select f1 from t1,t2 where f1=f3 and f2=3 order by f1; +f1 +12 +select found_rows(); +found_rows() +1 +drop table t1, t2; |