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>
