trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ansha...@apache.org
Subject [05/12] incubator-trafodion git commit: JIRA TRAFODION-2834 Streamline supported xn access modes
Date Wed, 13 Dec 2017 19:02:27 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml06
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml06 b/core/sql/regress/qat/eqatdml06
index cd5e607..470b593 100755
--- a/core/sql/regress/qat/eqatdml06
+++ b/core/sql/regress/qat/eqatdml06
@@ -29,8 +29,8 @@
 >>--             expression list
 >>--         A3: SELECT WHERE <predicate>, where <predicate> contains
 >>--             AND, OR, NOT
->>--         A4: use of SELECT WHERE ... for browse access,for stable access
->>--            , for repeatable access
+>>--         A4: use of SELECT WHERE ... for read committed access,for read committed access
+>>--            , for read committed access
 >>--         A5: SELECT aggregate functions with WHERE predicate
 >>
 >>-- All testcases are documented further below.
@@ -95,10 +95,10 @@ D       steven      B        9        bat
 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  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                     
                                                 MEDIUM_INT   PIC_X_7  PIC_COMP_1
 ------  ----------  -------  -------  --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------------  -----------  ---------------------  --------------------  ----------  ------------  ---------  ----------  --------------------  ---------  ----------------  ------------------  -------------  -------------  -------------  ----------  -----------  ----------  --------------------  -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 ----------------------------------------------  -----------  -------  --------------------
 
-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          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                          
                                                        1000  7                         200
-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          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                          
                                                        1000  7                         200
-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          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                         
                                                        2000  B                         500
-A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                          
                                                         999  A                         300
+A       steven      C        walter   bob                                                                                                                                                                                                       B                                                                                                                                                                                                                                                                         50        50.00                200.000                    50         .12     100.90000         10       10000            1000000000          4               .50                  90            1.1           .100              1          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                          
                                                         999  A                         300
+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          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                          
                                                        1000  7                         200
+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          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                          
                                                        1000  7                         200
+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          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                         
                                                        2000  B                         500
 
 --- 4 row(s) selected.
 >>-- <ufi-input>
@@ -110,48 +110,48 @@ BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7
 -------------  --------------------  ----------  -------------  -------  -------  ---------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------
 
         -5000                   200        8000              6  D        michael         90  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        -5000                   200        8000              6  D        michael         90  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-        -5000                   200        8000              6  D        michael         90  william                                                                                                                                                                                                                                                             1000  black                    2000
-        -5000                   200        8000              6  D        michael         90  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-        -5000                   200        8000              6  D        michael         90  bill                                                                                                                                                                                                                                                                2000  B                         500
-        -5000                   200        8000              6  D        michael         90  bob                                                                                                                                                                                                                                                                  999  A                         300
            50            1000000000       10000              1  C        walter          10  tom                                                                                                                                                                                                                                                                 1000  7                         200
-           50            1000000000       10000              1  C        walter          10  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-           50            1000000000       10000              1  C        walter          10  william                                                                                                                                                                                                                                                             1000  black                    2000
-           50            1000000000       10000              1  C        walter          10  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-           50            1000000000       10000              1  C        walter          10  bill                                                                                                                                                                                                                                                                2000  B                         500
-           50            1000000000       10000              1  C        walter          10  bob                                                                                                                                                                                                                                                                  999  A                         300
            60                 -1000        8000              2  A        bobby         1000  tom                                                                                                                                                                                                                                                                 1000  7                         200
-           60                 -1000        8000              2  A        bobby         1000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-           60                 -1000        8000              2  A        bobby         1000  william                                                                                                                                                                                                                                                             1000  black                    2000
-           60                 -1000        8000              2  A        bobby         1000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-           60                 -1000        8000              2  A        bobby         1000  bill                                                                                                                                                                                                                                                                2000  B                         500
-           60                 -1000        8000              2  A        bobby         1000  bob                                                                                                                                                                                                                                                                  999  A                         300
          1000                   999        9000              4  C        7               80  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         1000                   999        9000              4  C        7               80  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-         1000                   999        9000              4  C        7               80  william                                                                                                                                                                                                                                                             1000  black                    2000
-         1000                   999        9000              4  C        7               80  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-         1000                   999        9000              4  C        7               80  bill                                                                                                                                                                                                                                                                2000  B                         500
-         1000                   999        9000              4  C        7               80  bob                                                                                                                                                                                                                                                                  999  A                         300
          2000              -1000000        8000              5  Q        sue           2000  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         2000              -1000000        8000              5  Q        sue           2000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-         2000              -1000000        8000              5  Q        sue           2000  william                                                                                                                                                                                                                                                             1000  black                    2000
-         2000              -1000000        8000              5  Q        sue           2000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-         2000              -1000000        8000              5  Q        sue           2000  bill                                                                                                                                                                                                                                                                2000  B                         500
+         4000                     0        5000              8  Z        johnny        8000  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         8000                  1000       10000              3  B        9               90  tom                                                                                                                                                                                                                                                                 1000  7                         200
+        -5000                   200        8000              6  D        michael         90  bob                                                                                                                                                                                                                                                                  999  A                         300
+           50            1000000000       10000              1  C        walter          10  bob                                                                                                                                                                                                                                                                  999  A                         300
+           60                 -1000        8000              2  A        bobby         1000  bob                                                                                                                                                                                                                                                                  999  A                         300
+         1000                   999        9000              4  C        7               80  bob                                                                                                                                                                                                                                                                  999  A                         300
          2000              -1000000        8000              5  Q        sue           2000  bob                                                                                                                                                                                                                                                                  999  A                         300
          3000                  2000        1000              7  E        jimmy         9000  bob                                                                                                                                                                                                                                                                  999  A                         300
-         4000                     0        5000              8  Z        johnny        8000  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         4000                     0        5000              8  Z        johnny        8000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-         4000                     0        5000              8  Z        johnny        8000  william                                                                                                                                                                                                                                                             1000  black                    2000
-         4000                     0        5000              8  Z        johnny        8000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-         4000                     0        5000              8  Z        johnny        8000  bill                                                                                                                                                                                                                                                                2000  B                         500
          4000                     0        5000              8  Z        johnny        8000  bob                                                                                                                                                                                                                                                                  999  A                         300
-         8000                  1000       10000              3  B        9               90  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         8000                  1000       10000              3  B        9               90  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-         8000                  1000       10000              3  B        9               90  william                                                                                                                                                                                                                                                             1000  black                    2000
-         8000                  1000       10000              3  B        9               90  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-         8000                  1000       10000              3  B        9               90  bill                                                                                                                                                                                                                                                                2000  B                         500
          8000                  1000       10000              3  B        9               90  bob                                                                                                                                                                                                                                                                  999  A                         300
+        -5000                   200        8000              6  D        michael         90  bill                                                                                                                                                                                                                                                                2000  B                         500
+           50            1000000000       10000              1  C        walter          10  bill                                                                                                                                                                                                                                                                2000  B                         500
+           60                 -1000        8000              2  A        bobby         1000  bill                                                                                                                                                                                                                                                                2000  B                         500
+         1000                   999        9000              4  C        7               80  bill                                                                                                                                                                                                                                                                2000  B                         500
+         2000              -1000000        8000              5  Q        sue           2000  bill                                                                                                                                                                                                                                                                2000  B                         500
+         4000                     0        5000              8  Z        johnny        8000  bill                                                                                                                                                                                                                                                                2000  B                         500
+         8000                  1000       10000              3  B        9               90  bill                                                                                                                                                                                                                                                                2000  B                         500
+        -5000                   200        8000              6  D        michael         90  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+           50            1000000000       10000              1  C        walter          10  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+           60                 -1000        8000              2  A        bobby         1000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+         1000                   999        9000              4  C        7               80  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+         2000              -1000000        8000              5  Q        sue           2000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+         4000                     0        5000              8  Z        johnny        8000  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+         8000                  1000       10000              3  B        9               90  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+        -5000                   200        8000              6  D        michael         90  william                                                                                                                                                                                                                                                             1000  black                    2000
+           50            1000000000       10000              1  C        walter          10  william                                                                                                                                                                                                                                                             1000  black                    2000
+           60                 -1000        8000              2  A        bobby         1000  william                                                                                                                                                                                                                                                             1000  black                    2000
+         1000                   999        9000              4  C        7               80  william                                                                                                                                                                                                                                                             1000  black                    2000
+         2000              -1000000        8000              5  Q        sue           2000  william                                                                                                                                                                                                                                                             1000  black                    2000
+         4000                     0        5000              8  Z        johnny        8000  william                                                                                                                                                                                                                                                             1000  black                    2000
+         8000                  1000       10000              3  B        9               90  william                                                                                                                                                                                                                                                             1000  black                    2000
+        -5000                   200        8000              6  D        michael         90  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+           50            1000000000       10000              1  C        walter          10  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+           60                 -1000        8000              2  A        bobby         1000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+         1000                   999        9000              4  C        7               80  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+         2000              -1000000        8000              5  Q        sue           2000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+         4000                     0        5000              8  Z        johnny        8000  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+         8000                  1000       10000              3  B        9               90  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 
 --- 43 row(s) selected.
 >>-- <ufi-input>
@@ -162,33 +162,33 @@ BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7
 BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7  SMALL_INT  NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
 -------------  --------------------  ----------  -------------  -------  -------  ---------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------
 
-         4000                     0        5000              8  Z        johnny        8000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-         3000                  2000        1000              7  E        jimmy         9000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-         2000              -1000000        8000              5  Q        sue           2000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-         1000                   999        9000              4  C        7               80          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-           60                 -1000        8000              2  A        bobby         1000          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-           50            1000000000       10000              1  C        walter          10          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-        -5000                   200        8000              6  D        michael         90          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         8000                  1000       10000              3  B        9               90          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         4000                     0        5000              8  Z        johnny        8000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         3000                  2000        1000              7  E        jimmy         9000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-           50            1000000000       10000              1  C        walter          10          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        -5000                   200        8000              6  D        michael         90          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         8000                  1000       10000              3  B        9               90          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         4000                     0        5000              8  Z        johnny        8000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         3000                  2000        1000              7  E        jimmy         9000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-           60                 -1000        8000              2  A        bobby         1000          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-           50            1000000000       10000              1  C        walter          10          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        -5000                   200        8000              6  D        michael         90          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-         8000                  1000       10000              3  B        9               90          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-         4000                     0        5000              8  Z        johnny        8000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-         3000                  2000        1000              7  E        jimmy         9000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-         2000              -1000000        8000              5  Q        sue           2000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-           60                 -1000        8000              2  A        bobby         1000          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-           50            1000000000       10000              1  C        walter          10          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
+        -5000                   200        8000              6  D        michael         90          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200
+        -5000                   200        8000              6  D        michael         90          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200
+        -5000                   200        8000              6  D        michael         90          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                                                                                2000  B                         500
+           50            1000000000       10000              1  C        walter          10          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                         300
+           50            1000000000       10000              1  C        walter          10          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200
+           50            1000000000       10000              1  C        walter          10          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200
+           50            1000000000       10000              1  C        walter          10          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                                                                                2000  B                         500
+           60                 -1000        8000              2  A        bobby         1000          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                         300
+           60                 -1000        8000              2  A        bobby         1000          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200
+           60                 -1000        8000              2  A        bobby         1000          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200
+           60                 -1000        8000              2  A        bobby         1000          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                                                                                2000  B                         500
+         1000                   999        9000              4  C        7               80          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                         300
+         2000              -1000000        8000              5  Q        sue           2000          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                         300
+         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         2000              -1000000        8000              5  Q        sue           2000          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         2000              -1000000        8000              5  Q        sue           2000          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                                                                                2000  B                         500
+         3000                  2000        1000              7  E        jimmy         9000          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                         300
+         3000                  2000        1000              7  E        jimmy         9000          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         3000                  2000        1000              7  E        jimmy         9000          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         3000                  2000        1000              7  E        jimmy         9000          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                                                                                2000  B                         500
+         4000                     0        5000              8  Z        johnny        8000          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                         300
+         4000                     0        5000              8  Z        johnny        8000          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         4000                     0        5000              8  Z        johnny        8000          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         4000                     0        5000              8  Z        johnny        8000          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                                                                                2000  B                         500
+         8000                  1000       10000              3  B        9               90          80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         8000                  1000       10000              3  B        9               90          80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200
+         8000                  1000       10000              3  B        9               90          80         6.00  B            3348008712604978694  bill                                                                                                                                                                                                                                                                2000  B                         500
 
 --- 27 row(s) selected.
 >>-- <ufi-input>
@@ -199,19 +199,19 @@ BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7
 NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            COL_1   COL_2                 COL_3       COL_4  COL_5  COL_6    COL_7   COL_8
 ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ------  --------------------  ----------  -----  -----  -------  ------  -------
 
-        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300      50            1000000000       10000      1  C      walter       10  A      
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  7      
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  7      
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    4000                     0        5000      8  Z      johnny     8000  7      
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    4000                     0        5000      8  Z      johnny     8000  7      
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      
+        90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                         300      50            1000000000       10000      1  C      walter       10  A      
+        80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
+        80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  7      
+        80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
+        80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      
+        80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200    4000                     0        5000      8  Z      johnny     8000  7      
+        80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      
+        80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200      60                 -1000        8000      2  A      bobby      1000  7      
+        80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200    2000              -1000000        8000      5  Q      sue        2000  7      
+        80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200   -5000                   200        8000      6  D      michael      90  7      
+        80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200    8000                  1000       10000      3  B      9            90  7      
+        80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200    4000                     0        5000      8  Z      johnny     8000  7      
+        80         6.00  7            3348008712604972182  tom                                                                                                                                                                                                                                                                 1000  7                         200    3000                  2000        1000      7  E      jimmy      9000  7      
 
 --- 13 row(s) selected.
 >>-- <ufi-input>
@@ -254,16 +254,16 @@ BINARY_SIGNED  LARGE_INT             MEDIUM_INT  PIC_DECIMAL_3  PIC_X_1  PIC_X_7
 NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1            NEW_NAME_1  NEW_NAME_2   NEW_NAME_3  NEW_NAME_4            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
 ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------  ----------  -----------  ----------  --------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------
 
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-        80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-        80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
-        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300          80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500
-        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  7             216172782159534338  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          80         6.00  7             216172782159534342  tom                                                                                                                                                                                                                                                                 1000  7                         200
-        80         6.00  B             216172782159534343  bill                                                                                                                                                                                                                                                                2000  B                         500          90         5.00  A             216172782159534337  bob                                                                                                                                                                                                                                                                  999  A                         300
+        80         6.00  7            3348008712604933890  tom                                                                                                                                                                                                                                                                 1000  7                         200          90         5.00  A            3348008712604909660  bob                                                                                                                                                                                                                                                                  999  A                        

<TRUNCATED>


Mime
View raw message