diff options
author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-19 17:20:57 +0200 |
---|---|---|
committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-11-19 17:20:57 +0200 |
commit | a44c4c01112862ccdf4f95b229afa7b054923316 (patch) | |
tree | c5900d127968874cc7836f11042f20504d1ef658 /mysql-test/t/select_found.test | |
parent | 93ac635e74828c90be9a2adef3baee1842e7bd0c (diff) | |
download | mariadb-git-a44c4c01112862ccdf4f95b229afa7b054923316.tar.gz |
Makng sure that LIMIT 0 works in this case to:
select sql_calc_found_rows * from table limit 0;
It does ...
Diffstat (limited to 'mysql-test/t/select_found.test')
-rw-r--r-- | mysql-test/t/select_found.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/select_found.test b/mysql-test/t/select_found.test index c8458dd3aea..b380c86d2db 100644 --- a/mysql-test/t/select_found.test +++ b/mysql-test/t/select_found.test @@ -88,4 +88,6 @@ SELECT SQL_CALC_FOUND_ROWS 1 FROM (SELECT 1) LIMIT 0; SELECT FOUND_ROWS(); SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE numeropost > 1 LIMIT 0; SELECT FOUND_ROWS(); +SELECT SQL_CALC_FOUND_ROWS * FROM t1 LIMIT 0; +SELECT FOUND_ROWS(); drop table t1; |