[
https://issues.apache.org/jira/browse/PHOENIX-7215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17862852#comment-17862852
]
Ranganath Govardhanagiri commented on PHOENIX-7215:
---------------------------------------------------
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.
If its acceptable to make the string literal work, I will raise a PR
> 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
> 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)
