[ 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:34 PM: --------------------------------------------------------------------------- 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? 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. 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 > 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)