[
https://issues.apache.org/jira/browse/TRAFODION-3109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16513601#comment-16513601
]
ASF GitHub Bot commented on TRAFODION-3109:
-------------------------------------------
GitHub user zlei929 opened a pull request:
https://github.com/apache/trafodion/pull/1610
[TRAFODION-3109] comment can not transfer single quote normally in co…
When comment use a quote in the string, we need to use single quote to
transfer the quote.
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/1610.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 #1610
----
commit ffb9416dba18beceeae2ff40cc09e63d052395b7
Author: zlei929 <z_lei929@...>
Date: 2018-06-15T09:30:56Z
[TRAFODION-3109] comment can not transfer single quote normally in comment
string
----
> 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)
