diff options
Diffstat (limited to 'src/test/regress/sql/char4.sql')
| -rw-r--r-- | src/test/regress/sql/char4.sql | 43 |
1 files changed, 0 insertions, 43 deletions
diff --git a/src/test/regress/sql/char4.sql b/src/test/regress/sql/char4.sql deleted file mode 100644 index 5455557ef0..0000000000 --- a/src/test/regress/sql/char4.sql +++ /dev/null @@ -1,43 +0,0 @@ ---**************** testing built-in type char4 ************** --- --- all inputs are silently truncated at 4 characters --- - -CREATE TABLE CHAR4_TBL (f1 char4); - -INSERT INTO CHAR4_TBL(f1) VALUES ('ABCD'); - -INSERT INTO CHAR4_TBL(f1) VALUES ('abcd'); - -INSERT INTO CHAR4_TBL(f1) VALUES ('ZYWZ'); - -INSERT INTO CHAR4_TBL(f1) VALUES ('343f'); - -INSERT INTO CHAR4_TBL(f1) VALUES ('d34a'); - -INSERT INTO CHAR4_TBL(f1) VALUES (''); - -INSERT INTO CHAR4_TBL(f1) VALUES ('12345678'); - - -SELECT '' AS seven, CHAR4_TBL.*; - -SELECT '' AS six, c.f1 FROM CHAR4_TBL c WHERE c.f1 <> 'ABCD'; - -SELECT '' AS one, c.f1 FROM CHAR4_TBL c WHERE c.f1 = 'ABCD'; - -SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 < 'ABCD'; - -SELECT '' AS four, c.f1 FROM CHAR4_TBL c WHERE c.f1 <= 'ABCD'; - -SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 > 'ABCD'; - -SELECT '' AS four, c.f1 FROM CHAR4_TBL c WHERE c.f1 >= 'ABCD'; - -SELECT '' AS seven, c.f1 FROM CHAR4_TBL c WHERE c.f1 ~ '.*'; - -SELECT '' AS zero, c.f1 FROM CHAR4_TBL c WHERE c.f1 !~ '.*'; - -SELECT '' AS three, c.f1 FROM CHAR4_TBL c WHERE c.f1 ~ '.*34.*'; - -DROP TABLE CHAR4_TBL; |
