[
https://issues.apache.org/jira/browse/TRAFODION-3109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16519916#comment-16519916
]
ASF GitHub Bot commented on TRAFODION-3109:
-------------------------------------------
GitHub user zlei929 opened a pull request:
https://github.com/apache/trafodion/pull/1618
[TRAFODION-3109] undo this change, beacause this issue has been fixed…
Undo this change, because this issue has already been fixed on Trafoidon.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zlei929/trafodion TRAFODION-3109
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1618.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1618
----
commit 0c5ee97051200f609bb40e90e4d477b19fb1ad86
Author: zlei929 <z_lei929@...>
Date: 2018-06-22T02:22:55Z
[TRAFODION-3109] undo this change, beacause this issue has been fixed on
Trafoidon.
----
> 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)
