Kontinuation commented on code in PR #91:
URL: https://github.com/apache/sedona-db/pull/91#discussion_r2354248571
##########
rust/sedona-spatial-join/src/exec.rs:
##########
@@ -1028,6 +1028,16 @@ mod tests {
Ok(())
}
+ #[tokio::test]
+ async fn test_query_window_in_subquery() -> Result<()> {
+ let ((left_schema, left_partitions), (right_schema, right_partitions))
=
+ create_test_data_with_size_range((50.0, 60.0), WKB_GEOMETRY)?;
+ let options = SpatialJoinOptions::default();
+ test_spatial_join_query(&left_schema, &right_schema,
left_partitions.clone(), right_partitions.clone(), &options, 10,
+ "SELECT id FROM L WHERE ST_Intersects(L.geometry, (SELECT
R.geometry FROM R WHERE R.id = 1))").await?;
Review Comment:
I have added another test with `ST_DWithin(L.geometry, ST_Point(10, 10),
(SELECT R.dist FROM sjoin_subquery AS R WHERE R.id = 1))` as filter containing
subquery, this cannot be transformed to a spatial join, but the filter could
still be merged into the NestedLoopJoinExec operator and produces identical
query results.
--
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]
