Yu Xu created CALCITE-7304:
------------------------------
Summary: 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
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)
