[
https://issues.apache.org/jira/browse/PHOENIX-2780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Powpow Shen updated PHOENIX-2780:
---------------------------------
Description:
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.
was:
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:
{qoute}
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.
> 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)
