Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
None
Description
 |
select
|
sum(l_extendedprice) / 7.0 as avg_yearly |
from
|
lineitem,
|
part
|
where
|
p_partkey = l_partkey
|
and p_brand = 'Brand#32' |
and p_container = 'LG PKG' |
and l_quantity < ( |
select |
0.2 * avg(l_quantity) |
from |
lineitem
|
where |
l_partkey = p_partkey
|
);
|
Error:
IDB-3012: Scalar filter and semi join are not from the same pair of tables.
Attachments
Issue Links
- is blocked by
-
MCOL-5195 Correlated subquery for equi/non-equi scalar filter and join condition (TPC-H q2, q17)
- Closed