http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/charsets/EXPECTED310
----------------------------------------------------------------------
diff --git a/core/sql/regress/charsets/EXPECTED310
b/core/sql/regress/charsets/EXPECTED310
index 90eb60a..853faca 100644
--- a/core/sql/regress/charsets/EXPECTED310
+++ b/core/sql/regress/charsets/EXPECTED310
@@ -4905,7 +4905,10 @@ u1u1 u1u1
>>create TRIGGER TRG1_cs310t90 before UPDATE on cs310t90 REFERENCING NEW
>>as TRG FOR EACH ROW
+> set TRG.UCS2_col2 = _ISO88591'abc' ;
---- SQL operation complete.
+*** ERROR[3131] The statement just entered is currently not supported.
+
+*** ERROR[8822] The statement was not prepared.
+
>>--
>>insert into cs310t90 values('Test1','Test1','Test1','Test1'),
>>('test111','test1111','test111','test1111');
@@ -4918,7 +4921,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.
@@ -4931,7 +4934,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.
@@ -4947,8 +4950,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
@@ -4962,8 +4965,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
@@ -4980,9 +4983,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
@@ -4997,9 +5000,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
@@ -5008,11 +5011,17 @@ test333
test33
>>--
>>DROP TRIGGER TRG1_cs310t90;
---- SQL operation complete.
+*** ERROR[3131] The statement just entered is currently not supported.
+
+*** ERROR[8822] The statement was not prepared.
+
>>create TRIGGER TRG1_cs310t90 before UPDATE on cs310t90 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 cs310t90 values('Test4','Test4','Test4','Test4'),
>>('test444','test4444','test444','test4444');
@@ -5025,10 +5034,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
@@ -5044,10 +5053,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
@@ -5066,11 +5075,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
@@ -5087,11 +5096,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
@@ -5111,12 +5120,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
@@ -5134,12 +5143,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
@@ -5165,7 +5174,10 @@ test666
test66
>>create TRIGGER TRG1_cs310t91 before UPDATE on cs310t91 REFERENCING NEW
>>as TRG FOR EACH ROW
+> set TRG.UCS2_col2 = _ISO88591'abc' ;
---- SQL operation complete.
+*** ERROR[3131] The statement just entered is currently not supported.
+
+*** ERROR[8822] The statement was not prepared.
+
>>--
>>insert into cs310t91 values(1,'Test1','Test1','Test1','Test1'),
>>(2,'test111','test1111','test111','test1111');
@@ -5178,7 +5190,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.
@@ -5191,7 +5203,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.
@@ -5207,9 +5219,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.
@@ -5222,9 +5234,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.
@@ -5240,11 +5252,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.
@@ -5257,22 +5269,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_cs310t91;
---- SQL operation complete.
+*** ERROR[3131] The statement just entered is currently not supported.
+
+*** ERROR[8822] The statement was not prepared.
+
>>create TRIGGER TRG1_cs310t91 before UPDATE on cs310t91 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 cs310t91 values(7,'Test4','Test4','Test4','Test4'),
>>(8,'test444','test4444','test444','test4444');
@@ -5285,13 +5303,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.
@@ -5304,13 +5322,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.
@@ -5326,15 +5344,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.
@@ -5347,15 +5365,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.
@@ -5371,17 +5389,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.
@@ -5394,17 +5412,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.
