[
https://issues.apache.org/jira/browse/CALCITE-7304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7304:
------------------------------------
Labels: pull-request-available (was: )
> Floor/Ceil can not simplify with WEEK TimeUnit
> ----------------------------------------------
>
> Key: CALCITE-7304
> URL: https://issues.apache.org/jira/browse/CALCITE-7304
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.41.0
> Reporter: Yu Xu
> Assignee: Yu Xu
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.42.0
>
>
> Since https://issues.apache.org/jira/browse/CALCITE-2178, Floor function
> would be simplify as:
> origin sql:
> {code:java}
> SELECT floor(floor(\"hire_date\" TO DAY) TO MONTH) FROM \"employee\" {code}
> would simplify to:
> {code:java}
> SELECT FLOOR(\"hire_date\" TO MONTH)\nFROM \"foodmart\".\"employee\" {code}
> but WEEK timeunit can not work well:
> origin sql:
> {code:java}
> SELECT floor(floor(\"hire_date\" TO DAY) TO WEEK) FROM \"employee\"{code}
> simplify without changing:
> {code:java}
> SELECT FLOOR((FLOOR(\"hire_date\" TO DAY)) TO WEEK)\nFROM
> \"foodmart\".\"employee\" {code}
> expected simplify as :
> {code:java}
> SELECT FLOOR(\"hire_date\" TO WEEK)\nFROM \"foodmart\".\"employee\" {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
