phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Lomore (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (PHOENIX-3265) Surround columns named date with double quotes
Date Tue, 04 Oct 2016 19:05:20 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-3265?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15546325#comment-15546325
] 

Eric Lomore edited comment on PHOENIX-3265 at 10/4/16 7:04 PM:
---------------------------------------------------------------

An interrelated issue is the following SQL select satement failing:
{{"SELECT k1 FROM t WHERE date >= to_date('2013-01-01')";}}

Caused by: org.apache.phoenix.calcite.parser.ParseException: Encountered "date >="
Was expecting one of...
.
.
    "DATE" ...
    "DATE" <QUOTED_STRING> ...



was (Author: lomoree):
An interrelated issue is the following SQL select satement failing:
{{"SELECT k1 FROM t WHERE date >= to_date('2013-01-01')";}}

Recognition of "data >=" is failing.


> Surround columns named date with double quotes
> ----------------------------------------------
>
>                 Key: PHOENIX-3265
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3265
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: James Taylor
>            Assignee: Eric Lomore
>
> In Phoenix {{date}} is not a reserved word, but perhaps in Calcite it is? If that's the
case, we should surround occurrences of columns named {{date}} in double quotes to prevent
the parser error.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message