Skip to content

Commit e07285a

Browse files
committed
test: add join-side volatile extraction regression
1 parent 52d2a85 commit e07285a

1 file changed

Lines changed: 11 additions & 0 deletions

File tree

‎datafusion/sqllogictest/test_files/projection_pushdown.slt‎

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -2199,6 +2199,17 @@ FROM (
21992199
----
22002200
true
22012201

2202+
# Same invariant when the extraction is routed into one side of a join.
2203+
query B
2204+
SELECT bool_and(field = s['a'])
2205+
FROM (
2206+
SELECT l.s, l.s['a'] AS field
2207+
FROM (SELECT named_struct('a', random()) AS s FROM generate_series(1, 1000)) AS l
2208+
INNER JOIN (SELECT 1 AS k) AS r ON true
2209+
);
2210+
----
2211+
true
2212+
22022213
# Every surviving row satisfies the predicate it was filtered on.
22032214
query B
22042215
SELECT bool_and(s['a'] > 0.5)

0 commit comments

Comments
 (0)