http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/59e2f051/core/sql/regress/compGeneral/EXPECTED072 ---------------------------------------------------------------------- diff --git a/core/sql/regress/compGeneral/EXPECTED072 b/core/sql/regress/compGeneral/EXPECTED072 new file mode 100644 index 0000000..14a4357 --- /dev/null +++ b/core/sql/regress/compGeneral/EXPECTED072 @@ -0,0 +1,1154 @@ +>> +>>obey TEST072(clnup); +>>-------------------------------------------------------------------------- +>> +>>-- CLEANUP database +>>drop schema IF EXISTS t072sch_comment cascade; + +--- SQL operation complete. +>> +>>obey TEST072(compile_libs); +>>-------------------------------------------------------------------------- +>>log; +------------------------------------------------------------------------------ +-- Compiling Java source files: TEST072.java +-- Executing: $javac -d $REGRRUNDIR $REGRTSTDIR/TEST072.java +-- $javac returned 0 +------------------------------------------------------------------------------ +------------------------------------------------------------------------------ +-- Archiving Java class files: +-- TEST072.class +-- Archive will be written to: TEST072.jar +-- Executing: $jar cMf TEST072.jar TEST072.class +-- $jar returned 0 +------------------------------------------------------------------------------ +>> +>> +>>obey TEST072(ddl); +>>-------------------------------------------------------------------------- +>> +>>create schema t072sch_comment; + +--- SQL operation complete. +>> +>>create table t072sch_comment.t072t1 ( col1 int not null, col2 DECIMAL(10, 4) not null, col3 VARCHAR(50) not null, primary key (col1) ); + +--- SQL operation complete. +>> +>>create index t072idx1 on t072sch_comment.t072t1 (col1, col3); + +--- SQL operation complete. +>> +>>create view t072sch_comment.t072view1 as select * from t072sch_comment.t072t1; + +--- SQL operation complete. +>> +>>create library t072sch_comment.t072ddl file $$QUOTE$$ $$REGRRUNDIR$$/$$DLL$$ $$QUOTE$$; + +--- SQL operation complete. +>> +>>create library t072sch_comment.t072jar file $$QUOTE$$ $$REGRRUNDIR$$/$$SPJJAR$$ $$QUOTE$$; + +--- SQL operation complete. +>> +>> +>>create function t072sch_comment.t072func(int,int) returns (add2 int) ++> external name 'add2' library t072sch_comment.t072ddl ++> deterministic no sql no transaction required ++>; + +--- SQL operation complete. +>> +>>create procedure t072sch_comment.t072spj() ++> external name 'TEST072.testMoreResultSet' ++> library t072sch_comment.t072jar ++> language java ++> DYNAMIC RESULT SETS 5 ++> READS SQL DATA ++>; + +--- SQL operation complete. +>> +>>CREATE SEQUENCE t072sch_comment.t072seq ++> START WITH 1 ++> INCREMENT BY 1 ++> MAXVALUE 10000 ++> NO CYCLE ++> CACHE 20 ++> --UNSIGNED INTEGER ++>; + +--- SQL operation complete. +>> +>> +>> +>>obey TEST072(comment01); +>>-------------------------------------------------------------------------- +>> +>>--CREATE COMMENTS +>>comment on schema t072sch_comment is 'This is a new comment of SCHEMA.è¿æ¯ä¸ä¸ªschemaç注éã' ; + +--- SQL operation complete. +>>comment on table t072sch_comment.t072t1 is 'This is a new comment of TABLE.è¿ä¸ªæ¯ä¸ä¸ªä¸æçtableç注éããããâ¦â¦' ; + +--- SQL operation complete. +>>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.' ; + +--- SQL operation complete. +>>comment on library TRAFODION.t072sch_comment.t072ddl is 'This is a new comment of C UDF library.' ; + +--- SQL operation complete. +>>comment on library t072sch_comment.t072jar is 'This is a new comment of Java SPJ library.' ; + +--- SQL operation complete. +>>comment on function t072sch_comment.t072func is 'This is a new comment of SCALAR UDF.' ; + +--- SQL operation complete. +>>comment on procedure t072sch_comment.t072spj is 'This is a new comment of SPJ.' ; + +--- SQL operation complete. +>>comment on sequence t072sch_comment.t072seq is 'This is a new comment of SEQUENCE.' ; + +--- SQL operation complete. +>> +>>comment on column t072sch_comment.t072t1.col1 is 'This is a T01 column new comment of table.' ; + +--- SQL operation complete. +>>comment on column t072sch_comment.t072t1.col2 is 'This is a T02 column new comment of table.' ; + +--- SQL operation complete. +>>comment on column t072sch_comment.t072t1.col3 is 'This is a T03 column new comment of table.' ; + +--- SQL operation complete. +>>comment on column t072sch_comment.t072view1.col1 is 'This is a V01 column new comment of view.' ; + +--- SQL operation complete. +>>comment on column t072sch_comment.t072view1.col2 is 'This is a V02 column new comment of view.' ; + +--- SQL operation complete. +>>comment on column t072sch_comment.t072view1.col3 is 'This is a V03 column new comment of view.大家好ã' ; + +--- SQL operation complete. +>> +>> +>>obey TEST072(showcomment); +>>-------------------------------------------------------------------------- +>> +>>select * from "_MD_".OBJECT_COMMENT_VIEW where schema_name = UPPER('t072sch_comment'); + +CATALOG_NAME SCHEMA_NAME OBJECT_NAME COMMENT +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ + +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 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.
<TRUNCATED>
