diff options
Diffstat (limited to 'mysql-test/t')
| -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 5bd068eb0e6..91879015b51 100644 --- a/mysql-test/t/select_found.test +++ b/mysql-test/t/select_found.test @@ -168,6 +168,21 @@ 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(); + +# # Bug #7945: group by + distinct with constant expression + limit # |