phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-1617) Date literals and CURRENT_DATE() calls do not work in VIEW definition
Date Sat, 31 Jan 2015 19:49:34 GMT
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)

Mime
View raw message