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

Sergey Soldatov commented on PHOENIX-2780:
------------------------------------------

It's an expected behavior since most of RDBMS doesn't support special 
characters in the column names.  

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

Reply via email to