diff options
| author | ram@gw.mysql.r18.ru <> | 2004-10-27 14:51:17 +0500 |
|---|---|---|
| committer | ram@gw.mysql.r18.ru <> | 2004-10-27 14:51:17 +0500 |
| commit | 07743423f74e6613e69835fc46c8cb05b172591d (patch) | |
| tree | 11a701bade6b5090b099e0d7d848de197ead48a5 /mysql-test/t/select_found.test | |
| parent | cce8f5449d19b3feb15da247a4692e8d61763efa (diff) | |
| download | mariadb-git-07743423f74e6613e69835fc46c8cb05b172591d.tar.gz | |
A fix (bug #6089: FOUND_ROWS returns wrong values when no table/view is used).
Diffstat (limited to 'mysql-test/t/select_found.test')
| -rw-r--r-- | mysql-test/t/select_found.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/select_found.test b/mysql-test/t/select_found.test index 943174462e3..e51dd2442b9 100644 --- a/mysql-test/t/select_found.test +++ b/mysql-test/t/select_found.test @@ -166,3 +166,18 @@ INSERT INTO t1 VALUES (0), (0), (1), (2); SELECT SQL_CALC_FOUND_ROWS * FROM t1 WHERE a = 0 GROUP BY a HAVING a > 10; SELECT FOUND_ROWS(); DROP TABLE t1; + +# +# Bug #6089: queries which don't use any tables +# + +SELECT 'foo'; +SELECT FOUND_ROWS(); +SELECT SQL_CALC_FOUND_ROWS 'foo'; +SELECT FOUND_ROWS(); +SELECT SQL_CALC_FOUND_ROWS 'foo' limit 0; +SELECT FOUND_ROWS(); +SELECT FOUND_ROWS(); + +SELECT SQL_CALC_FOUND_ROWS 'foo' UNION SELECT 'bar' LIMIT 0; +SELECT FOUND_ROWS(); |