Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
create table t1 (a int);
insert into t1 values (10),(10),(10),(2),(3),(4),(5),(6),(7),(8),(9),(1),(10);
select a from t1 where false UNION select a from t1 limit 8;
->
------
| a |
------
| 10 |
| 2 |
| 3 |
| 4 |
| 5 |
| 6 |
------
6 rows in set
Which is wrong as there should be 8 rows in the result
This only happens with union distinct without order by.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 732124
Re: union + limit returns wrong result
Fix pushed into 5.1 trunk