diff options
Diffstat (limited to 'src/test/regress/expected/char4.out')
| -rw-r--r-- | src/test/regress/expected/char4.out | 97 |
1 files changed, 0 insertions, 97 deletions
diff --git a/src/test/regress/expected/char4.out b/src/test/regress/expected/char4.out deleted file mode 100644 index 84a595fc79..0000000000 --- a/src/test/regress/expected/char4.out +++ /dev/null @@ -1,97 +0,0 @@ -QUERY: CREATE TABLE CHAR4_TBL (f1 char4); -QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('ABCD'); -QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('abcd'); -QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('ZYWZ'); -QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('343f'); -QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('d34a'); -QUERY: INSERT INTO CHAR4_TBL(f1) VALUES (''); -QUERY: INSERT INTO CHAR4_TBL(f1) VALUES ('12345678'); -QUERY: SELECT '' AS seven, CHAR4_TBL.*; -seven|f1 ------+---- - |ABCD - |abcd - |ZYWZ - |343f - |d34a - | - |1234 -(7 rows) - -QUERY: SELECT '' AS six, c.f1 FROM CHAR4_TBL c WHERE c.f1 <> 'ABCD'; -six|f1 ----+---- - |abcd - |ZYWZ - |343f - |d34a - | - |1234 -(6 rows) - -QUERY: SELECT '' AS one, c.f1 FROM CHAR4_TBL c WHERE c.f1 = 'ABCD'; -one|f1 ----+---- - |ABCD -(1 row) - -QUERY: SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 < 'ABCD'; -three|f1 ------+---- - |343f - | - |1234 -(3 rows) - -QUERY: SELECT '' AS four, c.f1 FROM CHAR4_TBL c WHERE c.f1 <= 'ABCD'; -four|f1 -----+---- - |ABCD - |343f - | - |1234 -(4 rows) - -QUERY: SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 > 'ABCD'; -three|f1 ------+---- - |abcd - |ZYWZ - |d34a -(3 rows) - -QUERY: SELECT '' AS four, c.f1 FROM CHAR4_TBL c WHERE c.f1 >= 'ABCD'; -four|f1 -----+---- - |ABCD - |abcd - |ZYWZ - |d34a -(4 rows) - -QUERY: SELECT '' AS seven, c.f1 FROM CHAR4_TBL c WHERE c.f1 ~ '.*'; -seven|f1 ------+---- - |ABCD - |abcd - |ZYWZ - |343f - |d34a - | - |1234 -(7 rows) - -QUERY: SELECT '' AS zero, c.f1 FROM CHAR4_TBL c WHERE c.f1 !~ '.*'; -zero|f1 -----+-- -(0 rows) - -QUERY: SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 ~ '.*34.*'; -three|f1 ------+---- - |343f - |d34a - |1234 -(3 rows) - -QUERY: DROP TABLE CHAR4_TBL; |
