1 files changed, 98 insertions, 0 deletions
diff --git a/src/test/regress/expected/varchar.out b/src/test/regress/expected/varchar.out
new file mode 100644
index 00000000000..6bfa1a93175
--- /dev/null
+++ b/src/test/regress/expected/varchar.out
@@ -0,0 +1,98 @@
+QUERY: CREATE TABLE VARCHAR_TBL(f1 varchar(1));
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('A');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('1');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES (2);
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('3');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('cd');
+QUERY: SELECT '' AS seven, VARCHAR_TBL.*;
+seven|f1
+-----+--
+     |a 
+     |A 
+     |1 
+     |2 
+     |3 
+     |  
+     |c 
+(7 rows)
+
+QUERY: SELECT '' AS six, c.*
+   FROM VARCHAR_TBL c
+   WHERE c.f1 <> 'a';
+six|f1
+---+--
+   |A 
+   |1 
+   |2 
+   |3 
+   |  
+   |c 
+(6 rows)
+
+QUERY: SELECT '' AS one, c.*
+   FROM VARCHAR_TBL c
+   WHERE c.f1 = 'a';
+one|f1
+---+--
+   |a 
+(1 row)
+
+QUERY: SELECT '' AS five, c.*
+   FROM VARCHAR_TBL c
+   WHERE c.f1 < 'a';
+five|f1
+----+--
+    |A 
+    |1 
+    |2 
+    |3 
+    |  
+(5 rows)
+
+QUERY: SELECT '' AS six, c.*
+   FROM VARCHAR_TBL c
+   WHERE c.f1 <= 'a';
+six|f1
+---+--
+   |a 
+   |A 
+   |1 
+   |2 
+   |3 
+   |  
+(6 rows)
+
+QUERY: SELECT '' AS one, c.*
+   FROM VARCHAR_TBL c
+   WHERE c.f1 > 'a';
+one|f1
+---+--
+   |c 
+(1 row)
+
+QUERY: SELECT '' AS two, c.*
+   FROM VARCHAR_TBL c
+   WHERE c.f1 >= 'a';
+two|f1
+---+--
+   |a 
+   |c 
+(2 rows)
+
+QUERY: DROP TABLE VARCHAR_TBL;
+QUERY: CREATE TABLE VARCHAR_TBL(f1 varchar(4));
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('a');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('ab');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('abcd');
+QUERY: INSERT INTO VARCHAR_TBL (f1) VALUES ('abcde');
+QUERY: SELECT '' AS four, VARCHAR_TBL.*;
+four|f1  
+----+----
+    |a   
+    |ab  
+    |abcd
+    |abcd
+(4 rows)
+