[
https://issues.apache.org/jira/browse/TRAFODION-3109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16519360#comment-16519360
]
Anoop Sharma commented on TRAFODION-3109:
-----------------------------------------
Lei,
this change has caused traf compGeneral test072 to fail due to some single
quote comment issue.
Also caused core files. See link below.
https://jenkins.esgyn.com/job/Check-Daily-master-rh6/480/
Were compGeneral tests run on dev environment? Did it fail there?
Could you look into this?
thanks.
anoop
> 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)
