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

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

James Taylor created PHOENIX-1617:
-------------------------------------

             Summary: 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


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)