http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/charsets/EXPECTED312
----------------------------------------------------------------------
diff --git a/core/sql/regress/charsets/EXPECTED312
b/core/sql/regress/charsets/EXPECTED312
index 29f1911..50ece35 100644
--- a/core/sql/regress/charsets/EXPECTED312
+++ b/core/sql/regress/charsets/EXPECTED312
@@ -5615,7 +5615,10 @@ u1u1 u1u1
>>create TRIGGER TRG1_cs312t90 before UPDATE on cs312t90 REFERENCING NEW
>>as TRG FOR EACH ROW
+> set TRG.UTF8_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 cs312t90 values('Test1','Test1','Test1','Test1'),
>>('test111','test1111','test111','test1111');
@@ -5628,7 +5631,7 @@ u1u1 u1u1
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Test1 abc
Test1 Iso1
+Test1 Test1
Test1 Iso1
test111 test1111
test111 test1111
--- 2 row(s) selected.
@@ -5641,7 +5644,7 @@ test111 test1111
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Test1 abc
Test1 Iso1
+Test1 Test1
Test1 Iso1
test111 test1111
test111 test1111
--- 2 row(s) selected.
@@ -5657,8 +5660,8 @@ test111 test1111
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
test111 test1111
test111 test1111
test222 test2222
test222 test2222
@@ -5672,8 +5675,8 @@ test222 test2222
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
test111 test1111
test111 test1111
test222 test2222
test222 test2222
@@ -5690,9 +5693,9 @@ test222 test2222
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
+Iso3 Test3
Test3 Test3
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5707,9 +5710,9 @@ test333 test3333
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
+Iso3 Test3
Test3 Test3
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5718,11 +5721,17 @@ test333 test3333
test
>>--
>>DROP TRIGGER TRG1_cs312t90;
---- SQL operation complete.
+*** ERROR[3131] The statement just entered is currently not supported.
+
+*** ERROR[8822] The statement was not prepared.
+
>>create TRIGGER TRG1_cs312t90 before UPDATE on cs312t90 REFERENCING NEW
>>as TRG FOR EACH ROW
+> set TRG.ISO_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 cs312t90 values('Test4','Test4','Test4','Test4'),
>>('test444','test4444','test444','test4444');
@@ -5735,10 +5744,10 @@ test333 test3333
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
-Test4 Test4
Iso4 abc
+Iso3 Test3
Test3 Test3
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
+Test4 Test4
Iso4 Test4
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5754,10 +5763,10 @@ test444 test4444
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
-Test4 Test4
Iso4 abc
+Iso3 Test3
Test3 Test3
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
+Test4 Test4
Iso4 Test4
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5776,11 +5785,11 @@ test444 test4444
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
-Test4 Test4
Iso4 abc
-Test5 Test5
UCS5 abc
+Iso3 Test3
Test3 Test3
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
+Test4 Test4
Iso4 Test4
+Test5 Test5
UCS5 Test5
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5797,11 +5806,11 @@ test555 test5555
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
-Test4 Test4
Iso4 abc
-Test5 Test5
UCS5 abc
+Iso3 Test3
Test3 Test3
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
+Test4 Test4
Iso4 Test4
+Test5 Test5
UCS5 Test5
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5821,12 +5830,12 @@ test555 test5555
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Iso6 Test6
Test6 abc
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
-Test4 Test4
Iso4 abc
-Test5 Test5
UCS5 abc
+Iso3 Test3
Test3 Test3
+Iso6 Test6
Test6 Test6
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
+Test4 Test4
Iso4 Test4
+Test5 Test5
UCS5 Test5
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5844,12 +5853,12 @@ test666 test6666
test
UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
------------------------------------ ------------------------------------
------------------------------------ ------------------------------------
-Iso3 abc
Test3 Test3
-Iso6 Test6
Test6 abc
-Test1 abc
Test1 Iso1
-Test2 abc
Test2 UTF8
-Test4 Test4
Iso4 abc
-Test5 Test5
UCS5 abc
+Iso3 Test3
Test3 Test3
+Iso6 Test6
Test6 Test6
+Test1 Test1
Test1 Iso1
+Test2 Test2
Test2 UTF8
+Test4 Test4
Iso4 Test4
+Test5 Test5
UCS5 Test5
test111 test1111
test111 test1111
test222 test2222
test222 test2222
test333 test3333
test333 test3333
@@ -5875,7 +5884,10 @@ test666 test6666
test
>>create TRIGGER TRG1_cs312t91 before UPDATE on cs312t91 REFERENCING NEW
>>as TRG FOR EACH ROW
+> set TRG.UTF8_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 cs312t91 values(1,'Test1','Test1','Test1','Test1'),
>>(2,'test111','test1111','test111','test1111');
@@ -5888,7 +5900,7 @@ test666 test6666
test
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
--- 2 row(s) selected.
@@ -5901,7 +5913,7 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
--- 2 row(s) selected.
@@ -5917,9 +5929,9 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
4 test222 test2222
test222 test2222
--- 4 row(s) selected.
@@ -5932,9 +5944,9 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
4 test222 test2222
test222 test2222
--- 4 row(s) selected.
@@ -5950,11 +5962,11 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
4 test222 test2222
test222 test2222
- 5 Iso3 abc
Test3 Test3
+ 5 Iso3 Test3
Test3 Test3
6 test333 test3333
test333 test3333
--- 6 row(s) selected.
@@ -5967,22 +5979,28 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
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_cs312t91;
---- SQL operation complete.
+*** ERROR[3131] The statement just entered is currently not supported.
+
+*** ERROR[8822] The statement was not prepared.
+
>>create TRIGGER TRG1_cs312t91 before UPDATE on cs312t91 REFERENCING NEW
>>as TRG FOR EACH ROW
+> set TRG.ISO_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 cs312t91 values(7,'Test4','Test4','Test4','Test4'),
>>(8,'test444','test4444','test444','test4444');
@@ -5995,13 +6013,13 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
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.
@@ -6014,13 +6032,13 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
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.
@@ -6036,15 +6054,15 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
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.
@@ -6057,15 +6075,15 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
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.
@@ -6081,17 +6099,17 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
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.
@@ -6104,17 +6122,17 @@ PRKY UTF8_COL1
UTF8_COL2
PRKY UTF8_COL1 UTF8_COL2
ISO_COL1 ISO_COL2
----------- ------------------------------------
------------------------------------ ------------------------------------
------------------------------------
- 1 Test1 abc
Test1 Iso1
+ 1 Test1 Test1
Test1 Iso1
2 test111 test1111
test111 test1111
- 3 Test2 abc
Test2 UTF8
+ 3 Test2 Test2
Test2 UTF8
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.
