diff options
Diffstat (limited to 'mysql-test/t/union.test')
| -rw-r--r-- | mysql-test/t/union.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/union.test b/mysql-test/t/union.test index c6599517e90..db7f8397c7b 100644 --- a/mysql-test/t/union.test +++ b/mysql-test/t/union.test @@ -1115,6 +1115,14 @@ SELECT * FROM t2 UNION SELECT * FROM t2 DROP TABLE t1,t2; +# +# lp:732124 union + limit returns wrong result +# +create table t1 (a int); +insert into t1 values (10),(10),(10),(2),(3),(4),(5),(6),(7),(8),(9),(1),(10); +--sorted_result +select a from t1 where false UNION select a from t1 limit 8; +drop table t1; --echo End of 5.1 tests |