Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
any
-
None
-
None
Description
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]
- ERROR[15005] Unmatched quote in input (unterminated string):
-
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.|