[
https://issues.apache.org/jira/browse/PHOENIX-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-1617.
-----------------------------------
Resolution: Duplicate
Duplicate of PHOENIX-1646
> Date literals and CURRENT_DATE() calls do not work in VIEW definition
> ---------------------------------------------------------------------
>
> Key: PHOENIX-1617
> URL: https://issues.apache.org/jira/browse/PHOENIX-1617
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Assignee: James Taylor
>
> The following will not work correct:
> {code}
> CREATE TABLE t (k INTEGER, v1 DATE);
> CREATE VIEW v AS
> SELECT * FROM t WHERE v1 < CURRENT_DATE()-1;
> {code}
> There are two issues: date literals do not round trip correctly from
> ParseNode -> Expression -> String. We need to output them as TO_DATE(<date as
> string>). Until we have a way to represent TIME and TIMESTAMP(PHOENIX-688 or
> PHOENIX-653), we're stuck.
> The CURRENT_DATE built-in has a similar issue. We end up turning it into a
> date literal, but instead we should have a CurrentDateExpression that
> evaluates to a literal, but which let's us roundtrip the ParseNode from an
> Expression to a String correctly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
