diff options
Diffstat (limited to 'mysql-test/t/select_found.test')
| -rw-r--r-- | mysql-test/t/select_found.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/select_found.test b/mysql-test/t/select_found.test index 0a483c860cb..f5ee4d5c010 100644 --- a/mysql-test/t/select_found.test +++ b/mysql-test/t/select_found.test @@ -85,3 +85,17 @@ INSERT INTO t1 (titre,maxnumrep) VALUES SELECT SQL_CALC_FOUND_ROWS titre,numeropost,maxnumrep FROM t1 WHERE numeropost IN (1,2) ORDER BY maxnumrep DESC LIMIT 0, 1; SELECT FOUND_ROWS(); drop table t1; + +# +# Test problem with impossible WHERE (Bug #1468) +# + +create table t1 (id int, primary key (id)); +insert into t1 values (1), (2), (3), (4), (5); +select SQL_CALC_FOUND_ROWS * from t1 where id > 3 limit 0, 1; +select FOUND_ROWS(); +select SQL_CALC_FOUND_ROWS * from t1 where id > 3 AND 1=2 limit 0, 1; +select FOUND_ROWS(); +select SQL_CALC_FOUND_ROWS * from t1 where id > 6 limit 0, 1; +select FOUND_ROWS(); +drop table t1; |