Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
1.4.1
-
None
-
2020-2
Description
working_ssb_compareLogOnly/sub/order_limit_sub, the second query gives the wrong answer:
select * from
(select lo_orderkey, count
from lineorder where lo_orderkey in
(select *
from (select lo_orderkey
from lineorder
join dateinfo
on lo_orderdate = d_datekey
where lo_orderkey <= 900
group by lo_orderkey
order by sum(lo_ordtotalprice), lo_orderkey desc
limit 5
) alias1
)
group by lo_orderkey
order by 1, 2 asc
limit 4
) alias2
order by 2, 1 desc;
---------------------+
lo_orderkey | count |
---------------------+
4 | 1 |
2 | 1 |
3 | 6 |
1 | 6 |
---------------------+
In 1.2 we get the correct answer:
---------------------+
lo_orderkey | count |
---------------------+
421 | 1 |
389 | 1 |
228 | 1 |
162 | 1 |
---------------------+
I ran the interior queries separately and got correct answers. It doesn't seem to break until the final wrapper.
Attachments
Issue Links
- includes
-
MCOL-3762 HEX(<decimal>) gets truncated
- Stalled
- is part of
-
MCOL-3594 Failed tests in the 001 suite in 1.4
- Closed
- relates to
-
MCOL-3664 Subquery wrapping affects performance
- Closed
-
MCOL-3828 UNION: complains about table not in query
- Closed
- split to
-
MCOL-3780 Clone of MCOL-3747 for release 1.5.0
- Closed