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