[
https://issues.apache.org/jira/browse/CALCITE-7762?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18112524#comment-18112524
]
Darpan Lunagariya (e6data) commented on CALCITE-7762:
-----------------------------------------------------
Thanks [~julianhyde] for a quick go-through. I have updated the description.
Will open a PR in next few days.
> DateRangeRules may produce incorrect ranges, hang, or excessively expand
> sub-day predicates
> -------------------------------------------------------------------------------------------
>
> Key: CALCITE-7762
> URL: https://issues.apache.org/jira/browse/CALCITE-7762
> Project: Calcite
> Issue Type: Bug
> Reporter: Darpan Lunagariya (e6data)
> Assignee: Darpan Lunagariya (e6data)
> Priority: Major
>
> h2. Problems:
> * {{FLOOR}} and {{CEIL}} can produce incorrect boundaries for afternoon
> timestamp literals.
> * Rewriting a bounded {{EXTRACT(HOUR)}} predicate can enter an infinite loop.
> * Rewriting lower time units can generate an excessive number of ranges.
> h2. Queries that can reproduce above problems (in above order)
> {code:sql}
> SELECT FLOOR(hiredate TO DAY) AS d
> FROM sales.emp_b
> WHERE FLOOR(hiredate TO DAY)
> < TIMESTAMP '2010-02-04 13:00:00';
> {code}
> {code:sql}
> SELECT EXTRACT(HOUR FROM hiredate) AS h
> FROM sales.emp_b
> WHERE EXTRACT(YEAR FROM hiredate) = 2010
> AND EXTRACT(HOUR FROM hiredate) = 13;
> {code}
> {code:sql}
> SELECT EXTRACT(SECOND FROM hiredate) AS s
> FROM sales.emp_b
> WHERE EXTRACT(YEAR FROM hiredate) = 2010
> AND EXTRACT(SECOND FROM hiredate) = 15;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
