[jira] [Created] (TRAFODION-2970) Comment-On bug : failed to add comment when there is a single quote in comment string

["Qilin Chen (JIRA)" <ji...@apache.org>]

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)