Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
2.3
-
None
-
None
Description
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]
- ERROR[15005] Unmatched quote in input (unterminated string):
-
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.
Attachments
Issue Links
- links to