You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@phoenix.apache.org by "Ranganath Govardhanagiri (Jira)" <ji...@apache.org> on 2024/07/03 16:57:00 UTC

[jira] [Commented] (PHOENIX-7215) Support explicit types for all literals

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