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