http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/charsets/EXPECTED313 ---------------------------------------------------------------------- diff --git a/core/sql/regress/charsets/EXPECTED313 b/core/sql/regress/charsets/EXPECTED313 index c9eecb5..521e3bc 100644 --- a/core/sql/regress/charsets/EXPECTED313 +++ b/core/sql/regress/charsets/EXPECTED313 @@ -628,28 +628,28 @@ u1u1 8 --- 4 row(s) selected. >>select * from cs313t3 union (select * from cs313t4) order by 1; -A1 ----------------- +A1 +---------------------------------------------------------------- -a1a1 -u1u1 -��� -??? +a1a1 +u1u1 +��� +??? --- 4 row(s) selected. >>select * from cs313t3 union all (select * from cs313t4) order by 1; -A1 ----------------- +A1 +---------------------------------------------------------------- -a1a1 -a1a1 -u1u1 -u1u1 -��� -��� -??? -??? +a1a1 +a1a1 +u1u1 +u1u1 +��� +��� +??? +??? --- 8 row(s) selected. >>-- @@ -5092,28 +5092,28 @@ def def --- 4 row(s) selected. >>select * from cs313t70 union (select * from cs313t71) order by 1,2; -A1 U1 ----------------- ---------------- +A1 U1 +---------------------------------------------------------------- ---------------------------------------------------------------- -abc abc -def def -��� ��� -??? ??? +abc abc +def def +��� ��� +??? ??? --- 4 row(s) selected. >>select * from cs313t70 union all (select * from cs313t71) order by 1,2; -A1 U1 ----------------- ---------------- +A1 U1 +---------------------------------------------------------------- ---------------------------------------------------------------- -abc abc -abc abc -def def -def def -��� ��� -��� ��� -??? ??? -??? ??? +abc abc +abc abc +def def +def def +��� ��� +��� ��� +??? ??? +??? ??? --- 8 row(s) selected. >>-- @@ -5188,24 +5188,24 @@ def def def def >>-- >>select * from cs313t70 union (select * from cs313t70 union (select * from >>cs313t71)) order by 1,2; -A1 U1 ----------------- ---------------- +A1 U1 +---------------------------------------------------------------- ---------------------------------------------------------------- -abc abc -def def -��� ��� -??? ??? +abc abc +def def +��� ��� +??? ??? --- 4 row(s) selected. >>select * from cs313t70 union (select * from cs313t71 union (select * from >>cs313t70)) order by 1,2; -A1 U1 ----------------- ---------------- +A1 U1 +---------------------------------------------------------------- ---------------------------------------------------------------- -abc abc -def def -��� ��� -??? ??? +abc abc +def def +��� ��� +??? ??? --- 4 row(s) selected. >>-- @@ -5724,7 +5724,10 @@ u1u1 u1u1 >>create TRIGGER TRG1_cs313t90 before UPDATE on cs313t90 REFERENCING NEW >>as TRG FOR EACH ROW +> set TRG.UCS2_col2 = _UTF8'abc' ; ---- SQL operation complete. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. + >>-- >>insert into cs313t90 values('Test1','Test1','Test1','Test1'), >>('test111','test1111','test111','test1111'); @@ -5737,7 +5740,7 @@ u1u1 u1u1 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Test1 abc Test1 Iso1 +Test1 Test1 Test1 Iso1 test111 test1111 test111 test1111 --- 2 row(s) selected. @@ -5750,7 +5753,7 @@ test111 test11 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Test1 abc Test1 Iso1 +Test1 Test1 Test1 Iso1 test111 test1111 test111 test1111 --- 2 row(s) selected. @@ -5766,8 +5769,8 @@ test111 test11 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 test111 test1111 test111 test1111 test222 test2222 test222 test2222 @@ -5781,8 +5784,8 @@ test222 test22 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 test111 test1111 test111 test1111 test222 test2222 test222 test2222 @@ -5799,9 +5802,9 @@ test222 test22 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 +Iso3 Test3 Test3 Test3 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5816,9 +5819,9 @@ test333 test33 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 +Iso3 Test3 Test3 Test3 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5827,11 +5830,17 @@ test333 test33 >>-- >>DROP TRIGGER TRG1_cs313t90; ---- SQL operation complete. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. + >>create TRIGGER TRG1_cs313t90 before UPDATE on cs313t90 REFERENCING NEW >>as TRG FOR EACH ROW +> set TRG.ISO_col2 = _ucs2'abc' ; ---- SQL operation complete. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. + >>-- >>insert into cs313t90 values('Test4','Test4','Test4','Test4'), >>('test444','test4444','test444','test4444'); @@ -5844,10 +5853,10 @@ test333 test33 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 -Test4 Test4 Iso4 abc +Iso3 Test3 Test3 Test3 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 +Test4 Test4 Iso4 Test4 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5863,10 +5872,10 @@ test444 test44 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 -Test4 Test4 Iso4 abc +Iso3 Test3 Test3 Test3 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 +Test4 Test4 Iso4 Test4 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5885,11 +5894,11 @@ test444 test44 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 -Test4 Test4 Iso4 abc -Test5 Test5 UCS5 abc +Iso3 Test3 Test3 Test3 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 +Test4 Test4 Iso4 Test4 +Test5 Test5 UCS5 Test5 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5906,11 +5915,11 @@ test555 test55 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 -Test4 Test4 Iso4 abc -Test5 Test5 UCS5 abc +Iso3 Test3 Test3 Test3 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 +Test4 Test4 Iso4 Test4 +Test5 Test5 UCS5 Test5 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5930,12 +5939,12 @@ test555 test55 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Iso6 Test6 Test6 abc -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 -Test4 Test4 Iso4 abc -Test5 Test5 UCS5 abc +Iso3 Test3 Test3 Test3 +Iso6 Test6 Test6 Test6 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 +Test4 Test4 Iso4 Test4 +Test5 Test5 UCS5 Test5 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5953,12 +5962,12 @@ test666 test66 UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ -Iso3 abc Test3 Test3 -Iso6 Test6 Test6 abc -Test1 abc Test1 Iso1 -Test2 abc Test2 UCS2 -Test4 Test4 Iso4 abc -Test5 Test5 UCS5 abc +Iso3 Test3 Test3 Test3 +Iso6 Test6 Test6 Test6 +Test1 Test1 Test1 Iso1 +Test2 Test2 Test2 UCS2 +Test4 Test4 Iso4 Test4 +Test5 Test5 UCS5 Test5 test111 test1111 test111 test1111 test222 test2222 test222 test2222 test333 test3333 test333 test3333 @@ -5984,7 +5993,10 @@ test666 test66 >>create TRIGGER TRG1_cs313t91 before UPDATE on cs313t91 REFERENCING NEW >>as TRG FOR EACH ROW +> set TRG.UCS2_col2 = _UTF8'abc' ; ---- SQL operation complete. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. + >>-- >>insert into cs313t91 values(1,'Test1','Test1','Test1','Test1'), >>(2,'test111','test1111','test111','test1111'); @@ -5997,7 +6009,7 @@ test666 test66 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 --- 2 row(s) selected. @@ -6010,7 +6022,7 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 --- 2 row(s) selected. @@ -6026,9 +6038,9 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 --- 4 row(s) selected. @@ -6041,9 +6053,9 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 --- 4 row(s) selected. @@ -6059,11 +6071,11 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 --- 6 row(s) selected. @@ -6076,22 +6088,28 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 --- 6 row(s) selected. >>-- >>DROP TRIGGER TRG1_cs313t91; ---- SQL operation complete. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. + >>create TRIGGER TRG1_cs313t91 before UPDATE on cs313t91 REFERENCING NEW >>as TRG FOR EACH ROW +> set TRG.ISO_col2 = _ucs2'abc' ; ---- SQL operation complete. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. + >>-- >>insert into cs313t91 values(7,'Test4','Test4','Test4','Test4'), >>(8,'test444','test4444','test444','test4444'); @@ -6104,13 +6122,13 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 - 7 Test4 Test4 Iso4 abc + 7 Test4 Test4 Iso4 Test4 8 test444 test4444 test444 test4444 --- 8 row(s) selected. @@ -6123,13 +6141,13 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 - 7 Test4 Test4 Iso4 abc + 7 Test4 Test4 Iso4 Test4 8 test444 test4444 test444 test4444 --- 8 row(s) selected. @@ -6145,15 +6163,15 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 - 7 Test4 Test4 Iso4 abc + 7 Test4 Test4 Iso4 Test4 8 test444 test4444 test444 test4444 - 9 Test5 Test5 UCS5 abc + 9 Test5 Test5 UCS5 Test5 10 test555 test5555 test555 test5555 --- 10 row(s) selected. @@ -6166,15 +6184,15 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 - 7 Test4 Test4 Iso4 abc + 7 Test4 Test4 Iso4 Test4 8 test444 test4444 test444 test4444 - 9 Test5 Test5 UCS5 abc + 9 Test5 Test5 UCS5 Test5 10 test555 test5555 test555 test5555 --- 10 row(s) selected. @@ -6190,17 +6208,17 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 - 7 Test4 Test4 Iso4 abc + 7 Test4 Test4 Iso4 Test4 8 test444 test4444 test444 test4444 - 9 Test5 Test5 UCS5 abc + 9 Test5 Test5 UCS5 Test5 10 test555 test5555 test555 test5555 - 11 Iso6 Test6 Test6 abc + 11 Iso6 Test6 Test6 Test6 12 test666 test6666 test666 test6666 --- 12 row(s) selected. @@ -6213,17 +6231,17 @@ PRKY UCS2_COL1 PRKY UCS2_COL1 UCS2_COL2 ISO_COL1 ISO_COL2 ----------- ------------------------------------------------------------------------ ------------------------------------------------------------------------ ------------------------------------ ------------------------------------ - 1 Test1 abc Test1 Iso1 + 1 Test1 Test1 Test1 Iso1 2 test111 test1111 test111 test1111 - 3 Test2 abc Test2 UCS2 + 3 Test2 Test2 Test2 UCS2 4 test222 test2222 test222 test2222 - 5 Iso3 abc Test3 Test3 + 5 Iso3 Test3 Test3 Test3 6 test333 test3333 test333 test3333 - 7 Test4 Test4 Iso4 abc + 7 Test4 Test4 Iso4 Test4 8 test444 test4444 test444 test4444 - 9 Test5 Test5 UCS5 abc + 9 Test5 Test5 UCS5 Test5 10 test555 test5555 test555 test5555 - 11 Iso6 Test6 Test6 abc + 11 Iso6 Test6 Test6 Test6 12 test666 test6666 test666 test6666 --- 12 row(s) selected.
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/compGeneral/DIFF006.KNOWN.SB ---------------------------------------------------------------------- diff --git a/core/sql/regress/compGeneral/DIFF006.KNOWN.SB b/core/sql/regress/compGeneral/DIFF006.KNOWN.SB deleted file mode 100644 index fb4d19d..0000000 --- a/core/sql/regress/compGeneral/DIFF006.KNOWN.SB +++ /dev/null @@ -1,4 +0,0 @@ -96c96 -< *** ERROR[3233] This type of UPDATE is not allowed when NO ROLLBACK transaction setting is in effect. Suggestion: Set ALLOW_RISKY_UPDATE_WITH_NO_ROLLBACK CQD to ON to allow UPDATE command with right-hand side SET clause consisting of columns. ---- -> *** ERROR[3231] WITH NO ROLLBACK clause was used in an INSERT, UPDATE, or DELETE statement when AUTOCOMMIT is OFF. http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/compGeneral/EXPECTED005 ---------------------------------------------------------------------- diff --git a/core/sql/regress/compGeneral/EXPECTED005 b/core/sql/regress/compGeneral/EXPECTED005 index f3a87e9..e9b12ce 100755 --- a/core/sql/regress/compGeneral/EXPECTED005 +++ b/core/sql/regress/compGeneral/EXPECTED005 @@ -1001,9 +1001,10 @@ DNO DNAME ENO DNO +> select A.dno,B.eno +> from t005t02 A full outer join t005t01 B on A.dno = B.dno; -*** ERROR[12001] Creation failed. The materialized view cannot be maintained incrementally. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. ---- SQL operation failed with errors. >> >>create materialized view T_MV1 +> Refresh on statement @@ -1012,9 +1013,10 @@ DNO DNAME ENO DNO +> select A.dno,B.eno +> from t005t02 A full outer join t005t01 B on A.dno = B.dno; -*** ERROR[12001] Creation failed. The materialized view cannot be maintained incrementally. +*** ERROR[3131] The statement just entered is currently not supported. + +*** ERROR[8822] The statement was not prepared. ---- SQL operation failed with errors. >> >> >>?section cleanup
