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