http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/6dd81240/core/sql/regress/qat/eqatdml06
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml06 b/core/sql/regress/qat/eqatdml06
index cd5e607..470b593 100755
--- a/core/sql/regress/qat/eqatdml06
+++ b/core/sql/regress/qat/eqatdml06
@@ -29,8 +29,8 @@
>>-- expression list
>>-- A3: SELECT WHERE <predicate>, where <predicate> contains
>>-- AND, OR, NOT
->>-- A4: use of SELECT WHERE ... for browse access,for stable access
->>-- , for repeatable access
+>>-- A4: use of SELECT WHERE ... for read committed access,for read committed access
+>>-- , for read committed access
>>-- A5: SELECT aggregate functions with WHERE predicate
>>
>>-- All testcases are documented further below.
@@ -95,10 +95,10 @@ D steven B 9 bat
CHAR_1 CHAR_10 PIC_X_1 PIC_X_7 PIC_X_LONG VAR_CHAR BINARY_SIGNED BINARY_32_U BINARY_64_S PIC_COMP_1 PIC_COMP_2 PIC_COMP_3 SMALL_INT MEDIUM_INT LARGE_INT DECIMAL_1 DECIMAL_2_SIGNED DECIMAL_3_UNSIGNED PIC_DECIMAL_1 PIC_DECIMAL_2 PIC_DECIMAL_3 NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 NEW_NAME_4 VAR_CHAR
MEDIUM_INT PIC_X_7 PIC_COMP_1
------ ---------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- ------------- ---------- ----------- ---------- -------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------- ----------- ------- --------------------
-E monica Q sue pat christopher 2000 90.00 1200.000 3000 .30 100.99999 2000 8000 -1000000 1 .90 80 5.1 .500 5 80 6.00 7 216172782159534338 tom
1000 7 200
-E monica Q sue pat christopher 2000 90.00 1200.000 3000 .30 100.99999 2000 8000 -1000000 1 .90 80 5.1 .500 5 80 6.00 7 216172782159534342 tom
1000 7 200
-E monica Q sue pat christopher 2000 90.00 1200.000 3000 .30 100.99999 2000 8000 -1000000 1 .90 80 5.1 .500 5 80 6.00 B 216172782159534343 bill
2000 B 500
-A steven C walter bob B 50 50.00 200.000 50 .12 100.90000 10 10000 1000000000 4 .50 90 1.1 .100 1 90 5.00 A 216172782159534337 bob
999 A 300
+A steven C walter bob B 50 50.00 200.000 50 .12 100.90000 10 10000 1000000000 4 .50 90 1.1 .100 1 90 5.00 A 3348008712604909660 bob
999 A 300
+E monica Q sue pat christopher 2000 90.00 1200.000 3000 .30 100.99999 2000 8000 -1000000 1 .90 80 5.1 .500 5 80 6.00 7 3348008712604933890 tom
1000 7 200
+E monica Q sue pat christopher 2000 90.00 1200.000 3000 .30 100.99999 2000 8000 -1000000 1 .90 80 5.1 .500 5 80 6.00 7 3348008712604972182 tom
1000 7 200
+E monica Q sue pat christopher 2000 90.00 1200.000 3000 .30 100.99999 2000 8000 -1000000 1 .90 80 5.1 .500 5 80 6.00 B 3348008712604978694 bill
2000 B 500
--- 4 row(s) selected.
>>-- <ufi-input>
@@ -110,48 +110,48 @@ BINARY_SIGNED LARGE_INT MEDIUM_INT PIC_DECIMAL_3 PIC_X_1 PIC_X_7
------------- -------------------- ---------- ------------- ------- ------- --------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- --------------------
-5000 200 8000 6 D michael 90 tom 1000 7 200
- -5000 200 8000 6 D michael 90 marilyn 2000 green 3000
- -5000 200 8000 6 D michael 90 william 1000 black 2000
- -5000 200 8000 6 D michael 90 christopher 1000 white 1000
- -5000 200 8000 6 D michael 90 bill 2000 B 500
- -5000 200 8000 6 D michael 90 bob 999 A 300
50 1000000000 10000 1 C walter 10 tom 1000 7 200
- 50 1000000000 10000 1 C walter 10 marilyn 2000 green 3000
- 50 1000000000 10000 1 C walter 10 william 1000 black 2000
- 50 1000000000 10000 1 C walter 10 christopher 1000 white 1000
- 50 1000000000 10000 1 C walter 10 bill 2000 B 500
- 50 1000000000 10000 1 C walter 10 bob 999 A 300
60 -1000 8000 2 A bobby 1000 tom 1000 7 200
- 60 -1000 8000 2 A bobby 1000 marilyn 2000 green 3000
- 60 -1000 8000 2 A bobby 1000 william 1000 black 2000
- 60 -1000 8000 2 A bobby 1000 christopher 1000 white 1000
- 60 -1000 8000 2 A bobby 1000 bill 2000 B 500
- 60 -1000 8000 2 A bobby 1000 bob 999 A 300
1000 999 9000 4 C 7 80 tom 1000 7 200
- 1000 999 9000 4 C 7 80 marilyn 2000 green 3000
- 1000 999 9000 4 C 7 80 william 1000 black 2000
- 1000 999 9000 4 C 7 80 christopher 1000 white 1000
- 1000 999 9000 4 C 7 80 bill 2000 B 500
- 1000 999 9000 4 C 7 80 bob 999 A 300
2000 -1000000 8000 5 Q sue 2000 tom 1000 7 200
- 2000 -1000000 8000 5 Q sue 2000 marilyn 2000 green 3000
- 2000 -1000000 8000 5 Q sue 2000 william 1000 black 2000
- 2000 -1000000 8000 5 Q sue 2000 christopher 1000 white 1000
- 2000 -1000000 8000 5 Q sue 2000 bill 2000 B 500
+ 4000 0 5000 8 Z johnny 8000 tom 1000 7 200
+ 8000 1000 10000 3 B 9 90 tom 1000 7 200
+ -5000 200 8000 6 D michael 90 bob 999 A 300
+ 50 1000000000 10000 1 C walter 10 bob 999 A 300
+ 60 -1000 8000 2 A bobby 1000 bob 999 A 300
+ 1000 999 9000 4 C 7 80 bob 999 A 300
2000 -1000000 8000 5 Q sue 2000 bob 999 A 300
3000 2000 1000 7 E jimmy 9000 bob 999 A 300
- 4000 0 5000 8 Z johnny 8000 tom 1000 7 200
- 4000 0 5000 8 Z johnny 8000 marilyn 2000 green 3000
- 4000 0 5000 8 Z johnny 8000 william 1000 black 2000
- 4000 0 5000 8 Z johnny 8000 christopher 1000 white 1000
- 4000 0 5000 8 Z johnny 8000 bill 2000 B 500
4000 0 5000 8 Z johnny 8000 bob 999 A 300
- 8000 1000 10000 3 B 9 90 tom 1000 7 200
- 8000 1000 10000 3 B 9 90 marilyn 2000 green 3000
- 8000 1000 10000 3 B 9 90 william 1000 black 2000
- 8000 1000 10000 3 B 9 90 christopher 1000 white 1000
- 8000 1000 10000 3 B 9 90 bill 2000 B 500
8000 1000 10000 3 B 9 90 bob 999 A 300
+ -5000 200 8000 6 D michael 90 bill 2000 B 500
+ 50 1000000000 10000 1 C walter 10 bill 2000 B 500
+ 60 -1000 8000 2 A bobby 1000 bill 2000 B 500
+ 1000 999 9000 4 C 7 80 bill 2000 B 500
+ 2000 -1000000 8000 5 Q sue 2000 bill 2000 B 500
+ 4000 0 5000 8 Z johnny 8000 bill 2000 B 500
+ 8000 1000 10000 3 B 9 90 bill 2000 B 500
+ -5000 200 8000 6 D michael 90 christopher 1000 white 1000
+ 50 1000000000 10000 1 C walter 10 christopher 1000 white 1000
+ 60 -1000 8000 2 A bobby 1000 christopher 1000 white 1000
+ 1000 999 9000 4 C 7 80 christopher 1000 white 1000
+ 2000 -1000000 8000 5 Q sue 2000 christopher 1000 white 1000
+ 4000 0 5000 8 Z johnny 8000 christopher 1000 white 1000
+ 8000 1000 10000 3 B 9 90 christopher 1000 white 1000
+ -5000 200 8000 6 D michael 90 william 1000 black 2000
+ 50 1000000000 10000 1 C walter 10 william 1000 black 2000
+ 60 -1000 8000 2 A bobby 1000 william 1000 black 2000
+ 1000 999 9000 4 C 7 80 william 1000 black 2000
+ 2000 -1000000 8000 5 Q sue 2000 william 1000 black 2000
+ 4000 0 5000 8 Z johnny 8000 william 1000 black 2000
+ 8000 1000 10000 3 B 9 90 william 1000 black 2000
+ -5000 200 8000 6 D michael 90 marilyn 2000 green 3000
+ 50 1000000000 10000 1 C walter 10 marilyn 2000 green 3000
+ 60 -1000 8000 2 A bobby 1000 marilyn 2000 green 3000
+ 1000 999 9000 4 C 7 80 marilyn 2000 green 3000
+ 2000 -1000000 8000 5 Q sue 2000 marilyn 2000 green 3000
+ 4000 0 5000 8 Z johnny 8000 marilyn 2000 green 3000
+ 8000 1000 10000 3 B 9 90 marilyn 2000 green 3000
--- 43 row(s) selected.
>>-- <ufi-input>
@@ -162,33 +162,33 @@ BINARY_SIGNED LARGE_INT MEDIUM_INT PIC_DECIMAL_3 PIC_X_1 PIC_X_7
BINARY_SIGNED LARGE_INT MEDIUM_INT PIC_DECIMAL_3 PIC_X_1 PIC_X_7 SMALL_INT NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 NEW_NAME_4 VAR_CHAR MEDIUM_INT PIC_X_7 PIC_COMP_1
------------- -------------------- ---------- ------------- ------- ------- --------- ---------- ----------- ---------- -------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- --------------------
- 4000 0 5000 8 Z johnny 8000 90 5.00 A 216172782159534337 bob 999 A 300
- 3000 2000 1000 7 E jimmy 9000 90 5.00 A 216172782159534337 bob 999 A 300
- 2000 -1000000 8000 5 Q sue 2000 90 5.00 A 216172782159534337 bob 999 A 300
- 1000 999 9000 4 C 7 80 90 5.00 A 216172782159534337 bob 999 A 300
- 60 -1000 8000 2 A bobby 1000 90 5.00 A 216172782159534337 bob 999 A 300
- 50 1000000000 10000 1 C walter 10 90 5.00 A 216172782159534337 bob 999 A 300
- -5000 200 8000 6 D michael 90 80 6.00 7 216172782159534338 tom 1000 7 200
- 8000 1000 10000 3 B 9 90 80 6.00 7 216172782159534338 tom 1000 7 200
- 4000 0 5000 8 Z johnny 8000 80 6.00 7 216172782159534338 tom 1000 7 200
- 3000 2000 1000 7 E jimmy 9000 80 6.00 7 216172782159534338 tom 1000 7 200
- 2000 -1000000 8000 5 Q sue 2000 80 6.00 7 216172782159534338 tom 1000 7 200
- 60 -1000 8000 2 A bobby 1000 80 6.00 7 216172782159534338 tom 1000 7 200
- 50 1000000000 10000 1 C walter 10 80 6.00 7 216172782159534338 tom 1000 7 200
- -5000 200 8000 6 D michael 90 80 6.00 7 216172782159534342 tom 1000 7 200
- 8000 1000 10000 3 B 9 90 80 6.00 7 216172782159534342 tom 1000 7 200
- 4000 0 5000 8 Z johnny 8000 80 6.00 7 216172782159534342 tom 1000 7 200
- 3000 2000 1000 7 E jimmy 9000 80 6.00 7 216172782159534342 tom 1000 7 200
- 2000 -1000000 8000 5 Q sue 2000 80 6.00 7 216172782159534342 tom 1000 7 200
- 60 -1000 8000 2 A bobby 1000 80 6.00 7 216172782159534342 tom 1000 7 200
- 50 1000000000 10000 1 C walter 10 80 6.00 7 216172782159534342 tom 1000 7 200
- -5000 200 8000 6 D michael 90 80 6.00 B 216172782159534343 bill 2000 B 500
- 8000 1000 10000 3 B 9 90 80 6.00 B 216172782159534343 bill 2000 B 500
- 4000 0 5000 8 Z johnny 8000 80 6.00 B 216172782159534343 bill 2000 B 500
- 3000 2000 1000 7 E jimmy 9000 80 6.00 B 216172782159534343 bill 2000 B 500
- 2000 -1000000 8000 5 Q sue 2000 80 6.00 B 216172782159534343 bill 2000 B 500
- 60 -1000 8000 2 A bobby 1000 80 6.00 B 216172782159534343 bill 2000 B 500
- 50 1000000000 10000 1 C walter 10 80 6.00 B 216172782159534343 bill 2000 B 500
+ -5000 200 8000 6 D michael 90 80 6.00 7 3348008712604933890 tom 1000 7 200
+ -5000 200 8000 6 D michael 90 80 6.00 7 3348008712604972182 tom 1000 7 200
+ -5000 200 8000 6 D michael 90 80 6.00 B 3348008712604978694 bill 2000 B 500
+ 50 1000000000 10000 1 C walter 10 90 5.00 A 3348008712604909660 bob 999 A 300
+ 50 1000000000 10000 1 C walter 10 80 6.00 7 3348008712604933890 tom 1000 7 200
+ 50 1000000000 10000 1 C walter 10 80 6.00 7 3348008712604972182 tom 1000 7 200
+ 50 1000000000 10000 1 C walter 10 80 6.00 B 3348008712604978694 bill 2000 B 500
+ 60 -1000 8000 2 A bobby 1000 90 5.00 A 3348008712604909660 bob 999 A 300
+ 60 -1000 8000 2 A bobby 1000 80 6.00 7 3348008712604933890 tom 1000 7 200
+ 60 -1000 8000 2 A bobby 1000 80 6.00 7 3348008712604972182 tom 1000 7 200
+ 60 -1000 8000 2 A bobby 1000 80 6.00 B 3348008712604978694 bill 2000 B 500
+ 1000 999 9000 4 C 7 80 90 5.00 A 3348008712604909660 bob 999 A 300
+ 2000 -1000000 8000 5 Q sue 2000 90 5.00 A 3348008712604909660 bob 999 A 300
+ 2000 -1000000 8000 5 Q sue 2000 80 6.00 7 3348008712604933890 tom 1000 7 200
+ 2000 -1000000 8000 5 Q sue 2000 80 6.00 7 3348008712604972182 tom 1000 7 200
+ 2000 -1000000 8000 5 Q sue 2000 80 6.00 B 3348008712604978694 bill 2000 B 500
+ 3000 2000 1000 7 E jimmy 9000 90 5.00 A 3348008712604909660 bob 999 A 300
+ 3000 2000 1000 7 E jimmy 9000 80 6.00 7 3348008712604933890 tom 1000 7 200
+ 3000 2000 1000 7 E jimmy 9000 80 6.00 7 3348008712604972182 tom 1000 7 200
+ 3000 2000 1000 7 E jimmy 9000 80 6.00 B 3348008712604978694 bill 2000 B 500
+ 4000 0 5000 8 Z johnny 8000 90 5.00 A 3348008712604909660 bob 999 A 300
+ 4000 0 5000 8 Z johnny 8000 80 6.00 7 3348008712604933890 tom 1000 7 200
+ 4000 0 5000 8 Z johnny 8000 80 6.00 7 3348008712604972182 tom 1000 7 200
+ 4000 0 5000 8 Z johnny 8000 80 6.00 B 3348008712604978694 bill 2000 B 500
+ 8000 1000 10000 3 B 9 90 80 6.00 7 3348008712604933890 tom 1000 7 200
+ 8000 1000 10000 3 B 9 90 80 6.00 7 3348008712604972182 tom 1000 7 200
+ 8000 1000 10000 3 B 9 90 80 6.00 B 3348008712604978694 bill 2000 B 500
--- 27 row(s) selected.
>>-- <ufi-input>
@@ -199,19 +199,19 @@ BINARY_SIGNED LARGE_INT MEDIUM_INT PIC_DECIMAL_3 PIC_X_1 PIC_X_7
NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 NEW_NAME_4 VAR_CHAR MEDIUM_INT PIC_X_7 PIC_COMP_1 COL_1 COL_2 COL_3 COL_4 COL_5 COL_6 COL_7 COL_8
---------- ----------- ---------- -------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- -------------------- ------ -------------------- ---------- ----- ----- ------- ------ -------
- 90 5.00 A 216172782159534337 bob 999 A 300 50 1000000000 10000 1 C walter 10 A
- 80 6.00 7 216172782159534338 tom 1000 7 200 60 -1000 8000 2 A bobby 1000 7
- 80 6.00 7 216172782159534342 tom 1000 7 200 60 -1000 8000 2 A bobby 1000 7
- 80 6.00 7 216172782159534338 tom 1000 7 200 2000 -1000000 8000 5 Q sue 2000 7
- 80 6.00 7 216172782159534342 tom 1000 7 200 2000 -1000000 8000 5 Q sue 2000 7
- 80 6.00 7 216172782159534338 tom 1000 7 200 3000 2000 1000 7 E jimmy 9000 7
- 80 6.00 7 216172782159534342 tom 1000 7 200 3000 2000 1000 7 E jimmy 9000 7
- 80 6.00 7 216172782159534338 tom 1000 7 200 -5000 200 8000 6 D michael 90 7
- 80 6.00 7 216172782159534342 tom 1000 7 200 -5000 200 8000 6 D michael 90 7
- 80 6.00 7 216172782159534338 tom 1000 7 200 4000 0 5000 8 Z johnny 8000 7
- 80 6.00 7 216172782159534342 tom 1000 7 200 4000 0 5000 8 Z johnny 8000 7
- 80 6.00 7 216172782159534338 tom 1000 7 200 8000 1000 10000 3 B 9 90 7
- 80 6.00 7 216172782159534342 tom 1000 7 200 8000 1000 10000 3 B 9 90 7
+ 90 5.00 A 3348008712604909660 bob 999 A 300 50 1000000000 10000 1 C walter 10 A
+ 80 6.00 7 3348008712604933890 tom 1000 7 200 60 -1000 8000 2 A bobby 1000 7
+ 80 6.00 7 3348008712604933890 tom 1000 7 200 2000 -1000000 8000 5 Q sue 2000 7
+ 80 6.00 7 3348008712604933890 tom 1000 7 200 -5000 200 8000 6 D michael 90 7
+ 80 6.00 7 3348008712604933890 tom 1000 7 200 8000 1000 10000 3 B 9 90 7
+ 80 6.00 7 3348008712604933890 tom 1000 7 200 4000 0 5000 8 Z johnny 8000 7
+ 80 6.00 7 3348008712604933890 tom 1000 7 200 3000 2000 1000 7 E jimmy 9000 7
+ 80 6.00 7 3348008712604972182 tom 1000 7 200 60 -1000 8000 2 A bobby 1000 7
+ 80 6.00 7 3348008712604972182 tom 1000 7 200 2000 -1000000 8000 5 Q sue 2000 7
+ 80 6.00 7 3348008712604972182 tom 1000 7 200 -5000 200 8000 6 D michael 90 7
+ 80 6.00 7 3348008712604972182 tom 1000 7 200 8000 1000 10000 3 B 9 90 7
+ 80 6.00 7 3348008712604972182 tom 1000 7 200 4000 0 5000 8 Z johnny 8000 7
+ 80 6.00 7 3348008712604972182 tom 1000 7 200 3000 2000 1000 7 E jimmy 9000 7
--- 13 row(s) selected.
>>-- <ufi-input>
@@ -254,16 +254,16 @@ BINARY_SIGNED LARGE_INT MEDIUM_INT PIC_DECIMAL_3 PIC_X_1 PIC_X_7
NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 NEW_NAME_4 VAR_CHAR MEDIUM_INT PIC_X_7 PIC_COMP_1 NEW_NAME_1 NEW_NAME_2 NEW_NAME_3 NEW_NAME_4 VAR_CHAR MEDIUM_INT PIC_X_7 PIC_COMP_1
---------- ----------- ---------- -------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- -------------------- ---------- ----------- ---------- -------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ------- --------------------
- 80 6.00 7 216172782159534338 tom 1000 7 200 80 6.00 B 216172782159534343 bill 2000 B 500
- 80 6.00 7 216172782159534342 tom 1000 7 200 80 6.00 B 216172782159534343 bill 2000 B 500
- 80 6.00 7 216172782159534338 tom 1000 7 200 90 5.00 A 216172782159534337 bob 999 A 300
- 80 6.00 7 216172782159534342 tom 1000 7 200 90 5.00 A 216172782159534337 bob 999 A 300
- 90 5.00 A 216172782159534337 bob 999 A 300 80 6.00 7 216172782159534338 tom 1000 7 200
- 90 5.00 A 216172782159534337 bob 999 A 300 80 6.00 7 216172782159534342 tom 1000 7 200
- 90 5.00 A 216172782159534337 bob 999 A 300 80 6.00 B 216172782159534343 bill 2000 B 500
- 80 6.00 B 216172782159534343 bill 2000 B 500 80 6.00 7 216172782159534338 tom 1000 7 200
- 80 6.00 B 216172782159534343 bill 2000 B 500 80 6.00 7 216172782159534342 tom 1000 7 200
- 80 6.00 B 216172782159534343 bill 2000 B 500 90 5.00 A 216172782159534337 bob 999 A 300
+ 80 6.00 7 3348008712604933890 tom 1000 7 200 90 5.00 A 3348008712604909660 bob 999 A
<TRUNCATED>