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.
>>
