You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/03/11 23:01:43 UTC

[jira] [Commented] (PHOENIX-835) Datatype statements in CAST operations are case-sensitive

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

James Taylor commented on PHOENIX-835:
--------------------------------------

Any objection to going through our standard SchemaUtil.normalizeIdentifier(String) instead of doing a toUpperCase() directly?

> Datatype statements in CAST operations are case-sensitive
> ---------------------------------------------------------
>
>                 Key: PHOENIX-835
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-835
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Gabriel Reid
>         Attachments: PHOENIX-835.patch
>
>
> The datatype clause in cast exceptions are case sensitive, although they’re not case sensitive in a create table statement. For example, 
> {code}
> select (cast id as INTEGER) from mytab;
> {code}
> will work, but
> {code}
> select (cast id as integer) from mytab;
> {code}
> gives a parse error.



--
This message was sent by Atlassian JIRA
(v6.2#6252)