[
https://issues.apache.org/jira/browse/TRAFODION-3109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16517510#comment-16517510
]
ASF GitHub Bot commented on TRAFODION-3109:
-------------------------------------------
Github user asfgit closed the pull request at:
https://github.com/apache/trafodion/pull/1610
> comment can not transfer single quote normally in comment string
> ----------------------------------------------------------------
>
> Key: TRAFODION-3109
> URL: https://issues.apache.org/jira/browse/TRAFODION-3109
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Affects Versions: any
> Reporter: zhang.lei
> Assignee: zhang.lei
> Priority: Major
>
> | |When comment use a quote in the string, we need to use single quote to
> transfer the quote. But now it would transfer twice, like this.
>
> SQL>comment on table test_1 is 'this is Lily''s comment';
>
> *** ERROR[15005] Unmatched quote in input (unterminated string):
> insert into TRAFODION."_MD_".TEXT values (3198837518524697516, 3, 0, 0, 0,
> 'this is Lily's comment') ; [2018-03-18 12:59:21]
>
>
> SQL>comment on table test_1 is 'this is Lily''''s comment';
>
> --- SQL operation complete.
>
> SQL>showddl test_1;
>
>
> CREATE TABLE TRAFODION.TEST_COMMENT.TEST_1
> (
> A INT DEFAULT NULL NOT SERIALIZED
> )
> ATTRIBUTES ALIGNED FORMAT
> ;
>
> COMMENT ON TABLE TRAFODION.TEST_COMMENT.TEST_1 IS 'this is Lily's comment' ;
>
> --- SQL operation complete.|
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
