http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/911f1d64/core/sql/regress/qat/eqatdml12
----------------------------------------------------------------------
diff --git a/core/sql/regress/qat/eqatdml12 b/core/sql/regress/qat/eqatdml12
index 026330e..c2ffa3b 100755
--- a/core/sql/regress/qat/eqatdml12
+++ b/core/sql/regress/qat/eqatdml12
@@ -339,14 +339,14 @@ select * from btsel06 where NOT NOT NOT col_6 < 100;
+> OR pic_decimal_3 <> 8
+> AND pic_decimal_3 >= 6;
-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
------- ---------------------------------------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- -------------
+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
+------ ---------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- -------------
-D michelle D michael rat thomas
-5000 90.00 2000.000 500 .40 100.80000 90 8000 200 7 .93 140 6.1 .600 6
-D melissa C 7 pop jimmy
1000 80.00 1500.000 500 .20 100.99990 80 9000 999 5 .80 120 4.1 .400 4
-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
-C maureen E jimmy rum marilyn
3000 80.00 2000.000 500 .50 100.70000 9000 1000 2000 8 .97 150 7.1 .700 7
-D steven B 9 bat thomas
8000 70.00 2000.000 500 .10 100.99900 90 10000 1000 7 .70 110 3.1 .300 3
+D michelle D michael rat thomas -5000 90.00 2000.000 500 .40 100.80000 90 8000 200 7 .93 140 6.1 .600 6
+D melissa C 7 pop jimmy 1000 80.00 1500.000 500 .20 100.99990 80 9000 999 5 .80 120 4.1 .400 4
+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
+C maureen E jimmy rum marilyn 3000 80.00 2000.000 500 .50 100.70000 9000 1000 2000 8 .97 150 7.1 .700 7
+D steven B 9 bat thomas 8000 70.00 2000.000 500 .10 100.99900 90 10000 1000 7 .70 110 3.1 .300 3
--- 5 row(s) selected.
>>
@@ -362,14 +362,14 @@ D steven B 9 bat
+> OR pic_decimal_3 <> 8)
+> AND pic_decimal_3 >= 6;
-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
------- ---------------------------------------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- -------------
+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
+------ ---------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- -------------
-D michelle D michael rat thomas
-5000 90.00 2000.000 500 .40 100.80000 90 8000 200 7 .93 140 6.1 .600 6
-D melissa C 7 pop jimmy
1000 80.00 1500.000 500 .20 100.99990 80 9000 999 5 .80 120 4.1 .400 4
-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
-C maureen E jimmy rum marilyn
3000 80.00 2000.000 500 .50 100.70000 9000 1000 2000 8 .97 150 7.1 .700 7
-D steven B 9 bat thomas
8000 70.00 2000.000 500 .10 100.99900 90 10000 1000 7 .70 110 3.1 .300 3
+D michelle D michael rat thomas -5000 90.00 2000.000 500 .40 100.80000 90 8000 200 7 .93 140 6.1 .600 6
+D melissa C 7 pop jimmy 1000 80.00 1500.000 500 .20 100.99990 80 9000 999 5 .80 120 4.1 .400 4
+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
+C maureen E jimmy rum marilyn 3000 80.00 2000.000 500 .50 100.70000 9000 1000 2000 8 .97 150 7.1 .700 7
+D steven B 9 bat thomas 8000 70.00 2000.000 500 .10 100.99900 90 10000 1000 7 .70 110 3.1 .300 3
--- 5 row(s) selected.
>>
@@ -385,14 +385,14 @@ D steven B 9 bat
+> OR (pic_decimal_3 <> 8
+> AND pic_decimal_3 >= 6) ;
-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
------- ---------------------------------------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- -------------
+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
+------ ---------- ------- ------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------- ----------- --------------------- -------------------- ---------- ------------ --------- ---------- -------------------- --------- ---------------- ------------------ ------------- ------------- -------------
-D michelle D michael rat thomas
-5000 90.00 2000.000 500 .40 100.80000 90 8000 200 7 .93 140 6.1 .600 6
-D melissa C 7 pop jimmy
1000 80.00 1500.000 500 .20 100.99990 80 9000 999 5 .80 120 4.1 .400 4
-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
-C maureen E jimmy rum marilyn
3000 80.00 2000.000 500 .50 100.70000 9000 1000 2000 8 .97 150 7.1 .700 7
-D steven B 9 bat thomas
8000 70.00 2000.000 500 .10 100.99900 90 10000 1000 7 .70 110 3.1 .300 3
+D michelle D michael rat thomas -5000 90.00 2000.000 500 .40 100.80000 90 8000 200 7 .93 140 6.1 .600 6
+D melissa C 7 pop jimmy 1000 80.00 1500.000 500 .20 100.99990 80 9000 999 5 .80 120 4.1 .400 4
+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
+C maureen E jimmy rum marilyn 3000 80.00 2000.000 500 .50 100.70000 9000 1000 2000 8 .97 150 7.1 .700 7
+D steven B 9 bat thomas 8000 70.00 2000.000 500 .10 100.99900 90 10000 1000 7 .70 110 3.1 .300 3
--- 5 row(s) selected.
>>
@@ -767,7 +767,7 @@ D steven B 9 bat
(EXPR)
---------------------
- 2.20000000
+ 2.200000000
--- 1 row(s) selected.
>>
@@ -780,7 +780,7 @@ D steven B 9 bat
(EXPR)
---------------------
- 2.20000000
+ 2.200000000
--- 1 row(s) selected.
>>
@@ -794,7 +794,7 @@ D steven B 9 bat
(EXPR)
---------------------
- 999999999.99999999
+ 999999999.999999999
--- 1 row(s) selected.
>>
@@ -807,7 +807,7 @@ D steven B 9 bat
(EXPR)
---------------------
- 999999999.99999999
+ 999999999.999999999
--- 1 row(s) selected.
>>
@@ -818,10 +818,10 @@ D steven B 9 bat
+> from btsel26
+> where selector = 'B';
-(EXPR)
----------------------
+(EXPR)
+----------------------
- 1000000000.9999999
+ 1000000000.999999998
--- 1 row(s) selected.
>>
@@ -832,10 +832,10 @@ D steven B 9 bat
+> from btsel26
+> where selector = 'B';
-(EXPR)
----------------------
+(EXPR)
+----------------------
- 1000000000.9999999
+ 1000000000.999999998
--- 1 row(s) selected.
>>
@@ -1073,25 +1073,25 @@ D steven B 9 bat
>> select 10.999999999999999999
+> from btsel26;
-(EXPR)
-----------------------
+(EXPR)
+---------------------
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
- 10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
+10.999999999999999999
--- 16 row(s) selected.
>>