diff options
Diffstat (limited to 'mysql-test/t/select.test')
| -rw-r--r-- | mysql-test/t/select.test | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/t/select.test b/mysql-test/t/select.test index 893b9ba9267..3ae5839cd3c 100644 --- a/mysql-test/t/select.test +++ b/mysql-test/t/select.test @@ -2153,6 +2153,13 @@ INSERT INTO t1 SELECT 50, 3, 3 FROM DUAL WHERE NOT EXISTS (SELECT * FROM t1 WHERE a = 50 AND b = 3); +select found_rows(); SELECT * FROM t1; +select count(*) from t1; +select found_rows(); +select count(*) from t1 limit 2,3; +select found_rows(); +select SQL_CALC_FOUND_ROWS count(*) from t1 limit 2,3; +select found_rows(); DROP TABLE t1; |