[
https://issues.apache.org/jira/browse/PHOENIX-7215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17862852#comment-17862852
]
Ranganath Govardhanagiri edited comment on PHOENIX-7215 at 7/3/24 5:35 PM:
---------------------------------------------------------------------------
I was able to make this statement work - _select INTEGER '1000'_ but not
_select INTEGER 1000._
As per the current grammar executing _select INTEGER 1000_ throws an exception
which is basically failing in the parser itself.
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax
error. Encountered "1000" at line 1, column 16.
I see SELECT INTEGER 1000 is more intuitive than SELECT INTEGER '1000', to
support this we need to update grammar?
was (Author: ranganathg):
I was able to make this statement work - _select INTEGER '1000'_ but not
_select INTEGER 1000._
As per the current grammar support the second one is not supported I see an
exception
org.apache.phoenix.exception.PhoenixParserException: ERROR 601 (42P00): Syntax
error. Encountered "1000" at line 1, column 16.
I see SELECT INTEGER 1000 is more intuitive than SELECT INTEGER '1000', to
support this we need to update grammar?
> Support explicit types for all literals
> ---------------------------------------
>
> Key: PHOENIX-7215
> URL: https://issues.apache.org/jira/browse/PHOENIX-7215
> Project: Phoenix
> Issue Type: Improvement
> Reporter: Istvan Toth
> Assignee: Ranganath Govardhanagiri
> Priority: Minor
>
> Phoenix accepts the standard literal types for date/time types.
> _select TIMESTAMP '2000-01-01';_ works.
> However, according to the standard
> _select INTEGER 1000;_ and _select INTEGER '1000';_ should also work, but it
> doesn't.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
