summaryrefslogtreecommitdiff
path: root/src/test/regress/expected/char4.out
diff options
context:
space:
mode:
Diffstat (limited to 'src/test/regress/expected/char4.out')
-rw-r--r--src/test/regress/expected/char4.out97
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;