trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ansha...@apache.org
Subject [07/11] incubator-trafodion git commit: JIRA 2086 Add support for largeint unsigned
Date Fri, 01 Jul 2016 14:46:25 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/911f1d64/core/sql/regress/qat/eqatdml13
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml13 b/core/sql/regress/qat/eqatdml13
index d68b752..0cc7570 100755
--- a/core/sql/regress/qat/eqatdml13
+++ b/core/sql/regress/qat/eqatdml13
@@ -372,14 +372,14 @@ sue      Q        on         200    400    100    100    400    100    100     5
 +>             OR  pic_decimal_3 <> ?p3
 +>             AND pic_decimal_3 >= 6;
 
-CHAR_1  CHAR_10                                   PIC_X_1  PIC_X_7  PIC_X_LONG                                                                                                                                                                                                VAR_CHAR                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                BINARY_SIGNED  BINARY_32_U  BINARY_64_S            PIC_COMP_1            PIC_COMP_2  PIC_COMP_3    SMALL_INT  MEDIUM_INT  LARGE_INT             DECIMAL_1  DECIMAL_2_SIGNED  DECIMAL_3_UNSIGNED  PIC_DECIMAL_1  PIC_DECIMAL_2  PIC_DECIMAL_3
-------  ----------------------------------------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------
+CHAR_1  CHAR_10     PIC_X_1  PIC_X_7  PIC_X_LONG                                                                                                                                                                                                VAR_CHAR                                                                                                                                                                                                                                                       BINARY_SIGNED  BINARY_32_U  BINARY_64_S            PIC_COMP_1            PIC_COMP_2  PIC_COMP_3    SMALL_INT  MEDIUM_INT  LARGE_INT             DECIMAL_1  DECIMAL_2_SIGNED  DECIMAL_3_UNSIGNED  PIC_DECIMAL_1  PIC_DECIMAL_2  PIC_DECIMAL_3
+------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------
 
-D       michelle                                  D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                        -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
-D       melissa                                   C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                                                         1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
-E       monica                                    Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                                                         2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5
-C       maureen                                   E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                                                         3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
-D       steven                                    B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                         8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
+D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
+D       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
+E       monica      Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                             2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5
+C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
+D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
 
 --- 5 row(s) selected.
 >>
@@ -396,14 +396,14 @@ D       steven                                    B        9        bat
 +>                  OR  pic_decimal_3 <> ?p3)
 +>             AND pic_decimal_3 >= 6;
 
-CHAR_1  CHAR_10                                   PIC_X_1  PIC_X_7  PIC_X_LONG                                                                                                                                                                                                VAR_CHAR                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                BINARY_SIGNED  BINARY_32_U  BINARY_64_S            PIC_COMP_1            PIC_COMP_2  PIC_COMP_3    SMALL_INT  MEDIUM_INT  LARGE_INT             DECIMAL_1  DECIMAL_2_SIGNED  DECIMAL_3_UNSIGNED  PIC_DECIMAL_1  PIC_DECIMAL_2  PIC_DECIMAL_3
-------  ----------------------------------------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------
+CHAR_1  CHAR_10     PIC_X_1  PIC_X_7  PIC_X_LONG                                                                                                                                                                                                VAR_CHAR                                                                                                                                                                                                                                                       BINARY_SIGNED  BINARY_32_U  BINARY_64_S            PIC_COMP_1            PIC_COMP_2  PIC_COMP_3    SMALL_INT  MEDIUM_INT  LARGE_INT             DECIMAL_1  DECIMAL_2_SIGNED  DECIMAL_3_UNSIGNED  PIC_DECIMAL_1  PIC_DECIMAL_2  PIC_DECIMAL_3
+------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------
 
-D       michelle                                  D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                        -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
-D       melissa                                   C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                                                         1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
-E       monica                                    Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                                                         2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5
-C       maureen                                   E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                                                         3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
-D       steven                                    B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                         8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
+D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
+D       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
+E       monica      Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                             2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5
+C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
+D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
 
 --- 5 row(s) selected.
 >>
@@ -419,14 +419,14 @@ D       steven                                    B        9        bat
 +>             OR  (pic_decimal_3 <> ?p3
 +>                  AND pic_decimal_3 >= 6) ;
 
-CHAR_1  CHAR_10                                   PIC_X_1  PIC_X_7  PIC_X_LONG                                                                                                                                                                                                VAR_CHAR                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
                                                                                                                                                                                                                                                                                                BINARY_SIGNED  BINARY_32_U  BINARY_64_S            PIC_COMP_1            PIC_COMP_2  PIC_COMP_3    SMALL_INT  MEDIUM_INT  LARGE_INT             DECIMAL_1  DECIMAL_2_SIGNED  DECIMAL_3_UNSIGNED  PIC_DECIMAL_1  PIC_DECIMAL_2  PIC_DECIMAL_3
-------  ----------------------------------------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------
+CHAR_1  CHAR_10     PIC_X_1  PIC_X_7  PIC_X_LONG                                                                                                                                                                                                VAR_CHAR                                                                                                                                                                                                                                                       BINARY_SIGNED  BINARY_32_U  BINARY_64_S            PIC_COMP_1            PIC_COMP_2  PIC_COMP_3    SMALL_INT  MEDIUM_INT  LARGE_INT             DECIMAL_1  DECIMAL_2_SIGNED  DECIMAL_3_UNSIGNED  PIC_DECIMAL_1  PIC_DECIMAL_2  PIC_DECIMAL_3
+------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------
 
-D       michelle                                  D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                        -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
-D       melissa                                   C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
                                                                                                                                                                                                                                                                                                         1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
-E       monica                                    Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            
                                                                                                                                                                                                                                                                                                         2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5
-C       maureen                                   E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                
                                                                                                                                                                                                                                                                                                         3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
-D       steven                                    B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 
                                                                                                                                                                                                                                                                                                         8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
+D       michelle    D        michael  rat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                 -5000        90.00               2000.000                   500         .40     100.80000         90        8000                   200          7               .93                 140            6.1           .600              6
+D       melissa     C        7        pop                                                                                                                                                                                                       jimmy                                                                                                                                                                                                                                                                   1000        80.00               1500.000                   500         .20     100.99990         80        9000                   999          5               .80                 120            4.1           .400              4
+E       monica      Q        sue      pat                                                                                                                                                                                                       christopher                                                                                                                                                                                                                                                             2000        90.00               1200.000                  3000         .30     100.99999       2000        8000              -1000000          1               .90                  80            5.1           .500              5
+C       maureen     E        jimmy    rum                                                                                                                                                                                                       marilyn                                                                                                                                                                                                                                                                 3000        80.00               2000.000                   500         .50     100.70000       9000        1000                  2000          8               .97                 150            7.1           .700              7
+D       steven      B        9        bat                                                                                                                                                                                                       thomas                                                                                                                                                                                                                                                                  8000        70.00               2000.000                   500         .10     100.99900         90       10000                  1000          7               .70                 110            3.1           .300              3
 
 --- 5 row(s) selected.
 >>
@@ -815,7 +815,7 @@ D       steven                                    B        9        bat
 (EXPR)               
 ---------------------
 
-           2.20000000
+          2.200000000
 
 --- 1 row(s) selected.
 >>
@@ -828,7 +828,7 @@ D       steven                                    B        9        bat
 (EXPR)               
 ---------------------
 
-           2.20000000
+          2.200000000
 
 --- 1 row(s) selected.
 >>
@@ -843,7 +843,7 @@ D       steven                                    B        9        bat
 (EXPR)               
 ---------------------
 
-   999999999.99999999
+  999999999.999999999
 
 --- 1 row(s) selected.
 >>
@@ -856,7 +856,7 @@ D       steven                                    B        9        bat
 (EXPR)               
 ---------------------
 
-   999999999.99999999
+  999999999.999999999
 
 --- 1 row(s) selected.
 >>
@@ -867,10 +867,10 @@ D       steven                                    B        9        bat
 +>      from btsel26
 +>      where selector = ?p;
 
-(EXPR)               
----------------------
+(EXPR)                
+----------------------
 
-   1000000000.9999999
+  1000000000.999999998
 
 --- 1 row(s) selected.
 >>
@@ -881,10 +881,10 @@ D       steven                                    B        9        bat
 +>      from btsel26
 +>      where selector = ?p;
 
-(EXPR)               
----------------------
+(EXPR)                
+----------------------
 
-   1000000000.9999999
+  1000000000.999999998
 
 --- 1 row(s) selected.
 >>
@@ -1129,25 +1129,25 @@ D       steven                                    B        9        bat
 >>      select 10.999999999999999999
 +>      from btsel26;
 
-(EXPR)                
-----------------------
+(EXPR)               
+---------------------
 
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
 
 --- 16 row(s) selected.
 >>

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/911f1d64/core/sql/regress/seabase/EXPECTED003
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED003 b/core/sql/regress/seabase/EXPECTED003
index d526b7f..d46cdb8 100644
--- a/core/sql/regress/seabase/EXPECTED003
+++ b/core/sql/regress/seabase/EXPECTED003
@@ -9,7 +9,7 @@
 
 --- SQL operation complete.
 >>
->>obey TEST003(setup);
+>>obey TEST003(setup_tiny);
 >>create table t003t1(a tinyint not null primary key, b tinyint, 
 +>                    c tinyint unsigned default 10 not null, d tinyint unsigned);
 
@@ -17,7 +17,7 @@
 >>invoke t003t1;
 
 -- Definition of Trafodion table TRAFODION.SCH.T003T1
--- Definition current  Tue Jun 14 17:33:52 2016
+-- Definition current  Sat Jun 25 16:24:14 2016
 
   (
     A                                TINYINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -36,7 +36,7 @@
 >>invoke t003t1_like;
 
 -- Definition of Trafodion table TRAFODION.SCH.T003T1_LIKE
--- Definition current  Tue Jun 14 17:34:00 2016
+-- Definition current  Sat Jun 25 16:24:23 2016
 
   (
     A                                TINYINT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -49,26 +49,26 @@
 
 --- SQL operation complete.
 >>
->>create table t003t1_as as select * from t003t1;
+>>create table t003t1_as primary key (a) as select * from t003t1;
 
 --- 0 row(s) inserted.
 >>invoke t003t1_as;
 
 -- Definition of Trafodion table TRAFODION.SCH.T003T1_AS
--- Definition current  Tue Jun 14 17:34:03 2016
+-- Definition current  Sat Jun 25 16:24:27 2016
 
   (
-    SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE
-  , A                                TINYINT NO DEFAULT NOT NULL NOT DROPPABLE
+    A                                TINYINT NO DEFAULT NOT NULL NOT DROPPABLE
   , B                                TINYINT DEFAULT NULL
   , C                                TINYINT UNSIGNED NO DEFAULT NOT NULL NOT
       DROPPABLE
   , D                                TINYINT UNSIGNED DEFAULT NULL
   )
+  PRIMARY KEY (A ASC)
 
 --- SQL operation complete.
 >>
->>obey TEST003(dml);
+>>obey TEST003(dml_tiny);
 >>insert into t003t1 values (1, 2, 3, 4);
 
 --- 1 row(s) inserted.
@@ -288,7 +288,7 @@ A     B     C    D
 
 --- SQL operation complete.
 >>
->>obey TEST003(tinyhive);
+>>obey TEST003(hive_tiny);
 >>sh echo "drop table ttiny;" > TEST003_junk;
 >>sh regrhive.ksh -f TEST003_junk;
 >>
@@ -301,13 +301,13 @@ A     B     C    D
 >>invoke hive.hive.ttiny;
 
 -- Definition of hive table TTINY
--- Definition current  Tue Jun 14 17:34:44 2016
+-- Definition current  Sat Jun 25 16:25:08 2016
 
   (
     A                                TINYINT
   , B                                TINYINT
   )
-   /* stored as textfile */
+  /* stored as textfile */
 
 --- SQL operation complete.
 >>select * from hive.hive.ttiny;
@@ -346,7 +346,7 @@ A     B
 
 --- 4 row(s) selected.
 >>
->>obey TEST003(errors);
+>>obey TEST003(errors_tiny);
 >>update t003t1 set b = b + 1;
 
 *** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:SMALLINT SIGNED(REC_BIN16_SIGNED) Source Value:128 to Target Type:TINYINT SIGNED(REC_BIN8_SIGNED).
@@ -422,4 +422,993 @@ A     B
 --- 0 row(s) inserted.
 >>
 >>
+>>
+>>cqd traf_largeint_unsigned_io 'ON';
+
+--- SQL operation complete.
+>>cqd traf_create_signed_numeric_literal 'ON';
+
+--- SQL operation complete.
+>>obey TEST003(setup_lu);
+>>drop table if exists t003t2;
+
+--- SQL operation complete.
+>>drop table if exists t003t2_like;
+
+--- SQL operation complete.
+>>drop table if exists t003t2_as;
+
+--- SQL operation complete.
+>>
+>>create table t003t2(a largeint unsigned not null primary key, b largeint unsigned);
+
+--- SQL operation complete.
+>>invoke t003t2;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2
+-- Definition current  Sat Jun 25 16:25:17 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>create table t003t2_like like t003t2;
+
+--- SQL operation complete.
+>>invoke t003t2_like;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2_LIKE
+-- Definition current  Sat Jun 25 16:25:22 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>create table t003t2_as primary key(a) as select * from t003t2;
+
+--- 0 row(s) inserted.
+>>invoke t003t2_as;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2_AS
+-- Definition current  Sat Jun 25 16:25:25 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>obey TEST003(dml_lu);
+>>insert into t003t2 values (1, 2);
+
+--- 1 row(s) inserted.
+>>insert into t003t2 values (18446744073709551615, 18446744073709551615);
+
+--- 1 row(s) inserted.
+>>
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>insert into t003t2_as select * from t003t2;
+
+--- 2 row(s) inserted.
+>>select * from t003t2_as;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>select * from t003t2 where a = 1;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where a = -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a < 1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a <= -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a < 1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where a > -1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>select * from t003t2 where a = 18446744073709551615;
+
+A                     B                   
+--------------------  --------------------
+
+18446744073709551615  18446744073709551615
+
+--- 1 row(s) selected.
+>>
+>>select * from t003t2 where b = 2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where b < -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where b < 1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where b > -1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>select * from t003t2 where b = 18446744073709551615;
+
+A                     B                   
+--------------------  --------------------
+
+18446744073709551615  18446744073709551615
+
+--- 1 row(s) selected.
+>>
+>>select a, cast(cast(a as varchar(40)) as largeint unsigned) from t003t2;
+
+A                     (EXPR)              
+--------------------  --------------------
+
+                   1                     1
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>select a+10 from t003t2 where a = 1 or a = -1;
+
+(EXPR)              
+--------------------
+
+                  11
+
+--- 1 row(s) selected.
+>>
+>>select cast(100 as largeint unsigned) from (values(1)) x(a);
+
+(EXPR)              
+--------------------
+
+                 100
+
+--- 1 row(s) selected.
+>>
+>>select cast(a as char(21)), cast (b as varchar(22)) from t003t2;
+
+(EXPR)                 (EXPR)                
+---------------------  ----------------------
+
+1                      2                     
+18446744073709551615   18446744073709551615  
+
+--- 2 row(s) selected.
+>>
+>>prepare s from insert into t003t2 values (?, ?);
+
+--- SQL command prepared.
+>>execute s using 251, 0;
+
+--- 1 row(s) inserted.
+>>execute s using 11, 18446744073709551615;
+
+--- 1 row(s) inserted.
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+                  11  18446744073709551615
+                 251                     0
+18446744073709551615  18446744073709551615
+
+--- 4 row(s) selected.
+>>
+>>begin work;
+
+--- SQL operation complete.
+>>delete from t003t2 where b = 1;
+
+--- 0 row(s) deleted.
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+                  11  18446744073709551615
+                 251                     0
+18446744073709551615  18446744073709551615
+
+--- 4 row(s) selected.
+>>rollback work;
+
+--- SQL operation complete.
+>>
+>>begin work;
+
+--- SQL operation complete.
+>>update t003t2 set b = b + 1 where b = 2;
+
+--- 1 row(s) updated.
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     3
+                  11  18446744073709551615
+                 251                     0
+18446744073709551615  18446744073709551615
+
+--- 4 row(s) selected.
+>>rollback work;
+
+--- SQL operation complete.
+>>
+>>obey TEST003(errors_lu);
+>>update t003t2 set b = b + 1;
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) updated.
+>>
+>>delete from t003t2;
+
+--- 4 row(s) deleted.
+>>
+>>insert into t003t2 values (18446744073709551616, 2);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) inserted.
+>>insert into t003t2 values (2, 18446744073709551616);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) inserted.
+>>insert into t003t2 values (-1, 1);
+
+*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
+
+--- 0 row(s) inserted.
+>>
+>>select cast(-1 as largeint unsigned) from (values(1)) x(a);
+
+*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
+
+--- 0 row(s) selected.
+>>select cast(18446744073709551616 as largeint unsigned) from (values(1)) x(a);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) selected.
+>>
+>>prepare s from insert into t003t2 values (?, ?);
+
+--- SQL command prepared.
+>>execute s using 18446744073709551616, 2;
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:CHAR(REC_BYTE_F_ASCII,20 BYTES,ISO88591) Source Value:18446744073709551616 to Target Type:LARGEINT(REC_BIN64_SIGNED).
+
+*** ERROR[15015] PARAM ?(UNNAMED_1) (value 18446744073709551616) cannot be converted to type LARGEINT UNSIGNED.
+
+--- 0 row(s) inserted.
+>>
+>>
+>>
+>>cqd traf_create_signed_numeric_literal 'OFF';
+
+--- SQL operation complete.
+>>obey TEST003(setup_lu);
+>>drop table if exists t003t2;
+
+--- SQL operation complete.
+>>drop table if exists t003t2_like;
+
+--- SQL operation complete.
+>>drop table if exists t003t2_as;
+
+--- SQL operation complete.
+>>
+>>create table t003t2(a largeint unsigned not null primary key, b largeint unsigned);
+
+--- SQL operation complete.
+>>invoke t003t2;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2
+-- Definition current  Sat Jun 25 16:25:51 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>create table t003t2_like like t003t2;
+
+--- SQL operation complete.
+>>invoke t003t2_like;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2_LIKE
+-- Definition current  Sat Jun 25 16:25:55 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>create table t003t2_as primary key(a) as select * from t003t2;
+
+--- 0 row(s) inserted.
+>>invoke t003t2_as;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2_AS
+-- Definition current  Sat Jun 25 16:25:58 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>obey TEST003(dml_lu);
+>>insert into t003t2 values (1, 2);
+
+--- 1 row(s) inserted.
+>>insert into t003t2 values (18446744073709551615, 18446744073709551615);
+
+--- 1 row(s) inserted.
+>>
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>insert into t003t2_as select * from t003t2;
+
+--- 2 row(s) inserted.
+>>select * from t003t2_as;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>select * from t003t2 where a = 1;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where a = -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a < 1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a <= -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a < 1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where a > -1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>select * from t003t2 where a = 18446744073709551615;
+
+A                     B                   
+--------------------  --------------------
+
+18446744073709551615  18446744073709551615
+
+--- 1 row(s) selected.
+>>
+>>select * from t003t2 where b = 2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where b < -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where b < 1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where b > -1000;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>select * from t003t2 where b = 18446744073709551615;
+
+A                     B                   
+--------------------  --------------------
+
+18446744073709551615  18446744073709551615
+
+--- 1 row(s) selected.
+>>
+>>select a, cast(cast(a as varchar(40)) as largeint unsigned) from t003t2;
+
+A                     (EXPR)              
+--------------------  --------------------
+
+                   1                     1
+18446744073709551615  18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>select a+10 from t003t2 where a = 1 or a = -1;
+
+(EXPR)              
+--------------------
+
+                  11
+
+--- 1 row(s) selected.
+>>
+>>select cast(100 as largeint unsigned) from (values(1)) x(a);
+
+(EXPR)              
+--------------------
+
+                 100
+
+--- 1 row(s) selected.
+>>
+>>select cast(a as char(21)), cast (b as varchar(22)) from t003t2;
+
+(EXPR)                 (EXPR)                
+---------------------  ----------------------
+
+1                      2                     
+18446744073709551615   18446744073709551615  
+
+--- 2 row(s) selected.
+>>
+>>prepare s from insert into t003t2 values (?, ?);
+
+--- SQL command prepared.
+>>execute s using 251, 0;
+
+--- 1 row(s) inserted.
+>>execute s using 11, 18446744073709551615;
+
+--- 1 row(s) inserted.
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+                  11  18446744073709551615
+                 251                     0
+18446744073709551615  18446744073709551615
+
+--- 4 row(s) selected.
+>>
+>>begin work;
+
+--- SQL operation complete.
+>>delete from t003t2 where b = 1;
+
+--- 0 row(s) deleted.
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     2
+                  11  18446744073709551615
+                 251                     0
+18446744073709551615  18446744073709551615
+
+--- 4 row(s) selected.
+>>rollback work;
+
+--- SQL operation complete.
+>>
+>>begin work;
+
+--- SQL operation complete.
+>>update t003t2 set b = b + 1 where b = 2;
+
+--- 1 row(s) updated.
+>>select * from t003t2;
+
+A                     B                   
+--------------------  --------------------
+
+                   1                     3
+                  11  18446744073709551615
+                 251                     0
+18446744073709551615  18446744073709551615
+
+--- 4 row(s) selected.
+>>rollback work;
+
+--- SQL operation complete.
+>>
+>>obey TEST003(errors_lu);
+>>update t003t2 set b = b + 1;
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) updated.
+>>
+>>delete from t003t2;
+
+--- 4 row(s) deleted.
+>>
+>>insert into t003t2 values (18446744073709551616, 2);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) inserted.
+>>insert into t003t2 values (2, 18446744073709551616);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) inserted.
+>>insert into t003t2 values (-1, 1);
+
+*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
+
+--- 0 row(s) inserted.
+>>
+>>select cast(-1 as largeint unsigned) from (values(1)) x(a);
+
+*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
+
+--- 0 row(s) selected.
+>>select cast(18446744073709551616 as largeint unsigned) from (values(1)) x(a);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) selected.
+>>
+>>prepare s from insert into t003t2 values (?, ?);
+
+--- SQL command prepared.
+>>execute s using 18446744073709551616, 2;
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:CHAR(REC_BYTE_F_ASCII,20 BYTES,ISO88591) Source Value:18446744073709551616 to Target Type:LARGEINT(REC_BIN64_SIGNED).
+
+*** ERROR[15015] PARAM ?(UNNAMED_1) (value 18446744073709551616) cannot be converted to type LARGEINT UNSIGNED.
+
+--- 0 row(s) inserted.
+>>
+>>
+>>
+>>cqd traf_create_signed_numeric_literal 'ON';
+
+--- SQL operation complete.
+>>cqd traf_largeint_unsigned_io 'OFF';
+
+--- SQL operation complete.
+>>obey TEST003(setup_lu);
+>>drop table if exists t003t2;
+
+--- SQL operation complete.
+>>drop table if exists t003t2_like;
+
+--- SQL operation complete.
+>>drop table if exists t003t2_as;
+
+--- SQL operation complete.
+>>
+>>create table t003t2(a largeint unsigned not null primary key, b largeint unsigned);
+
+--- SQL operation complete.
+>>invoke t003t2;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2
+-- Definition current  Sat Jun 25 16:26:23 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>create table t003t2_like like t003t2;
+
+--- SQL operation complete.
+>>invoke t003t2_like;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2_LIKE
+-- Definition current  Sat Jun 25 16:26:28 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>create table t003t2_as primary key(a) as select * from t003t2;
+
+--- 0 row(s) inserted.
+>>invoke t003t2_as;
+
+-- Definition of Trafodion table TRAFODION.SCH.T003T2_AS
+-- Definition current  Sat Jun 25 16:26:31 2016
+
+  (
+    A                                LARGEINT UNSIGNED NO DEFAULT NOT NULL NOT
+      DROPPABLE
+  , B                                LARGEINT UNSIGNED DEFAULT NULL
+  )
+  PRIMARY KEY (A ASC)
+
+--- SQL operation complete.
+>>
+>>obey TEST003(dml_lu);
+>>insert into t003t2 values (1, 2);
+
+--- 1 row(s) inserted.
+>>insert into t003t2 values (18446744073709551615, 18446744073709551615);
+
+--- 1 row(s) inserted.
+>>
+>>select * from t003t2;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+ 18446744073709551615   18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>insert into t003t2_as select * from t003t2;
+
+--- 2 row(s) inserted.
+>>select * from t003t2_as;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+ 18446744073709551615   18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>select * from t003t2 where a = 1;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where a = -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a < 1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a <= -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where a < 1000;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where a > -1000;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+ 18446744073709551615   18446744073709551615
+
+--- 2 row(s) selected.
+>>select * from t003t2 where a = 18446744073709551615;
+
+A                      B                    
+---------------------  ---------------------
+
+ 18446744073709551615   18446744073709551615
+
+--- 1 row(s) selected.
+>>
+>>select * from t003t2 where b = 2;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where b < -1;
+
+--- 0 row(s) selected.
+>>select * from t003t2 where b < 1000;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+
+--- 1 row(s) selected.
+>>select * from t003t2 where b > -1000;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+ 18446744073709551615   18446744073709551615
+
+--- 2 row(s) selected.
+>>select * from t003t2 where b = 18446744073709551615;
+
+A                      B                    
+---------------------  ---------------------
+
+ 18446744073709551615   18446744073709551615
+
+--- 1 row(s) selected.
+>>
+>>select a, cast(cast(a as varchar(40)) as largeint unsigned) from t003t2;
+
+A                      (EXPR)               
+---------------------  ---------------------
+
+                    1                      1
+ 18446744073709551615   18446744073709551615
+
+--- 2 row(s) selected.
+>>
+>>select a+10 from t003t2 where a = 1 or a = -1;
+
+(EXPR)              
+--------------------
+
+                  11
+
+--- 1 row(s) selected.
+>>
+>>select cast(100 as largeint unsigned) from (values(1)) x(a);
+
+(EXPR)               
+---------------------
+
+                  100
+
+--- 1 row(s) selected.
+>>
+>>select cast(a as char(21)), cast (b as varchar(22)) from t003t2;
+
+(EXPR)                 (EXPR)                
+---------------------  ----------------------
+
+1                      2                     
+18446744073709551615   18446744073709551615  
+
+--- 2 row(s) selected.
+>>
+>>prepare s from insert into t003t2 values (?, ?);
+
+--- SQL command prepared.
+>>execute s using 251, 0;
+
+--- 1 row(s) inserted.
+>>execute s using 11, 18446744073709551615;
+
+--- 1 row(s) inserted.
+>>select * from t003t2;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+                   11   18446744073709551615
+                  251                      0
+ 18446744073709551615   18446744073709551615
+
+--- 4 row(s) selected.
+>>
+>>begin work;
+
+--- SQL operation complete.
+>>delete from t003t2 where b = 1;
+
+--- 0 row(s) deleted.
+>>select * from t003t2;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      2
+                   11   18446744073709551615
+                  251                      0
+ 18446744073709551615   18446744073709551615
+
+--- 4 row(s) selected.
+>>rollback work;
+
+--- SQL operation complete.
+>>
+>>begin work;
+
+--- SQL operation complete.
+>>update t003t2 set b = b + 1 where b = 2;
+
+--- 1 row(s) updated.
+>>select * from t003t2;
+
+A                      B                    
+---------------------  ---------------------
+
+                    1                      3
+                   11   18446744073709551615
+                  251                      0
+ 18446744073709551615   18446744073709551615
+
+--- 4 row(s) selected.
+>>rollback work;
+
+--- SQL operation complete.
+>>
+>>obey TEST003(errors_lu);
+>>update t003t2 set b = b + 1;
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) updated.
+>>
+>>delete from t003t2;
+
+--- 4 row(s) deleted.
+>>
+>>insert into t003t2 values (18446744073709551616, 2);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) inserted.
+>>insert into t003t2 values (2, 18446744073709551616);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) inserted.
+>>insert into t003t2 values (-1, 1);
+
+*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
+
+--- 0 row(s) inserted.
+>>
+>>select cast(-1 as largeint unsigned) from (values(1)) x(a);
+
+*** ERROR[8432] A negative value cannot be converted to an unsigned numeric datatype.
+
+--- 0 row(s) selected.
+>>select cast(18446744073709551616 as largeint unsigned) from (values(1)) x(a);
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) selected.
+>>
+>>prepare s from insert into t003t2 values (?, ?);
+
+--- SQL command prepared.
+>>execute s using 18446744073709551616, 2;
+
+*** ERROR[8411] A numeric overflow occurred during an arithmetic computation or data conversion. Conversion of Source Type:NUMERIC(REC_NUM_BIG_SIGNED) Source Value:0x00000000000000000100 to Target Type:LARGEINT UNSIGNED(REC_BIN64_UNSIGNED).
+
+--- 0 row(s) inserted.
+>>
+>>
+>>
 >>log;

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/911f1d64/core/sql/regress/seabase/EXPECTED020
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/EXPECTED020 b/core/sql/regress/seabase/EXPECTED020
index 25bda60..23636e3 100644
--- a/core/sql/regress/seabase/EXPECTED020
+++ b/core/sql/regress/seabase/EXPECTED020
@@ -6,7 +6,7 @@
 >>invoke test020t1;
 
 -- Definition of Trafodion table TRAFODION.SCH.TEST020T1
--- Definition current  Sun Mar 13 06:02:17 2016
+-- Definition current  Wed Jun 22 05:43:20 2016
 
   (
     C1                               INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -49,7 +49,7 @@ C1           C2
 >>invoke test020t2;
 
 -- Definition of Trafodion table TRAFODION.SCH.TEST020T2
--- Definition current  Thu Mar 24 20:57:21 2016
+-- Definition current  Wed Jun 22 05:43:23 2016
 
   (
     C                                CHAR(15) CHARACTER SET ISO88591 COLLATE
@@ -161,7 +161,7 @@ G0
 >>invoke test020t5;
 
 -- Definition of Trafodion table TRAFODION.SCH.TEST020T5
--- Definition current  Thu Mar 24 20:57:29 2016
+-- Definition current  Wed Jun 22 05:43:36 2016
 
   (
     C                                INT NO DEFAULT NOT NULL NOT DROPPABLE
@@ -260,7 +260,7 @@ ALTER TABLE TRAFODION.SCH.TEST020T5 ADD CONSTRAINT TRAFODION.SCH.TEST020T5C1
 >>invoke test020t6;
 
 -- Definition of Trafodion table TRAFODION.SCH.TEST020T6
--- Definition current  Thu Mar 24 20:58:14 2016
+-- Definition current  Wed Jun 22 05:44:27 2016
 
   (
     SYSKEY                           LARGEINT NO DEFAULT NOT NULL NOT DROPPABLE

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/911f1d64/core/sql/regress/seabase/TEST003
----------------------------------------------------------------------
diff --git a/core/sql/regress/seabase/TEST003 b/core/sql/regress/seabase/TEST003
index f55a6ca..b2068a5 100644
--- a/core/sql/regress/seabase/TEST003
+++ b/core/sql/regress/seabase/TEST003
@@ -19,7 +19,7 @@
 --
 -- @@@ END COPYRIGHT @@@
 
--- Tests for tinyint datatype
+-- Tests for tinyint, largeint unsigned datatypes
 
 
 obey TEST003(clean_up);
@@ -30,14 +30,32 @@ cqd traf_tinyint_support 'ON';
 cqd traf_tinyint_return_values 'ON';
 cqd traf_tinyint_input_params 'ON';
 
-obey TEST003(setup);
-obey TEST003(dml);
-obey TEST003(tinyhive);
-obey TEST003(errors);
+obey TEST003(setup_tiny);
+obey TEST003(dml_tiny);
+obey TEST003(hive_tiny);
+obey TEST003(errors_tiny);
+
+cqd traf_largeint_unsigned_io 'ON';
+cqd traf_create_signed_numeric_literal 'ON';
+obey TEST003(setup_lu);
+obey TEST003(dml_lu);
+obey TEST003(errors_lu);
+
+cqd traf_create_signed_numeric_literal 'OFF';
+obey TEST003(setup_lu);
+obey TEST003(dml_lu);
+obey TEST003(errors_lu);
+
+cqd traf_create_signed_numeric_literal 'ON';
+cqd traf_largeint_unsigned_io 'OFF';
+obey TEST003(setup_lu);
+obey TEST003(dml_lu);
+obey TEST003(errors_lu);
+
 log;
 exit;
 
-?section setup
+?section setup_tiny
 create table t003t1(a tinyint not null primary key, b tinyint, 
                     c tinyint unsigned default 10 not null, d tinyint unsigned);
 invoke t003t1;
@@ -45,10 +63,10 @@ invoke t003t1;
 create table t003t1_like like t003t1;
 invoke t003t1_like;
 
-create table t003t1_as as select * from t003t1;
+create table t003t1_as primary key (a) as select * from t003t1;
 invoke t003t1_as;
 
-?section dml
+?section dml_tiny
 insert into t003t1 values (1, 2, 3, 4);
 insert into t003t1 values (-1, -2, 255, 255);
 insert into t003t1 values (-128, 127, 0, 0);
@@ -91,7 +109,7 @@ update t003t1 set b = b + 1 where b <> 127;
 select * from t003t1;
 rollback work;
 
-?section tinyhive
+?section hive_tiny
 sh echo "drop table ttiny;" > TEST003_junk;
 sh regrhive.ksh -f TEST003_junk;
 
@@ -108,7 +126,7 @@ select * from hive.hive.ttiny;
 insert overwrite table hive.hive.ttiny select a, b from t003t1;
 select * from hive.hive.ttiny;
 
-?section errors
+?section errors_tiny
 update t003t1 set b = b + 1;
 
 delete from t003t1;
@@ -128,11 +146,92 @@ execute s using 128, 2, 3, 4;
 execute s using 4, 4, 256, -4;
 
 
+?section setup_lu
+drop table if exists t003t2;
+drop table if exists t003t2_like;
+drop table if exists t003t2_as;
+
+create table t003t2(a largeint unsigned not null primary key, b largeint unsigned);
+invoke t003t2;
+
+create table t003t2_like like t003t2;
+invoke t003t2_like;
+
+create table t003t2_as primary key(a) as select * from t003t2;
+invoke t003t2_as;
+
+?section dml_lu
+insert into t003t2 values (1, 2);
+insert into t003t2 values (18446744073709551615, 18446744073709551615);
+
+select * from t003t2;
+
+insert into t003t2_as select * from t003t2;
+select * from t003t2_as;
+
+select * from t003t2 where a = 1;
+select * from t003t2 where a = -1;
+select * from t003t2 where a < 1;
+select * from t003t2 where a <= -1;
+select * from t003t2 where a < 1000;
+select * from t003t2 where a > -1000;
+select * from t003t2 where a = 18446744073709551615;
+
+select * from t003t2 where b = 2;
+select * from t003t2 where b < -1;
+select * from t003t2 where b < 1000;
+select * from t003t2 where b > -1000;
+select * from t003t2 where b = 18446744073709551615;
+
+select a, cast(cast(a as varchar(40)) as largeint unsigned) from t003t2;
+
+select a+10 from t003t2 where a = 1 or a = -1;
+
+select cast(100 as largeint unsigned) from (values(1)) x(a);
+
+select cast(a as char(21)), cast (b as varchar(22)) from t003t2;
+
+prepare s from insert into t003t2 values (?, ?);
+execute s using 251, 0;
+execute s using 11, 18446744073709551615;
+select * from t003t2;
+
+begin work;
+delete from t003t2 where b = 1;
+select * from t003t2;
+rollback work;
+
+begin work;
+update t003t2 set b = b + 1 where b = 2;
+select * from t003t2;
+rollback work;
+
+?section errors_lu
+update t003t2 set b = b + 1;
+
+delete from t003t2;
+
+insert into t003t2 values (18446744073709551616, 2);
+insert into t003t2 values (2, 18446744073709551616);
+insert into t003t2 values (-1, 1);
+
+select cast(-1 as largeint unsigned) from (values(1)) x(a);
+select cast(18446744073709551616 as largeint unsigned) from (values(1)) x(a);
+
+prepare s from insert into t003t2 values (?, ?);
+execute s using 18446744073709551616, 2;
+
+
 ?section clean_up
 drop table t003t1;
 drop table t003t1_like;
 drop table t003t1_as;
 
 
+drop table t003t2;
+drop table t003t2_like;
+drop table t003t2_as;
+
+
 
 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/911f1d64/core/sql/sqlci/SqlciEnv.cpp
----------------------------------------------------------------------
diff --git a/core/sql/sqlci/SqlciEnv.cpp b/core/sql/sqlci/SqlciEnv.cpp
index 8cb63f1..a8d9bab 100644
--- a/core/sql/sqlci/SqlciEnv.cpp
+++ b/core/sql/sqlci/SqlciEnv.cpp
@@ -482,12 +482,15 @@ void SqlciEnv::generateExplain()
     }
 }
 
-void SqlciEnv::tinyintSupport()
+void SqlciEnv::datatypeSupport()
 {
   // Can handle tinyint datatype
   SqlCmd::executeQuery("CONTROL QUERY DEFAULT TRAF_TINYINT_SUPPORT 'ON';", this);
   SqlCmd::executeQuery("CONTROL QUERY DEFAULT TRAF_TINYINT_RETURN_VALUES 'ON';", this);
   SqlCmd::executeQuery("CONTROL QUERY DEFAULT TRAF_TINYINT_INPUT_PARAMS 'ON';", this);
+
+  // can handle largeint unsigned datatype
+  SqlCmd::executeQuery("CONTROL QUERY DEFAULT TRAF_LARGEINT_UNSIGNED_IO 'ON';", this);
   if (!specialError_)
     {
       exit(EXIT_FAILURE);
@@ -548,7 +551,7 @@ static void SqlciEnv_prologue_to_run(SqlciEnv *sqlciEnv)
   sqlciEnv->readonlyCursors();
   sqlciEnv->pertableStatistics();
   sqlciEnv->generateExplain();
-  sqlciEnv->tinyintSupport();
+  sqlciEnv->datatypeSupport();
   sqlciEnv->sqlmxRegress();
 
   // see catman/CatWellKnownTables.cpp for this envvar need.

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/911f1d64/core/sql/sqlci/SqlciEnv.h
----------------------------------------------------------------------
diff --git a/core/sql/sqlci/SqlciEnv.h b/core/sql/sqlci/SqlciEnv.h
index 122439b..f4b5019 100644
--- a/core/sql/sqlci/SqlciEnv.h
+++ b/core/sql/sqlci/SqlciEnv.h
@@ -328,7 +328,7 @@ public:
   void readonlyCursors();
   void pertableStatistics();
   void generateExplain();
-  void tinyintSupport();
+  void datatypeSupport();
   void sqlmxRegress();
 
   void welcomeMessage();



Mime
View raw message