trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ansha...@apache.org
Subject [06/12] incubator-trafodion git commit: JIRA TRAFODION-2834 Streamline supported xn access modes
Date Wed, 13 Dec 2017 19:02:28 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml05
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml05 b/core/sql/regress/qat/eqatdml05
index a19f706..328d2c9 100755
--- a/core/sql/regress/qat/eqatdml05
+++ b/core/sql/regress/qat/eqatdml05
@@ -29,7 +29,7 @@
 >>--       A2: select SYSKEY
 >>--       A3: select *
 >>--       A4: select expressions of columns
->>--       A5: use of for browse access,for stable access,for repeatable access
+>>--       A5: use of for read committed access,for read committed access,for read committed access
 >>--       A6: select aggregate functions
 >>
 >>-- All testcases are documented further below.
@@ -67,69 +67,69 @@ BINARY_32_U  BINARY_32_U
 -----------  -----------
 
       90.00         5.00
-      90.00        70.00
       90.00         6.00
       90.00         6.00
-      90.00        50.00
       90.00      1000.00
+      90.00        50.00
       90.00         6.00
       90.00         6.00
+      90.00        70.00
       50.00         5.00
-      50.00        70.00
       50.00         6.00
       50.00         6.00
-      50.00        50.00
       50.00      1000.00
+      50.00        50.00
       50.00         6.00
       50.00         6.00
+      50.00        70.00
       60.00         5.00
-      60.00        70.00
       60.00         6.00
       60.00         6.00
-      60.00        50.00
       60.00      1000.00
+      60.00        50.00
       60.00         6.00
       60.00         6.00
+      60.00        70.00
       80.00         5.00
-      80.00        70.00
       80.00         6.00
       80.00         6.00
-      80.00        50.00
       80.00      1000.00
+      80.00        50.00
       80.00         6.00
       80.00         6.00
+      80.00        70.00
       90.00         5.00
-      90.00        70.00
       90.00         6.00
       90.00         6.00
-      90.00        50.00
       90.00      1000.00
+      90.00        50.00
       90.00         6.00
       90.00         6.00
+      90.00        70.00
       80.00         5.00
-      80.00        70.00
       80.00         6.00
       80.00         6.00
-      80.00        50.00
       80.00      1000.00
+      80.00        50.00
       80.00         6.00
       80.00         6.00
+      80.00        70.00
       40.00         5.00
-      40.00        70.00
       40.00         6.00
       40.00         6.00
-      40.00        50.00
       40.00      1000.00
+      40.00        50.00
       40.00         6.00
       40.00         6.00
+      40.00        70.00
       70.00         5.00
-      70.00        70.00
       70.00         6.00
       70.00         6.00
-      70.00        50.00
       70.00      1000.00
+      70.00        50.00
       70.00         6.00
       70.00         6.00
+      70.00        70.00
 
 --- 64 row(s) selected.
 >>--    <ufi-input>
@@ -140,69 +140,69 @@ VAR_CHAR
 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------
 
 thomas                                                                                                                                                                                                                                                              90
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                             100
+thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
+thomas                                                                                                                                                                                                                                                              50
 B                                                                                                                                                                                                                                                                   90
-B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
-B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                  100
+B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
-B                                                                                                                                                                                                                                                                   90
 B                                                                                                                                                                                                                                                                   50
+B                                                                                                                                                                                                                                                                   90
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
-B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                  100
+B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
+B                                                                                                                                                                                                                                                                   50
 jimmy                                                                                                                                                                                                                                                               90
-jimmy                                                                                                                                                                                                                                                               50
 jimmy                                                                                                                                                                                                                                                               80
 jimmy                                                                                                                                                                                                                                                               80
-jimmy                                                                                                                                                                                                                                                               50
 jimmy                                                                                                                                                                                                                                                              100
+jimmy                                                                                                                                                                                                                                                               50
 jimmy                                                                                                                                                                                                                                                               80
 jimmy                                                                                                                                                                                                                                                               80
+jimmy                                                                                                                                                                                                                                                               50
 christopher                                                                                                                                                                                                                                                         90
-christopher                                                                                                                                                                                                                                                         50
 christopher                                                                                                                                                                                                                                                         80
 christopher                                                                                                                                                                                                                                                         80
-christopher                                                                                                                                                                                                                                                         50
 christopher                                                                                                                                                                                                                                                        100
+christopher                                                                                                                                                                                                                                                         50
 christopher                                                                                                                                                                                                                                                         80
 christopher                                                                                                                                                                                                                                                         80
+christopher                                                                                                                                                                                                                                                         50
 marilyn                                                                                                                                                                                                                                                             90
-marilyn                                                                                                                                                                                                                                                             50
 marilyn                                                                                                                                                                                                                                                             80
 marilyn                                                                                                                                                                                                                                                             80
-marilyn                                                                                                                                                                                                                                                             50
 marilyn                                                                                                                                                                                                                                                            100
+marilyn                                                                                                                                                                                                                                                             50
 marilyn                                                                                                                                                                                                                                                             80
 marilyn                                                                                                                                                                                                                                                             80
+marilyn                                                                                                                                                                                                                                                             50
 thomas                                                                                                                                                                                                                                                              90
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                             100
+thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              90
 thomas                                                                                                                                                                                                                                                              50
+thomas                                                                                                                                                                                                                                                              90
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                             100
+thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
+thomas                                                                                                                                                                                                                                                              50
 
 --- 64 row(s) selected.
 >>--    <ufi-input>
@@ -213,69 +213,69 @@ VAR_CHAR
 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -------
 
 thomas                                                                                                                                                                                                                                                              90
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                             100
+thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
+thomas                                                                                                                                                                                                                                                              50
 B                                                                                                                                                                                                                                                                   90
-B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
-B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                  100
+B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
-B                                                                                                                                                                                                                                                                   90
 B                                                                                                                                                                                                                                                                   50
+B                                                                                                                                                                                                                                                                   90
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
-B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                  100
+B                                                                                                                                                                                                                                                                   50
 B                                                                                                                                                                                                                                                                   80
 B                                                                                                                                                                                                                                                                   80
+B                                                                                                                                                                                                                                                                   50
 jimmy                                                                                                                                                                                                                                                               90
-jimmy                                                                                                                                                                                                                                                               50
 jimmy                                                                                                                                                                                                                                                               80
 jimmy                                                                                                                                                                                                                                                               80
-jimmy                                                                                                                                                                                                                                                               50
 jimmy                                                                                                                                                                                                                                                              100
+jimmy                                                                                                                                                                                                                                                               50
 jimmy                                                                                                                                                                                                                                                               80
 jimmy                                                                                                                                                                                                                                                               80
+jimmy                                                                                                                                                                                                                                                               50
 christopher                                                                                                                                                                                                                                                         90
-christopher                                                                                                                                                                                                                                                         50
 christopher                                                                                                                                                                                                                                                         80
 christopher                                                                                                                                                                                                                                                         80
-christopher                                                                                                                                                                                                                                                         50
 christopher                                                                                                                                                                                                                                                        100
+christopher                                                                                                                                                                                                                                                         50
 christopher                                                                                                                                                                                                                                                         80
 christopher                                                                                                                                                                                                                                                         80
+christopher                                                                                                                                                                                                                                                         50
 marilyn                                                                                                                                                                                                                                                             90
-marilyn                                                                                                                                                                                                                                                             50
 marilyn                                                                                                                                                                                                                                                             80
 marilyn                                                                                                                                                                                                                                                             80
-marilyn                                                                                                                                                                                                                                                             50
 marilyn                                                                                                                                                                                                                                                            100
+marilyn                                                                                                                                                                                                                                                             50
 marilyn                                                                                                                                                                                                                                                             80
 marilyn                                                                                                                                                                                                                                                             80
+marilyn                                                                                                                                                                                                                                                             50
 thomas                                                                                                                                                                                                                                                              90
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                             100
+thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              90
 thomas                                                                                                                                                                                                                                                              50
+thomas                                                                                                                                                                                                                                                              90
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
-thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                             100
+thomas                                                                                                                                                                                                                                                              50
 thomas                                                                                                                                                                                                                                                              80
 thomas                                                                                                                                                                                                                                                              80
+thomas                                                                                                                                                                                                                                                              50
 
 --- 64 row(s) selected.
 >>--    <ufi-input>
@@ -286,70 +286,70 @@ thomas
 MEDIUM_INT  LARGE_INT             MEDIUM_INT  BINARY_SIGNED
 ----------  --------------------  ----------  -------------
 
-      8000                   200        8000          -5000
+      8000                   200        8000             60
       8000                   200       10000           8000
-      8000                   200        5000           4000
+      8000                   200       10000             50
+      8000                   200        9000           1000
+      8000                   200        8000          -5000
       8000                   200        1000           3000
       8000                   200        8000           2000
-      8000                   200        9000           1000
-      8000                   200        8000             60
-      8000                   200       10000             50
-     10000            1000000000        8000          -5000
+      8000                   200        5000           4000
+     10000            1000000000        8000             60
      10000            1000000000       10000           8000
-     10000            1000000000        5000           4000
+     10000            1000000000       10000             50
+     10000            1000000000        9000           1000
+     10000            1000000000        8000          -5000
      10000            1000000000        1000           3000
      10000            1000000000        8000           2000
-     10000            1000000000        9000           1000
-     10000            1000000000        8000             60
-     10000            1000000000       10000             50
-      8000                 -1000        8000          -5000
+     10000            1000000000        5000           4000
+      8000                 -1000        8000             60
       8000                 -1000       10000           8000
-      8000                 -1000        5000           4000
+      8000                 -1000       10000             50
+      8000                 -1000        9000           1000
+      8000                 -1000        8000          -5000
       8000                 -1000        1000           3000
       8000                 -1000        8000           2000
-      8000                 -1000        9000           1000
-      8000                 -1000        8000             60
-      8000                 -1000       10000             50
-      9000                   999        8000          -5000
+      8000                 -1000        5000           4000
+      9000                   999        8000             60
       9000                   999       10000           8000
-      9000                   999        5000           4000
+      9000                   999       10000             50
+      9000                   999        9000           1000
+      9000                   999        8000          -5000
       9000                   999        1000           3000
       9000                   999        8000           2000
-      9000                   999        9000           1000
-      9000                   999        8000             60
-      9000                   999       10000             50
-      8000              -1000000        8000          -5000
+      9000                   999        5000           4000
+      8000              -1000000        8000             60
       8000              -1000000       10000           8000
-      8000              -1000000        5000           4000
+      8000              -1000000       10000             50
+      8000              -1000000        9000           1000
+      8000              -1000000        8000          -5000
       8000              -1000000        1000           3000
       8000              -1000000        8000           2000
-      8000              -1000000        9000           1000
-      8000              -1000000        8000             60
-      8000              -1000000       10000             50
-      1000                  2000        8000          -5000
+      8000              -1000000        5000           4000
+      1000                  2000        8000             60
       1000                  2000       10000           8000
-      1000                  2000        5000           4000
+      1000                  2000       10000             50
+      1000                  2000        9000           1000
+      1000                  2000        8000          -5000
       1000                  2000        1000           3000
       1000                  2000        8000           2000
-      1000                  2000        9000           1000
-      1000                  2000        8000             60
-      1000                  2000       10000             50
-      5000                     0        8000          -5000
+      1000                  2000        5000           4000
+      5000                     0        8000             60
       5000                     0       10000           8000
-      5000                     0        5000           4000
+      5000                     0       10000             50
+      5000                     0        9000           1000
+      5000                     0        8000          -5000
       5000                     0        1000           3000
       5000                     0        8000           2000
-      5000                     0        9000           1000
-      5000                     0        8000             60
-      5000                     0       10000             50
-     10000                  1000        8000          -5000
+      5000                     0        5000           4000
+     10000                  1000        8000             60
      10000                  1000       10000           8000
-     10000                  1000        5000           4000
+     10000                  1000       10000             50
+     10000                  1000        9000           1000
+     10000                  1000        8000          -5000
      10000                  1000        1000           3000
      10000                  1000        8000           2000
-     10000                  1000        9000           1000
-     10000                  1000        8000             60
-     10000                  1000       10000             50
+     10000                  1000        5000           4000
 
 --- 64 row(s) selected.
 >>--    <ufi-input>
@@ -360,37 +360,37 @@ MEDIUM_INT  NEW_NAME_1
 ----------  ----------
 
       8000          90
-      8000          80
-      8000          80
-      8000          80
      10000          90
+     10000          90
+      9000          90
+      8000          90
+      1000          90
+      8000          90
+      5000          90
+      8000          80
      10000          80
      10000          80
-     10000          80
-      8000          90
+      9000          80
       8000          80
+      1000          80
       8000          80
+      5000          80
       8000          80
-      9000          90
-      9000          80
-      9000          80
+     10000          80
+     10000          80
       9000          80
-      8000          90
-      8000          80
       8000          80
-      8000          80
-      1000          90
       1000          80
-      1000          80
-      1000          80
-      5000          90
-      5000          80
-      5000          80
+      8000          80
       5000          80
-     10000          90
-     10000          80
+      8000          80
      10000          80
      10000          80
+      9000          80
+      8000          80
+      1000          80
+      8000          80
+      5000          80
 
 --- 32 row(s) selected.
 >>--    <ufi-input>
@@ -401,37 +401,37 @@ MEDIUM_INT  NEW_NAME_1
 ----------  ----------
 
       8000          90
-      8000          80
-      8000          80
-      8000          80
      10000          90
+     10000          90
+      9000          90
+      8000          90
+      1000          90
+      8000          90
+      5000          90
+      8000          80
      10000          80
      10000          80
-     10000          80
-      8000          90
+      9000          80
       8000          80
+      1000          80
       8000          80
+      5000          80
       8000          80
-      9000          90
-      9000          80
-      9000          80
+     10000          80
+     10000          80
       9000          80
-      8000          90
-      8000          80
       8000          80
-      8000          80
-      1000          90
-      1000          80
-      1000          80
       1000          80
-      5000          90
-      5000          80
-      5000          80
+      8000          80
       5000          80
-     10000          90
-     10000          80
+      8000          80
      10000          80
      10000          80
+      9000          80
+      8000          80
+      1000          80
+      8000          80
+      5000          80
 
 --- 32 row(s) selected.
 >>--    <ufi-input>
@@ -441,38 +441,38 @@ MEDIUM_INT  NEW_NAME_1
 PIC_X_7  PIC_X_7
 -------  -------
 
-michael  A      
-9        A      
-johnny   A      
-jimmy    A      
-sue      A      
-7        A      
-bobby    A      
-walter   A      
-michael  7      
+walter   7      
+bobby    7      
 9        7      
-johnny   7      
-jimmy    7      
-sue      7      
 7        7      
-bobby    7      
-walter   7      
+sue      7      
 michael  7      
-9        7      
-johnny   7      
 jimmy    7      
-sue      7      
-7        7      
-bobby    7      
+johnny   7      
 walter   7      
-michael  B      
+bobby    7      
+9        7      
+7        7      
+sue      7      
+michael  7      
+jimmy    7      
+johnny   7      
+walter   A      
+bobby    A      
+9        A      
+7        A      
+sue      A      
+michael  A      
+jimmy    A      
+johnny   A      
+walter   B      
+bobby    B      
 9        B      
-johnny   B      
-jimmy    B      
-sue      B      
 7        B      
-bobby    B      
-walter   B      
+sue      B      
+michael  B      
+jimmy    B      
+johnny   B      
 
 --- 32 row(s) selected.
 >>--    <ufi-input>
@@ -483,37 +483,37 @@ DECIMAL_1  NEW_NAME_1
 ---------  ----------
 
         7          90
-        7          90
-        9          90
-        8          90
-        1          90
+        4          90
         5          90
         5          90
-        4          90
-        7          80
+        1          90
+        8          90
+        9          90
+        7          90
         7          80
-        9          80
-        8          80
-        1          80
+        4          80
         5          80
         5          80
-        4          80
+        1          80
+        8          80
+        9          80
         7          80
         7          80
-        9          80
-        8          80
-        1          80
+        4          80
         5          80
         5          80
-        4          80
+        1          80
+        8          80
+        9          80
         7          80
         7          80
-        9          80
-        8          80
-        1          80
+        4          80
         5          80
         5          80
-        4          80
+        1          80
+        8          80
+        9          80
+        7          80
 
 --- 32 row(s) selected.
 >>--    <ufi-input>
@@ -524,37 +524,37 @@ DECIMAL_1  NEW_NAME_1
 ---------  ----------
 
         7          90
-        7          90
-        9          90
-        8          90
-        1          90
+        4          90
         5          90
         5          90
-        4          90
-        7          80
+        1          90
+        8          90
+        9          90
+        7          90
         7          80
-        9          80
-        8          80
-        1          80
+        4          80
         5          80
         5          80
-        4          80
+        1          80
+        8          80
+        9          80
         7          80
         7          80
-        9          80
-        8          80
-        1          80
+        4          80
         5          80
         5          80
-        4          80
+        1          80
+        8          80
+        9          80
         7          80
         7          80
-        9          80
-        8          80
-        1          80
+        4          80
         5          80
         5          80
-        4          80
+        1          80
+        8          80
+        9          80
+        7          80
 
 --- 32 row(s) selected.
 >>--    <ufi-input>
@@ -565,53 +565,53 @@ MEDIUM_INT  PIC_X_7
 ----------  -------
 
       8000  7      
-      8000  green  
-      8000  black  
-      8000  white  
-      8000  B      
       8000  A      
+      8000  B      
+      8000  white  
+      8000  black  
+      8000  green  
      10000  7      
-     10000  green  
-     10000  black  
-     10000  white  
+     10000  A      
      10000  B      
+     10000  white  
+     10000  black  
+     10000  green  
+     10000  7      
      10000  A      
-      8000  7      
-      8000  green  
-      8000  black  
-      8000  white  
-      8000  B      
-      8000  A      
+     10000  B      
+     10000  white  
+     10000  black  
+     10000  green  
       9000  7      
-      9000  green  
-      9000  black  
-      9000  white  
-      9000  B      
       9000  A      
+      9000  B      
+      9000  white  
+      9000  black  
+      9000  green  
       8000  7      
-      8000  green  
-      8000  black  
-      8000  white  
-      8000  B      
       8000  A      
+      8000  B      
+      8000  white  
+      8000  black  
+      8000  green  
       1000  7      
-      1000  green  
-      1000  black  
-      1000  white  
-      1000  B      
       1000  A      
+      1000  B      
+      1000  white  
+      1000  black  
+      1000  green  
+      8000  7      
+      8000  A      
+      8000  B      
+      8000  white  
+      8000  black  
+      8000  green  
       5000  7      
-      5000  green  
-      5000  black  
-      5000  white  
-      5000  B      
       5000  A      
-     10000  7      
-     10000  green  
-     10000  black  
-     10000  white  
-     10000  B      
-     10000  A      
+      5000  B      
+      5000  white  
+      5000  black  
+      5000  green  
 
 --- 48 row(s) selected.
 >>--    <ufi-input>
@@ -621,54 +621,54 @@ MEDIUM_INT  PIC_X_7
 BINARY_SIGNED  VAR_CHAR
 -------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
-           60  tom                                                                                                                                                                                                                                                        
-         4000  tom                                                                                                                                                                                                                                                        
-         2000  tom                                                                                                                                                                                                                                                        
-         3000  tom                                                                                                                                                                                                                                                        
-        -5000  tom                                                                                                                                                                                                                                                        
-         1000  tom                                                                                                                                                                                                                                                        
-           50  tom                                                                                                                                                                                                                                                        
-         8000  tom                                                                                                                                                                                                                                                        
-           60  bob                                                                                                                                                                                                                                                        
-         4000  bob                                                                                                                                                                                                                                                        
-         2000  bob                                                                                                                                                                                                                                                        
-         3000  bob                                                                                                                                                                                                                                                        
-        -5000  bob                                                                                                                                                                                                                                                        
-         1000  bob                                                                                                                                                                                                                                                        
-           50  bob                                                                                                                                                                                                                                                        
-         8000  bob                                                                                                                                                                                                                                                        
-           60  bill                                                                                                                                                                                                                                                       
          4000  bill                                                                                                                                                                                                                                                       
-         2000  bill                                                                                                                                                                                                                                                       
          3000  bill                                                                                                                                                                                                                                                       
         -5000  bill                                                                                                                                                                                                                                                       
-         1000  bill                                                                                                                                                                                                                                                       
            50  bill                                                                                                                                                                                                                                                       
+           60  bill                                                                                                                                                                                                                                                       
          8000  bill                                                                                                                                                                                                                                                       
-           60  christopher                                                                                                                                                                                                                                                
+         1000  bill                                                                                                                                                                                                                                                       
+         2000  bill                                                                                                                                                                                                                                                       
+         4000  bob                                                                                                                                                                                                                                                        
+         3000  bob                                                                                                                                                                                                                                                        
+        -5000  bob                                                                                                                                                                                                                                                        
+           50  bob                                                                                                                                                                                                                                                        
+           60  bob                                                                                                                                                                                                                                                        
+         8000  bob                                                                                                                                                                                                                                                        
+         1000  bob                                                                                                                                                                                                                                                        
+         2000  bob                                                                                                                                                                                                                                                        
          4000  christopher                                                                                                                                                                                                                                                
-         2000  christopher                                                                                                                                                                                                                                                
          3000  christopher                                                                                                                                                                                                                                                
         -5000  christopher                                                                                                                                                                                                                                                
-         1000  christopher                                                                                                                                                                                                                                                
            50  christopher                                                                                                                                                                                                                                                
+           60  christopher                                                                                                                                                                                                                                                
          8000  christopher                                                                                                                                                                                                                                                
-           60  william                                                                                                                                                                                                                                                    
-         4000  william                                                                                                                                                                                                                                                    
-         2000  william                                                                                                                                                                                                                                                    
-         3000  william                                                                                                                                                                                                                                                    
-        -5000  william                                                                                                                                                                                                                                                    
-         1000  william                                                                                                                                                                                                                                                    
-           50  william                                                                                                                                                                                                                                                    
-         8000  william                                                                                                                                                                                                                                                    
-           60  marilyn                                                                                                                                                                                                                                                    
+         1000  christopher                                                                                                                                                                                                                                                
+         2000  christopher                                                                                                                                                                                                                                                
          4000  marilyn                                                                                                                                                                                                                                                    
-         2000  marilyn                                                                                                                                                                                                                                                    
          3000  marilyn                                                                                                                                                                                                                                                    
         -5000  marilyn                                                                                                                                                                                                                                                    
-         1000  marilyn                                                                                                                                                                                                                                                    
            50  marilyn                                                                                                                                                                                                                                                    
+           60  marilyn                                                                                                                                                                                                                                                    
          8000  marilyn                                                                                                                                                                                                                                                    
+         1000  marilyn                                                                                                                                                                                                                                                    
+         2000  marilyn                                                                                                                                                                                                                                                    
+         4000  tom                                                                                                                                                                                                                                                        
+         3000  tom                                                                                                                                                                                                                                                        
+        -5000  tom                                                                                                                                                                                                                                                        
+           50  tom                                                                                                                                                                                                                                                        
+           60  tom                                                                                                                                                                                                                                                        
+         8000  tom                                                                                                                                                                                                                                                        
+         1000  tom                                                                                                                                                                                                                                                        
+         2000  tom                                                                                                                                                                                                                                                        
+         4000  william                                                                                                                                                                                                                                                    
+         3000  william                                                                                                                                                                                                                                                    
+        -5000  william                                                                                                                                                                                                                                                    
+           50  william                                                                                                                                                                                                                                                    
+           60  william                                                                                                                                                                                                                                                    
+         8000  william                                                                                                                                                                                                                                                    
+         1000  william                                                                                                                                                                                                                                                    
+         2000  william                                                                                                                                                                                                                                                    
 
 --- 48 row(s) selected.
 >>--    <ufi-input>
@@ -678,54 +678,54 @@ BINARY_SIGNED  VAR_CHAR
 BINARY_SIGNED  VAR_CHAR
 -------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 
-           60  tom                                                                                                                                                                                                                                                        
-         4000  tom                                                                                                                                                                                                                                                        
-         2000  tom                                                                                                                                                                                                                                                        
-         3000  tom                                                                                                                                                                                                                                                        
-        -5000  tom                                                                                                                                                                                                                                                        
-         1000  tom                                                                                                                                                                                                                                                        
-           50  tom                                                                                                                                                                                                                                                        
-         8000  tom                                                                                                                                                                                                                                                        
-           60  bob                                                                                                                                                                                                                                                        
-         4000  bob                                                                                                                                                                                                                                                        
-         2000  bob                                                                                                                                                                                                                                                        
-         3000  bob                                                                                                                                                                                                                                                        
-        -5000  bob                                                                                                                                                                                                                                                        
-         1000  bob                                                                                                                                                                                                                                                        
-           50  bob                                                                                                                                                                                                                                                        
-         8000  bob                                                                                                                                                                                                                                                        
-           60  bill                                                                                                                                                                                                                                                       
          4000  bill                                                                                                                                                                                                                                                       
-         2000  bill                                                                                                                                                                                                                                                       
          3000  bill                                                                                                                                                                                                                                                       
         -5000  bill                                                                                                                                                                                                                                                       
-         1000  bill                                                                                                                                                                                                                                                       
            50  bill                                                                                                                                                                                                                                                       
+           60  bill                                                                                                                                                                                                               

<TRUNCATED>


Mime
View raw message