Qilin Chen created TRAFODION-2970:
-------------------------------------
Summary: Comment-On bug : failed to add comment when there is a
single quote in comment string
Key: TRAFODION-2970
URL: https://issues.apache.org/jira/browse/TRAFODION-2970
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Affects Versions: 2.3
Reporter: Qilin Chen
Assignee: Qilin Chen
SQL>comment on table json_test is 'table''s comment for ansi json support test';
*** ERROR[15005] Unmatched quote in input (unterminated string):
insert into TRAFODION."_MD_".TEXT values (1802720017000399316, 3, 0, 0, 0,
'table's comment for ansi json support test') ; [2018-02-26 18:02:46]
So quotes in string 'table''s comment for ansi json support test' is escaped
twice, because we have a Insert statement within Comment-On statement.
And statement below works fine:
SQL>comment on table json_test is 'table''''s comment for ansi json support
test';
--- SQL operation complete.
SQL>showddl json_test;
CREATE TABLE TRAFODION.JSON.JSON_TEST
(
K INT DEFAULT NULL NOT SERIALIZED
, J VARCHAR(200) CHARACTER SET ISO88591
COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED
)
ATTRIBUTES ALIGNED FORMAT
;
COMMENT ON TABLE TRAFODION.JSON.JSON_TEST IS 'table's comment for ansi json
support test' ;
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
