Re: How to use quotation marks in STRING_LITERAL

[Xiangdong Huang]

Hi Lanyu,

PLS PAY ATTENTION that your email format is incorrect. (Notice that
the apache mailing list only supports plain text format).
It is impossible to understand what you want to claim.

---
Xiangdong Huang
School of Software, Tsinghua University

廖兰宇 <181250...@smail.nju.edu.cn> 于2022年9月15日周四 10:21写道：
>
> Hi everybody,
>
> In 0.13/0.14, to use quotation marks in STRING_LITERAL, we support preceding 
> the quote character by an escape character. However, recently we found that 
> this could cause a problem described in issue: 
> https://issues.apache.org/jira/browse/IOTDB-4236. We refer to the grammar of 
> presto/trino/sqlite and we think that it is better that we do not support 
> preceding the quote character by an escape character in STRING_LITERAL. If 
> you want to use quotation marks in STRING_LITERAL:
>
>
>
> A'inside a string quoted with'may be written 
> as''.
>
> A"inside a string quoted with"may be written 
> as"".
>
> Any comments would be much appreciated.
>
> Best,
>
> 
>
> Lanyu Liao
>
> School of Software, Tsinghua University
>
> 廖兰宇
>
> 清华大学 软件学院

How to use quotation marks in STRING_LITERAL

[廖兰宇]

Hi everybody, 

In 0.13/0.14, to use quotation marks in STRING_LITERAL, we support preceding 
the quote character by an escape character. However, recently we found that 
this could cause a problem described in issue: 
https://issues.apache.org/jira/browse/IOTDB-4236. We refer to the grammar of 
presto/trino/sqlite and we think that it is better that we do not support 
preceding the quote character by an escape character in STRING_LITERAL. If you 
want to use quotation marks in STRING_LITERAL:



A'inside a string quoted with'may be written as''.

A"inside a string quoted with"may be written as"".

Any comments would be much appreciated.

Best,



Lanyu Liao

School of Software, Tsinghua University

廖兰宇

清华大学 软件学院