trafodion-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ansha...@apache.org
Subject [04/12] incubator-trafodion git commit: JIRA TRAFODION-2834 Streamline supported xn access modes
Date Wed, 13 Dec 2017 19:02:26 GMT
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml07
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml07 b/core/sql/regress/qat/eqatdml07
index 961136e..9412633 100755
--- a/core/sql/regress/qat/eqatdml07
+++ b/core/sql/regress/qat/eqatdml07
@@ -25,8 +25,8 @@
 >>--       A1: HAVING
 >>--       A2: ORDER BY
 >>--       A3: complex queries - combinations of all features
->>--       A4: use of locking clauses (for stable access, for browse access,
->>--           for repeatable access) with above clauses
+>>--       A4: use of locking clauses (for read committed access, for read committed access,
+>>--           for read committed access) with above clauses
 >>--       A5: SELECT aggregate functions with GROUP BY
 >>--       A6: SELECT aggregate functions with aggregates in HAVING clause
 >>--           and complex queries with aggregates
@@ -63,10 +63,10 @@
 PIC_9_7
 -------
 
-     50
-     80
      90
+     80
     100
+     50
 
 --- 4 row(s) selected.
 >>
@@ -78,9 +78,9 @@ PIC_9_7
 MEDIUM_INT 
 -----------
 
-        200
-        999
        1000
+        999
+        200
        2000
 
 --- 4 row(s) selected.
@@ -110,12 +110,12 @@ MEDIUM_INT
 PIC_9_7  PIC_X_7
 -------  -------
 
-    100  5      
+     90  A      
      80  7      
      80  8      
-     90  A      
-     80  B      
+    100  5      
      50  michael
+     80  B      
 
 --- 6 row(s) selected.
 >>-- <ufi-input>
@@ -127,21 +127,21 @@ PIC_9_7  MEDIUM_INT
 -------  -----------
 
      90         1000
-     90         2000
-     90          200
      90          999
+     90          200
+     90         2000
      80         1000
-     80         2000
-     80          200
      80          999
+     80          200
+     80         2000
     100         1000
-    100         2000
-    100          200
     100          999
+    100          200
+    100         2000
      50         1000
-     50         2000
-     50          200
      50          999
+     50          200
+     50         2000
 
 --- 16 row(s) selected.
 >>-- <ufi-input>
@@ -153,53 +153,53 @@ PIC_X_1  PIC_9_7  MEDIUM_INT
 -------  -------  -----------
 
 B             90         1000
-B             90         2000
-B             90          200
-B             90          999
-Q             90         1000
-Q             90         2000
-Q             90          200
-Q             90          999
-C             90         1000
-C             90         2000
-C             90          200
-C             90          999
 B             80         1000
-B             80         2000
-B             80          200
-B             80          999
-Q             80         1000
-Q             80         2000
-Q             80          200
-Q             80          999
-C             80         1000
-C             80         2000
-C             80          200
-C             80          999
 B            100         1000
-B            100         2000
-B            100          200
-B            100          999
-Q            100         1000
-Q            100         2000
-Q            100          200
-Q            100          999
+B             50         1000
+C             90         1000
+C             80         1000
 C            100         1000
-C            100         2000
-C            100          200
+C             50         1000
+Q             90         1000
+Q             80         1000
+Q            100         1000
+Q             50         1000
+B             90          999
+B             80          999
+B            100          999
+B             50          999
+C             90          999
+C             80          999
 C            100          999
-B             50         1000
-B             50         2000
+C             50          999
+Q             90          999
+Q             80          999
+Q            100          999
+Q             50          999
+B             90          200
+B             80          200
+B            100          200
 B             50          200
-B             50          999
-Q             50         1000
-Q             50         2000
+C             90          200
+C             80          200
+C            100          200
+C             50          200
+Q             90          200
+Q             80          200
+Q            100          200
 Q             50          200
-Q             50          999
-C             50         1000
+B             90         2000
+B             80         2000
+B            100         2000
+B             50         2000
+C             90         2000
+C             80         2000
+C            100         2000
 C             50         2000
-C             50          200
-C             50          999
+Q             90         2000
+Q             80         2000
+Q            100         2000
+Q             50         2000
 
 --- 48 row(s) selected.
 >>-- <ufi-input>
@@ -211,16 +211,16 @@ DECIMAL_1  NEW_NAME_1
 ---------  ----------
 
         7          90
-        7          80
         4          90
-        4          80
         5          90
-        5          80
         1          90
-        1          80
         8          90
-        8          80
         9          90
+        7          80
+        4          80
+        5          80
+        1          80
+        8          80
         9          80
 
 --- 12 row(s) selected.
@@ -232,18 +232,18 @@ DECIMAL_1  NEW_NAME_1
 DECIMAL_1  NEW_NAME_1
 ---------  ----------
 
-        7          80
-        9          80
-        8          80
-        1          80
-        5          80
-        4          80
         7          90
-        9          90
-        8          90
-        1          90
-        5          90
         4          90
+        5          90
+        1          90
+        8          90
+        9          90
+        7          80
+        4          80
+        5          80
+        1          80
+        8          80
+        9          80
 
 --- 12 row(s) selected.
 >>-- <ufi-input>
@@ -255,20 +255,20 @@ MEDIUM_INT  MEDIUM_INT
 ----------  -----------
 
       8000         1000
-      8000         2000
       8000          999
+      8000         2000
      10000         1000
-     10000         2000
      10000          999
+     10000         2000
       9000         1000
-      9000         2000
       9000          999
+      9000         2000
       1000         1000
-      1000         2000
       1000          999
+      1000         2000
       5000         1000
-      5000         2000
       5000          999
+      5000         2000
 
 --- 15 row(s) selected.
 >>-- <ufi-input>
@@ -295,20 +295,20 @@ NEW_NAME_3  COL_3
 ----------  ----------
 
 7                10000
-B                10000
-A                10000
 7                 8000
-B                 8000
-A                 8000
 7                 9000
-B                 9000
-A                 9000
-7                 1000
 7                 5000
-B                 1000
-B                 5000
-A                 1000
+7                 1000
+A                10000
+A                 8000
+A                 9000
 A                 5000
+A                 1000
+B                10000
+B                 8000
+B                 9000
+B                 5000
+B                 1000
 
 --- 15 row(s) selected.
 >>-- <ufi-input>
@@ -319,26 +319,26 @@ A                 5000
 CHAR_1  MEDIUM_INT
 ------  ----------
 
+A             8000
 D             8000
 C             8000
 E             8000
-A             8000
+A            10000
 D            10000
 C            10000
 E            10000
-A            10000
+A             9000
 D             9000
 C             9000
 E             9000
-A             9000
+A             1000
 D             1000
 C             1000
 E             1000
-A             1000
+A             5000
 D             5000
 C             5000
 E             5000
-A             5000
 
 --- 20 row(s) selected.
 >>-- <ufi-input>
@@ -364,8 +364,8 @@ MEDIUM_INT
 NEW_NAME_1  NEW_NAME_3
 ----------  ----------
 
-        80  7         
         90  A         
+        80  7         
         80  B         
 
 --- 3 row(s) selected.
@@ -406,8 +406,8 @@ PIC_9_7
 MEDIUM_INT 
 -----------
 
-        999
        1000
+        999
        2000
 
 --- 3 row(s) selected.
@@ -420,11 +420,11 @@ MEDIUM_INT
 PIC_9_7  PIC_X_7
 -------  -------
 
-    100  5      
      80  7      
      80  8      
-     80  B      
+    100  5      
      50  michael
+     80  B      
 
 --- 5 row(s) selected.
 >>-- <ufi-input>
@@ -437,20 +437,20 @@ PIC_9_7  MEDIUM_INT
 -------  -----------
 
      90         1000
-     90         2000
-     90          200
      90          999
+     90          200
+     90         2000
      80         1000
-     80         2000
-     80          200
      80          999
+     80          200
+     80         2000
     100         1000
-    100         2000
     100          999
+    100         2000
      50         1000
-     50         2000
-     50          200
      50          999
+     50          200
+     50         2000
 
 --- 15 row(s) selected.
 >>-- <ufi-input>
@@ -463,21 +463,21 @@ PIC_X_1  PIC_9_7  MEDIUM_INT
 -------  -------  -----------
 
 Q             90         1000
-Q             90         2000
-Q             90          200
-Q             90          999
 Q             80         1000
-Q             80         2000
-Q             80          200
-Q             80          999
 Q            100         1000
-Q            100         2000
-Q            100          200
-Q            100          999
 Q             50         1000
-Q             50         2000
-Q             50          200
+Q             90          999
+Q             80          999
+Q            100          999
 Q             50          999
+Q             90          200
+Q             80          200
+Q            100          200
+Q             50          200
+Q             90         2000
+Q             80         2000
+Q            100         2000
+Q             50         2000
 
 --- 16 row(s) selected.
 >>-- <ufi-input>
@@ -516,11 +516,11 @@ DECIMAL_1  NEW_NAME_1
 ---------  ----------
 
         7          90
-        9          90
-        8          90
-        1          90
-        5          90
         4          90
+        5          90
+        1          90
+        8          90
+        9          90
 
 --- 6 row(s) selected.
 >>-- <ufi-input>
@@ -566,22 +566,22 @@ MEDIUM_INT
 CHAR_1  MEDIUM_INT
 ------  ----------
 
-D             8000
-D            10000
-D             1000
-D             9000
 A             8000
-A            10000
-A             1000
-A             9000
+D             8000
+C             8000
 E             8000
+A            10000
+D            10000
+C            10000
 E            10000
-E             1000
+A             9000
+D             9000
+C             9000
 E             9000
-C             8000
-C            10000
+A             1000
+D             1000
 C             1000
-C             9000
+E             1000
 
 --- 16 row(s) selected.
 >>-- <ufi-input>
@@ -633,70 +633,70 @@ NEW_NAME_1  NEW_NAME_3
 PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
 -------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------
 
-michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
 michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
 michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
 michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
 michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
 michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
 8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
 8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
 8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
 7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
 7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
 7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
 7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
 A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
 A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
 5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
 5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
 
 --- 64 row(s) selected.
 >>-- <ufi-input>
@@ -707,70 +707,70 @@ A               5.00  make           90                 200.00  bob
 PIC_X_7  BINARY_32_U  PIC_X4_A  PIC_9_7  BINARY_64_S            VAR_CHAR                                                                                                                                                                                                                                                     MEDIUM_INT   PIC_X_7  PIC_COMP_1
 -------  -----------  --------  -------  ---------------------  -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------  -----------  -------  --------------------
 
-A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
 michael        50.00  dave           50                1500.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+B               6.00  mark           80                3000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+michael        70.00  joan           50                4000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
 5            1000.00  5             100                1000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-8               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
 7               6.00  joe            80                1200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
-A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+7               6.00  john           80                2000.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+A               5.00  make           90                 200.00  william                                                                                                                                                                                                                                                             1000  black                    2000
+7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
 B               6.00  mark           80                3000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
 5            1000.00  5             100                1000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
 8               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
-7               6.00  joe            80                1200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+A               5.00  make           90                 200.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+7               6.00  john           80                2000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+michael        70.00  joan           50                4000.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
+michael        50.00  dave           50                1500.00  tom                                                                                                                                                                                                                                                                 1000  7                         200
 A               5.00  make           90                 200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
+michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
 michael        70.00  joan           50                4000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
 B               6.00  mark           80                3000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
 7               6.00  john           80                2000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-michael        50.00  dave           50                1500.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-5            1000.00  5             100                1000.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-8               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-7               6.00  joe            80                1200.00  sue                                                                                                                                                                                                                                                                  200  sue                       100
-A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 B               6.00  mark           80                3000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 7               6.00  john           80                2000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 michael        50.00  dave           50                1500.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+A               5.00  make           90                 200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 5            1000.00  5             100                1000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 7               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
-A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
-8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+michael        70.00  joan           50                4000.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
+8               6.00  joe            80                1200.00  marilyn                                                                                                                                                                                                                                                             2000  green                    3000
 7               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+8               6.00  joe            80                1200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+5            1000.00  5             100                1000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+michael        50.00  dave           50                1500.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+7               6.00  john           80                2000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+B               6.00  mark           80                3000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+michael        70.00  joan           50                4000.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
+A               5.00  make           90                 200.00  christopher                                                                                                                                                                                                                                                         1000  white                    1000
 A               5.00  make           90                 200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
-8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
 7               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+8               6.00  joe            80                1200.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+5            1000.00  5             100                1000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+michael        50.00  dave           50                1500.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+7               6.00  john           80                2000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+B               6.00  mark           80                3000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
+michael        70.00  joan           50                4000.00  bobby                                                                                                                                                                                                                                                                200  sue                       100
 A               5.00  make           90                 200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
-8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
 7               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+8               6.00  joe            80                1200.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+5            1000.00  5             100                1000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+michael        50.00  dave           50                1500.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+7               6.00  john           80                2000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+B               6.00  mark           80                3000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
+michael        70.00  joan           50                4000.00  bob                                                                                                                                                                                                                                                                  999  A                         300
 A               5.00  make           90                 200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-michael        70.00  joan           50                4000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
-8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
 7               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+8               6.00  joe            80                1200.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+5            1000.00  5             100                1000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+michael        50.00  dave           50                1500.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+7               6.00  john           80                2000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+B               6.00  mark           80                3000.00  bill                                                                                                                                                                                                                                                                2000  B                         500
+michael        70.00  joan           50                4000.00  bill                              

<TRUNCATED>


Mime
View raw message