[
https://issues.apache.org/jira/browse/PHOENIX-2780?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15206847#comment-15206847
]
Sergey Soldatov commented on PHOENIX-2780:
------------------------------------------
All DBs are dealing with it in their own way. For SQL Server the brackets
should be used if the identifier has special symbols. MySQL is using backticks
for the same. If we want to support it we need to define how we will do it
first.
> 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)
