[
https://issues.apache.org/jira/browse/CALCITE-7240?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7240:
------------------------------------
Labels: pull-request-available (was: )
> Handle SEARCH in DateRangeRules
> -------------------------------
>
> Key: CALCITE-7240
> URL: https://issues.apache.org/jira/browse/CALCITE-7240
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.40.0
> Reporter: Stamatis Zampetakis
> Assignee: Stamatis Zampetakis
> Priority: Major
> Labels: pull-request-available
>
> The
> [DateRangeRules|https://github.com/apache/calcite/blob/b6b3a068f5a524a18db7523a9a6db0a325fb390d/core/src/main/java/org/apache/calcite/rel/rules/DateRangeRules.java]
> convert various expressions with EXTRACT, CEIL, and FLOOR functions over
> DATE/TIMESTAMP columns to equivalent ones that don't use the function. The
> rules can handle various comparison operators with conjunctions and
> disjunctions but they cannot handle SEARCH.
> The SEARCH operator is created in many places so the rules should be enhanced
> to work with it. SQL examples where SEARCH is introduced via the use of
> BETWEEN:
> {code:sql}
> CEIL(ts to YEAR) BETWEEN TIMESTAMP '2010-02-10 11:12:05' AND TIMESTAMP
> '2015-10-12 10:12:05'
> FLOOR(ts to YEAR) BETWEEN TIMESTAMP '2010-02-10 11:12:05' AND TIMESTAMP
> '2015-10-12 10:12:05'
> EXTRACT(d TO YEAR) BETWEEN 2010 and 2015
> {code}
> The respective SEARCH expressions shown below cannot be handled currently by
> the rules:
> {noformat}
> SEARCH(CEIL($9, FLAG(YEAR)), Sarg[[2010-02-10 11:12:05..2015-10-12 10:12:05]])
> SEARCH(FLOOR($9, FLAG(YEAR)), Sarg[[2010-02-10 11:12:05..2015-10-12
> 10:12:05]])
> SEARCH(EXTRACT(FLAG(YEAR), $9), Sarg[[2010..2015]]){noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
