Jark Wu created CALCITE-2150:
--------------------------------
Summary: CurrentTimestamp is reduced in subquery
Key: CALCITE-2150
URL: https://issues.apache.org/jira/browse/CALCITE-2150
Project: Calcite
Issue Type: Bug
Reporter: Jark Wu
Assignee: Julian Hyde
I add two unit test with ReduceExpressionsRule.PROJECT_INSTANCE reduce rule in
the commit:
[https://github.com/wuchong/calcite/commit/e76c3ad3cc3ddc5c0bb0c3e385a71296329a7cb5]
The first is "{{select sal, current_timestamp as t from emp" and the
current_timestamp is not reduced as expected.}}
{{But the second query "select sal, sal + 5, t from (select sal,
current_timestamp as t from emp)" the optimized plan is as following:}}
{{// code placeholder}}
{{LogicalProject(SAL=[$0], EXPR$1=[+($0, 5)], T=[2011-07-20 00:00:00])
LogicalProject(SAL=[$5], T=[CURRENT_TIMESTAMP])
LogicalTableScan(table=[[CATALOG, SALES, EMP]])}}{{}}
{{The current_timestamp in the outer Project is reduced as a constant:
2011-07-20 00:00:00 which maybe a bug I think.}}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
