phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2780) Escape double quotation in dynamic field names
Date Mon, 21 Mar 2016 21:50:25 GMT

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

James Taylor commented on PHOENIX-2780:
---------------------------------------

I think it's a bug as sometimes column names are generated. Would be good to know how other
databases handle this.

> Escape double quotation in dynamic field names
> ----------------------------------------------
>
>                 Key: PHOENIX-2780
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2780
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Powpow Shen
>
> UPSERT a row into a table with \' (escaped single quotation) in value is allowed, but
a row with \" (escaped double quotation) in field name is not allowed. ex:
> {quote}
> upsert into "test"("id", "static", "dynamic" varchar) values (0, 's', 'd\'');
> {quote}
> is OK
> {quote}
> upsert into "test"("id", "static", "dynamic\"" varchar) values (0, 's', 'd');
> {quote}
> is NOT allowed.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message