http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/681cad66/core/sql/regress/charsets/EXPECTED012
----------------------------------------------------------------------
diff --git a/core/sql/regress/charsets/EXPECTED012
b/core/sql/regress/charsets/EXPECTED012
index 4574ba5..d38b2df 100755
--- a/core/sql/regress/charsets/EXPECTED012
+++ b/core/sql/regress/charsets/EXPECTED012
@@ -19,7 +19,7 @@
>>
>>showddl tlongvarchar0;
-CREATE TABLE CAT.SCH.TLONGVARCHAR0
+CREATE TABLE TRAFODION.SCH.TLONGVARCHAR0
(
A VARCHAR(10) CHARACTER SET UCS2 COLLATE
DEFAULT DEFAULT NULL
@@ -29,7 +29,7 @@ CREATE TABLE CAT.SCH.TLONGVARCHAR0
--- SQL operation complete.
>>showddl tlongwvarchar0;
-CREATE TABLE CAT.SCH.TLONGWVARCHAR0
+CREATE TABLE TRAFODION.SCH.TLONGWVARCHAR0
(
A VARCHAR(50) CHARACTER SET UCS2 COLLATE
DEFAULT DEFAULT NULL
@@ -39,11 +39,12 @@ CREATE TABLE CAT.SCH.TLONGWVARCHAR0
--- SQL operation complete.
>>invoke tlongwvarchar1;
--- Definition of table CAT.SCH.TLONGWVARCHAR1
--- Definition current Sat Jul 29 13:18:17 2006
+-- Definition of Trafodion table TRAFODION.SCH.TLONGWVARCHAR1
+-- Definition current Thu Feb 25 10:25:29 2016
(
- A VARCHAR(2000) CHARACTER SET UCS2 COLLATE
+ SYSKEY LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
+ , A VARCHAR(2000) CHARACTER SET UCS2 COLLATE
DEFAULT DEFAULT _UCS2'good day'
, B VARCHAR(2000) CHARACTER SET UCS2 COLLATE
DEFAULT DEFAULT _UCS2'today'
@@ -120,11 +121,11 @@ tomorrow_suffix
>>select a || _ucs2'_suffix' from tlongwvarchar1;
(EXPR)
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------
-abc_suffix
-today_suffix
-good day_suffix
+abc_suffix
+today_suffix
+good day_suffix
--- 3 row(s) selected.
>>
