[jira] [Updated] (CALCITE-7240) Handle SEARCH in DateRangeRules

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ 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)