[
https://issues.apache.org/jira/browse/TRAFODION-2970?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16414048#comment-16414048
]
ASF GitHub Bot commented on TRAFODION-2970:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/trafodion/pull/1495
> 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
> Priority: Minor
>
> 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)
