jackwener commented on code in PR #4232:
URL: https://github.com/apache/arrow-datafusion/pull/4232#discussion_r1023529656
##########
datafusion/core/tests/sql/subqueries.rs:
##########
@@ -56,13 +56,15 @@ where c_acctbal < (
Inner Join: customer.c_custkey = __sq_2.o_custkey
TableScan: customer projection=[c_custkey, c_acctbal]
Projection: orders.o_custkey, SUM(orders.o_totalprice) AS __value,
alias=__sq_2
- Aggregate: groupBy=[[orders.o_custkey]],
aggr=[[SUM(orders.o_totalprice)]]
- Filter: CAST(orders.o_totalprice AS Decimal128(25, 2)) <
__sq_1.__value
- Inner Join: orders.o_orderkey = __sq_1.l_orderkey
- TableScan: orders projection=[o_orderkey, o_custkey,
o_totalprice]
- Projection: lineitem.l_orderkey, SUM(lineitem.l_extendedprice)
AS price AS __value, alias=__sq_1
- Aggregate: groupBy=[[lineitem.l_orderkey]],
aggr=[[SUM(lineitem.l_extendedprice)]]
- TableScan: lineitem projection=[l_orderkey,
l_extendedprice]"#
+ Projection: orders.o_custkey
+ Aggregate: groupBy=[[orders.o_custkey]],
aggr=[[SUM(orders.o_totalprice)]]
+ Filter: CAST(orders.o_totalprice AS Decimal128(25, 2)) <
__sq_1.__value
+ Inner Join: orders.o_orderkey = __sq_1.l_orderkey
+ TableScan: orders projection=[o_orderkey, o_custkey,
o_totalprice]
+ Projection: lineitem.l_orderkey,
SUM(lineitem.l_extendedprice) AS price AS __value, alias=__sq_1
+ Projection: lineitem.l_orderkey
Review Comment:
Problems like this indicate `pushdown` rule exist some bug.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
