diff options
| author | monty@mysql.com <> | 2003-12-17 17:35:34 +0200 |
|---|---|---|
| committer | monty@mysql.com <> | 2003-12-17 17:35:34 +0200 |
| commit | e0cc6799ecc831d296c568c5068947c1421fcaa5 (patch) | |
| tree | 93924b5aab311e02a0f0931cf91e67cdfad04bdf /mysql-test/r/select_found.result | |
| parent | 0462f48b344633c7d88d12d9667f4bd50b91c552 (diff) | |
| parent | 30e318311b35b109d230f7184fe0be1b6e29f02b (diff) | |
| download | mariadb-git-e0cc6799ecc831d296c568c5068947c1421fcaa5.tar.gz | |
Merge with 4.0.17
Diffstat (limited to 'mysql-test/r/select_found.result')
| -rw-r--r-- | mysql-test/r/select_found.result | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result index 42f7257dbba..e302a0cefeb 100644 --- a/mysql-test/r/select_found.result +++ b/mysql-test/r/select_found.result @@ -189,3 +189,22 @@ SELECT FOUND_ROWS(); FOUND_ROWS() 3 drop table t1; +create table t1 (id int, primary key (id)); +insert into t1 values (1), (2), (3), (4), (5); +select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1; +id +4 +select FOUND_ROWS(); +FOUND_ROWS() +2 +select SQL_CALC_FOUND_ROWS * from t1 where id > 3 AND 1=2 limit 0, 1; +id +select FOUND_ROWS(); +FOUND_ROWS() +0 +select SQL_CALC_FOUND_ROWS * from t1 where id > 6 limit 0, 1; +id +select FOUND_ROWS(); +FOUND_ROWS() +0 +drop table t1; |