HAWQ-1702. modify .ans file in hawq feature-test
diff --git a/src/test/feature/catalog/ans/char.ans b/src/test/feature/catalog/ans/char.ans
old mode 100755
new mode 100644
index b88506e..4180ad0
--- a/src/test/feature/catalog/ans/char.ans
+++ b/src/test/feature/catalog/ans/char.ans
@@ -1,3 +1,7 @@
+-- start_ignore
+SET SEARCH_PATH=TestType_char;
+SET
+-- end_ignore
--
-- CHAR
--
@@ -71,11 +75,12 @@
WHERE c.f1 < 'a';
five | f1
------+----
+ | A
| 1
| 2
| 3
|
-(4 rows)
+(5 rows)
SELECT '' AS six, c.*
FROM CHAR_TBL c
@@ -83,20 +88,20 @@
six | f1
-----+----
| a
+ | A
| 1
| 2
| 3
|
-(5 rows)
+(6 rows)
SELECT '' AS one, c.*
FROM CHAR_TBL c
WHERE c.f1 > 'a';
one | f1
-----+----
- | A
| c
-(2 rows)
+(1 row)
SELECT '' AS two, c.*
FROM CHAR_TBL c
@@ -104,9 +109,8 @@
two | f1
-----+----
| a
- | A
| c
-(3 rows)
+(2 rows)
DROP TABLE CHAR_TBL;
DROP TABLE
diff --git a/src/test/feature/catalog/ans/varchar.ans b/src/test/feature/catalog/ans/varchar.ans
old mode 100755
new mode 100644
index 513e953..067b445
--- a/src/test/feature/catalog/ans/varchar.ans
+++ b/src/test/feature/catalog/ans/varchar.ans
@@ -1,3 +1,7 @@
+-- start_ignore
+SET SEARCH_PATH=TestType_varchar;
+SET
+-- end_ignore
--
-- VARCHAR
--
@@ -60,11 +64,12 @@
WHERE c.f1 < 'a';
five | f1
------+----
+ | A
| 1
| 2
| 3
|
-(4 rows)
+(5 rows)
SELECT '' AS six, c.*
FROM VARCHAR_TBL c
@@ -72,20 +77,20 @@
six | f1
-----+----
| a
+ | A
| 1
| 2
| 3
|
-(5 rows)
+(6 rows)
SELECT '' AS one, c.*
FROM VARCHAR_TBL c
WHERE c.f1 > 'a';
one | f1
-----+----
- | A
| c
-(2 rows)
+(1 row)
SELECT '' AS two, c.*
FROM VARCHAR_TBL c
@@ -93,9 +98,8 @@
two | f1
-----+----
| a
- | A
| c
-(3 rows)
+(2 rows)
DROP TABLE VARCHAR_TBL;
DROP TABLE
