You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2018/03/26 16:03:40 UTC
[3/5] trafodion git commit: COMMENT-ON Bug fix : add escape quote
regression test
http://git-wip-us.apache.org/repos/asf/trafodion/blob/71cfab86/core/sql/regress/compGeneral/EXPECTED072
----------------------------------------------------------------------
diff --git a/core/sql/regress/compGeneral/EXPECTED072 b/core/sql/regress/compGeneral/EXPECTED072
index 14a4357..9a0fb32 100644
--- a/core/sql/regress/compGeneral/EXPECTED072
+++ b/core/sql/regress/compGeneral/EXPECTED072
@@ -95,7 +95,7 @@
>>comment on index TRAFODION.t072sch_comment.t072idx1 is 'This is a new comment of INDEX.' ;
--- SQL operation complete.
->>comment on view TRAFODION.t072sch_comment.t072view1 is 'This is a new comment of VIEW.' ;
+>>comment on view TRAFODION.t072sch_comment.t072view1 is 'This is VIEW''s comment.' ;
--- SQL operation complete.
>>comment on library TRAFODION.t072sch_comment.t072ddl is 'This is a new comment of C UDF library.' ;
@@ -145,7 +145,7 @@ CATALOG_NAME
TRAFODION T072SCH_COMMENT __SCHEMA__ This is a new comment of SCHEMA.这是一个schema的注释。
TRAFODION T072SCH_COMMENT T072T1 This is a new comment of TABLE.这个是一个中文的table的注释。》》、……
TRAFODION T072SCH_COMMENT T072IDX1 This is a new comment of INDEX.
-TRAFODION T072SCH_COMMENT T072VIEW1 This is a new comment of VIEW.
+TRAFODION T072SCH_COMMENT T072VIEW1 This is VIEW's comment.
TRAFODION T072SCH_COMMENT T072DDL This is a new comment of C UDF library.
TRAFODION T072SCH_COMMENT T072JAR This is a new comment of Java SPJ library.
TRAFODION T072SCH_COMMENT T072FUNC This is a new comment of SCALAR UDF.
@@ -226,7 +226,7 @@ CREATE VIEW TRAFODION.T072SCH_COMMENT.T072VIEW1 AS
TRAFODION.T072SCH_COMMENT.T072T1 ;
COMMENT ON VIEW TRAFODION.T072SCH_COMMENT.T072VIEW1 IS
- 'This is a new comment of VIEW.' ;
+ 'This is VIEW''s comment.' ;
COMMENT ON COLUMN TRAFODION.T072SCH_COMMENT.T072VIEW1.COL1 IS
'This is a V01 column new comment of view.' ;
@@ -381,6 +381,9 @@ COMMENT ON SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ IS
>>comment on column t072sch_comment.t072t1.col3 is 'This is a Modified time 05: This is a T03 column comment of table.' ;
--- SQL operation complete.
+>>comment on column TRAFODION.t072sch_comment.t072t1.col2 is '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ;
+
+--- SQL operation complete.
>>
>>comment on column t072sch_comment.t072view1.col1 is 'This is a Modified comment: This is a V01 column comment of view.' ;
@@ -388,7 +391,7 @@ COMMENT ON SEQUENCE TRAFODION.T072SCH_COMMENT.T072SEQ IS
>>comment on column t072sch_comment.t072view1.col2 is 'This is a Modified comment: This is a V02 column comment of view.' ;
--- SQL operation complete.
->>comment on column t072sch_comment.t072view1.col3 is 'This is a Modified big comment: nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnu
llnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnul' ;
+>>comment on column t072sch_comment.t072view1.col3 is 'This is a Modified big comment: ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
<TRUNCATED>