From 9705257270b28757eec9aac63f664a93dd5ac601 Mon Sep 17 00:00:00 2001 From: unknown Date: Tue, 19 Nov 2002 17:20:57 +0200 Subject: Makng sure that LIMIT 0 works in this case to: select sql_calc_found_rows * from table limit 0; It does ... --- mysql-test/t/select_found.test | 2 ++ 1 file changed, 2 insertions(+) (limited to 'mysql-test/t/select_found.test') 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; -- cgit v1.2.1