[jira] [Assigned] (PHOENIX-1617) Date literals and CURRENT_DATE() calls do not work in VIEW definition

["James Taylor (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-1617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor reassigned PHOENIX-1617:
-------------------------------------

    Assignee: James Taylor

> 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)