SanjayUG opened a new pull request, #15307:
URL: https://github.com/apache/datafusion/pull/15307
# Add Subquery Support for BETWEEN Expressions
## Which issue does this PR close?
- Closes #5483.
## Rationale for this change
This change adds support for scalar subqueries in BETWEEN lower and upper
bounds, enhancing the flexibility of query expressions. By enabling subqueries
within BETWEEN expressions, we provide users with more powerful and expressive
query capabilities.
## What changes are included in this PR?
- **feat:** Add subquery support for BETWEEN expressions
- Add support for scalar subqueries in BETWEEN lower and upper bounds
- Add `new_with_subqueries` method to validate subquery expressions
- Update SQL and physical planners to handle subqueries
- Add documentation with examples and usage patterns
## Are these changes tested?
Yes, the changes are tested to ensure that subqueries in BETWEEN expressions
are correctly validated and executed. Tests cover various use cases and edge
cases to verify the robustness of the implementation.
## Are there any user-facing changes?
Yes, users will now be able to use scalar subqueries within BETWEEN
expressions in their SQL queries. Documentation has been updated to include
examples and usage patterns for this new feature.
## Are there any breaking changes to public APIs?
No, there are no breaking changes to public APIs.
--
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: github-unsubscr...@datafusion.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org
