diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-05 14:22:32 +0200 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-03-05 14:22:32 +0200 |
| commit | a02a98c4016bfeb663ee70d96d9612f030d30717 (patch) | |
| tree | b26ba6e3074e4d3e0e56a980e9feb0ee34a45885 /mysql-test/r/select_found.result | |
| parent | d737186f303e1503ff08b9a22f4c0394c3f1fad2 (diff) | |
| download | mariadb-git-a02a98c4016bfeb663ee70d96d9612f030d30717.tar.gz | |
several bug fixes and tests
mysql-test/mysql-test-run.sh:
Fix for LOAD DATA LOCAL ...
mysql-test/r/select_found.result:
Added result for a new test of combo of options for FOUND_ROWS and
BUFFER_RESULT
mysql-test/t/select_found.test:
Added test for combo of options for BUFFER_RESULT and FOUND_ROWS
sql/sql_select.cc:
Added fix for combo of options for BUFFER_RESULT and FOUND_ROWS
Diffstat (limited to 'mysql-test/r/select_found.result')
| -rw-r--r-- | mysql-test/r/select_found.result | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/select_found.result b/mysql-test/r/select_found.result index 3a84c3e52da..0e2cc108bb4 100644 --- a/mysql-test/r/select_found.result +++ b/mysql-test/r/select_found.result @@ -20,6 +20,12 @@ a b select found_rows(); FOUND_ROWS() 8 +select SQL_BUFFER_RESULT SQL_CALC_FOUND_ROWS * from t1 limit 1; +a b +1 2 +select found_rows(); +FOUND_ROWS() +8 select SQL_CALC_FOUND_ROWS * from t1 order by b desc limit 1; a b 8 9 |