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>
