diff options
| author | monty@hundin.mysql.fi <> | 2002-02-08 03:21:34 +0200 |
|---|---|---|
| committer | monty@hundin.mysql.fi <> | 2002-02-08 03:21:34 +0200 |
| commit | d36ac6b669d8dba848ebedbae84fd71e4e20048d (patch) | |
| tree | 6fb2be8a25c87f580e5d7831b049ad0839a48237 /mysql-test/r/select_found.result | |
| parent | 040b5c2997158eec07858c1506ada10d76f82ab5 (diff) | |
| download | mariadb-git-d36ac6b669d8dba848ebedbae84fd71e4e20048d.tar.gz | |
Fix some bugs introduced with the new my_getopt
Added counting of rollback's and commits
Fixed bug in 'SELECT 0 LIMIT 0'
Fixed bug in 'SELECT SQL_CALC_FOUND_ROWS'
Diffstat (limited to 'mysql-test/r/select_found.result')
| -rw-r--r-- | mysql-test/r/select_found.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result index 2fab1642cc5..3a84c3e52da 100644 --- a/mysql-test/r/select_found.result +++ b/mysql-test/r/select_found.result @@ -45,3 +45,20 @@ select found_rows(); FOUND_ROWS() 8 drop table t1; +create table t1 (a int not null primary key); +insert into t1 values (1),(2),(3),(4),(5); +select sql_calc_found_rows a from t1 where a in (1,2,3) order by a desc limit 0,2; +a +3 +2 +select FOUND_ROWS(); +FOUND_ROWS() +3 +select sql_calc_found_rows a from t1 where a in (1,2,3) order by a+2 desc limit 0,2; +a +3 +2 +select FOUND_ROWS(); +FOUND_ROWS() +3 +drop table t1; |