[
https://issues.apache.org/jira/browse/PHOENIX-2780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15205808#comment-15205808
]
Powpow Shen commented on PHOENIX-2780:
--------------------------------------
For postgreSQL, creating static fields with \" is not allowed, but for dynamic
column (field in json column) is allowed.
> 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)
