zhang.lei created TRAFODION-3109:
------------------------------------
Summary: 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
| |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)
