From 1c1cafe72ff1a352618a126ae3c470d31a8a2545 Mon Sep 17 00:00:00 2001 From: "Marc G. Fournier" Date: Mon, 26 Apr 1999 13:37:14 +0000 Subject: [PATCH] These are no longer used ... --- src/test/regress/expected/int2-NetBSD.out | 206 --------------- src/test/regress/expected/int2-OSF1.out | 206 --------------- src/test/regress/expected/int2-SunOS.out | 206 --------------- src/test/regress/expected/int4-NetBSD.out | 302 ---------------------- src/test/regress/expected/int4-OSF1.out | 302 ---------------------- src/test/regress/expected/int4-SunOS.out | 302 ---------------------- 6 files changed, 1524 deletions(-) delete mode 100644 src/test/regress/expected/int2-NetBSD.out delete mode 100644 src/test/regress/expected/int2-OSF1.out delete mode 100644 src/test/regress/expected/int2-SunOS.out delete mode 100644 src/test/regress/expected/int4-NetBSD.out delete mode 100644 src/test/regress/expected/int4-OSF1.out delete mode 100644 src/test/regress/expected/int4-SunOS.out diff --git a/src/test/regress/expected/int2-NetBSD.out b/src/test/regress/expected/int2-NetBSD.out deleted file mode 100644 index c35f1737eb..0000000000 --- a/src/test/regress/expected/int2-NetBSD.out +++ /dev/null @@ -1,206 +0,0 @@ -QUERY: CREATE TABLE INT2_TBL(f1 int2); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('0'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('1234'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-1234'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('34.5'); -ERROR: pg_atoi: error in "34.5": can't parse ".5" -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('32767'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-32767'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('100000'); -ERROR: pg_atoi: error reading "100000": Result too large -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('asdf'); -ERROR: pg_atoi: error in "asdf": can't parse "asdf" -QUERY: SELECT '' AS five, INT2_TBL.*; -five| f1 -----+------ - | 0 - | 1234 - | -1234 - | 32767 - |-32767 -(5 rows) - -QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int2; -four| f1 -----+------ - | 1234 - | -1234 - | 32767 - |-32767 -(4 rows) - -QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int4; -four| f1 -----+------ - | 1234 - | -1234 - | 32767 - |-32767 -(4 rows) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int2; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int4; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int2; -two| f1 ----+------ - | -1234 - |-32767 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int4; -two| f1 ----+------ - | -1234 - |-32767 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int2; -three| f1 ------+------ - | 0 - | -1234 - |-32767 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int4; -three| f1 ------+------ - | 0 - | -1234 - |-32767 -(3 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int2; -two| f1 ----+----- - | 1234 - |32767 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int4; -two| f1 ----+----- - | 1234 - |32767 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int2; -three| f1 ------+----- - | 0 - | 1234 - |32767 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int4; -three| f1 ------+----- - | 0 - | 1234 - |32767 -(3 rows) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2; -one| f1 ----+----- - |32767 -(1 row) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2; -three| f1 ------+----- - | 0 - | 1234 - |-1234 -(3 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+----- - | 0| 0 - | 1234| 2468 - | -1234|-2468 - | 32767| -2 - |-32767| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 2468 - | -1234| -2468 - | 32767| 65534 - |-32767|-65534 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 2 - | 1234| 1236 - | -1234| -1232 - | 32767|-32767 - |-32767|-32765 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 2 - | 1234| 1236 - | -1234| -1232 - | 32767| 32769 - |-32767|-32765 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+----- - | 0| -2 - | 1234| 1232 - | -1234|-1236 - | 32767|32765 - |-32767|32767 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| -2 - | 1234| 1232 - | -1234| -1236 - | 32767| 32765 - |-32767|-32769 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 617 - | -1234| -617 - | 32767| 16383 - |-32767|-16383 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 617 - | -1234| -617 - | 32767| 16383 - |-32767|-16383 -(5 rows) - diff --git a/src/test/regress/expected/int2-OSF1.out b/src/test/regress/expected/int2-OSF1.out deleted file mode 100644 index c35f1737eb..0000000000 --- a/src/test/regress/expected/int2-OSF1.out +++ /dev/null @@ -1,206 +0,0 @@ -QUERY: CREATE TABLE INT2_TBL(f1 int2); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('0'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('1234'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-1234'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('34.5'); -ERROR: pg_atoi: error in "34.5": can't parse ".5" -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('32767'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-32767'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('100000'); -ERROR: pg_atoi: error reading "100000": Result too large -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('asdf'); -ERROR: pg_atoi: error in "asdf": can't parse "asdf" -QUERY: SELECT '' AS five, INT2_TBL.*; -five| f1 -----+------ - | 0 - | 1234 - | -1234 - | 32767 - |-32767 -(5 rows) - -QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int2; -four| f1 -----+------ - | 1234 - | -1234 - | 32767 - |-32767 -(4 rows) - -QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int4; -four| f1 -----+------ - | 1234 - | -1234 - | 32767 - |-32767 -(4 rows) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int2; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int4; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int2; -two| f1 ----+------ - | -1234 - |-32767 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int4; -two| f1 ----+------ - | -1234 - |-32767 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int2; -three| f1 ------+------ - | 0 - | -1234 - |-32767 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int4; -three| f1 ------+------ - | 0 - | -1234 - |-32767 -(3 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int2; -two| f1 ----+----- - | 1234 - |32767 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int4; -two| f1 ----+----- - | 1234 - |32767 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int2; -three| f1 ------+----- - | 0 - | 1234 - |32767 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int4; -three| f1 ------+----- - | 0 - | 1234 - |32767 -(3 rows) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2; -one| f1 ----+----- - |32767 -(1 row) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2; -three| f1 ------+----- - | 0 - | 1234 - |-1234 -(3 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+----- - | 0| 0 - | 1234| 2468 - | -1234|-2468 - | 32767| -2 - |-32767| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 2468 - | -1234| -2468 - | 32767| 65534 - |-32767|-65534 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 2 - | 1234| 1236 - | -1234| -1232 - | 32767|-32767 - |-32767|-32765 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 2 - | 1234| 1236 - | -1234| -1232 - | 32767| 32769 - |-32767|-32765 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+----- - | 0| -2 - | 1234| 1232 - | -1234|-1236 - | 32767|32765 - |-32767|32767 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| -2 - | 1234| 1232 - | -1234| -1236 - | 32767| 32765 - |-32767|-32769 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 617 - | -1234| -617 - | 32767| 16383 - |-32767|-16383 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 617 - | -1234| -617 - | 32767| 16383 - |-32767|-16383 -(5 rows) - diff --git a/src/test/regress/expected/int2-SunOS.out b/src/test/regress/expected/int2-SunOS.out deleted file mode 100644 index c35f1737eb..0000000000 --- a/src/test/regress/expected/int2-SunOS.out +++ /dev/null @@ -1,206 +0,0 @@ -QUERY: CREATE TABLE INT2_TBL(f1 int2); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('0'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('1234'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-1234'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('34.5'); -ERROR: pg_atoi: error in "34.5": can't parse ".5" -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('32767'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('-32767'); -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('100000'); -ERROR: pg_atoi: error reading "100000": Result too large -QUERY: INSERT INTO INT2_TBL(f1) VALUES ('asdf'); -ERROR: pg_atoi: error in "asdf": can't parse "asdf" -QUERY: SELECT '' AS five, INT2_TBL.*; -five| f1 -----+------ - | 0 - | 1234 - | -1234 - | 32767 - |-32767 -(5 rows) - -QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int2; -four| f1 -----+------ - | 1234 - | -1234 - | 32767 - |-32767 -(4 rows) - -QUERY: SELECT '' AS four, i.* FROM INT2_TBL i WHERE i.f1 <> '0'::int4; -four| f1 -----+------ - | 1234 - | -1234 - | 32767 - |-32767 -(4 rows) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int2; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE i.f1 = '0'::int4; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int2; -two| f1 ----+------ - | -1234 - |-32767 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 < '0'::int4; -two| f1 ----+------ - | -1234 - |-32767 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int2; -three| f1 ------+------ - | 0 - | -1234 - |-32767 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 <= '0'::int4; -three| f1 ------+------ - | 0 - | -1234 - |-32767 -(3 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int2; -two| f1 ----+----- - | 1234 - |32767 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT2_TBL i WHERE i.f1 > '0'::int4; -two| f1 ----+----- - | 1234 - |32767 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int2; -three| f1 ------+----- - | 0 - | 1234 - |32767 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE i.f1 >= '0'::int4; -three| f1 ------+----- - | 0 - | 1234 - |32767 -(3 rows) - -QUERY: SELECT '' AS one, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2; -one| f1 ----+----- - |32767 -(1 row) - -QUERY: SELECT '' AS three, i.* FROM INT2_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2; -three| f1 ------+----- - | 0 - | 1234 - |-1234 -(3 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+----- - | 0| 0 - | 1234| 2468 - | -1234|-2468 - | 32767| -2 - |-32767| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 2468 - | -1234| -2468 - | 32767| 65534 - |-32767|-65534 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 2 - | 1234| 1236 - | -1234| -1232 - | 32767|-32767 - |-32767|-32765 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 2 - | 1234| 1236 - | -1234| -1232 - | 32767| 32769 - |-32767|-32765 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+----- - | 0| -2 - | 1234| 1232 - | -1234|-1236 - | 32767|32765 - |-32767|32767 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| -2 - | 1234| 1232 - | -1234| -1236 - | 32767| 32765 - |-32767|-32769 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 617 - | -1234| -617 - | 32767| 16383 - |-32767|-16383 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT2_TBL i; -five| f1| x -----+------+------ - | 0| 0 - | 1234| 617 - | -1234| -617 - | 32767| 16383 - |-32767|-16383 -(5 rows) - diff --git a/src/test/regress/expected/int4-NetBSD.out b/src/test/regress/expected/int4-NetBSD.out deleted file mode 100644 index 5b55ab7ea1..0000000000 --- a/src/test/regress/expected/int4-NetBSD.out +++ /dev/null @@ -1,302 +0,0 @@ -QUERY: CREATE TABLE INT4_TBL(f1 int4); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('0'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('123456'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-123456'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('34.5'); -ERROR: pg_atoi: error in "34.5": can't parse ".5" -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('2147483647'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-2147483647'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); -ERROR: pg_atoi: error reading "1000000000000": Result too large -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('asdf'); -ERROR: pg_atoi: error in "asdf": can't parse "asdf" -QUERY: SELECT '' AS five, INT4_TBL.*; -five| f1 -----+----------- - | 0 - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(5 rows) - -QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int2; -four| f1 -----+----------- - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(4 rows) - -QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int4; -four| f1 -----+----------- - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(4 rows) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int2; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int4; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int2; -two| f1 ----+----------- - | -123456 - |-2147483647 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int4; -two| f1 ----+----------- - | -123456 - |-2147483647 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int2; -three| f1 ------+----------- - | 0 - | -123456 - |-2147483647 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int4; -three| f1 ------+----------- - | 0 - | -123456 - |-2147483647 -(3 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int2; -two| f1 ----+---------- - | 123456 - |2147483647 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int4; -two| f1 ----+---------- - | 123456 - |2147483647 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int2; -three| f1 ------+---------- - | 0 - | 123456 - |2147483647 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int4; -three| f1 ------+---------- - | 0 - | 123456 - |2147483647 -(3 rows) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2; -one| f1 ----+---------- - |2147483647 -(1 row) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2; -three| f1 ------+------- - | 0 - | 123456 - |-123456 -(3 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+------- - | 0| 0 - | 123456| 246912 - | -123456|-246912 - | 2147483647| -2 - |-2147483647| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+------- - | 0| 0 - | 123456| 246912 - | -123456|-246912 - | 2147483647| -2 - |-2147483647| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 2 - | 123456| 123458 - | -123456| -123454 - | 2147483647|-2147483647 - |-2147483647|-2147483645 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 2 - | 123456| 123458 - | -123456| -123454 - | 2147483647|-2147483647 - |-2147483647|-2147483645 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+---------- - | 0| -2 - | 123456| 123454 - | -123456| -123458 - | 2147483647|2147483645 - |-2147483647|2147483647 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+---------- - | 0| -2 - | 123456| 123454 - | -123456| -123458 - | 2147483647|2147483645 - |-2147483647|2147483647 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 0 - | 123456| 61728 - | -123456| -61728 - | 2147483647| 1073741823 - |-2147483647|-1073741823 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 0 - | 123456| 61728 - | -123456| -61728 - | 2147483647| 1073741823 - |-2147483647|-1073741823 -(5 rows) - -QUERY: SELECT -2+3 AS one; -one ---- - 1 -(1 row) - -QUERY: SELECT 4-2 AS two; -two ---- - 2 -(1 row) - -QUERY: SELECT 2- -1 AS three; -three ------ - 3 -(1 row) - -QUERY: SELECT 2 - -2 AS four; -four ----- - 4 -(1 row) - -QUERY: SELECT '2'::int2 * '2'::int2 = '16'::int2 / '4'::int2 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '2'::int4 * '2'::int2 = '16'::int2 / '4'::int4 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '2'::int2 * '2'::int4 = '16'::int4 / '4'::int2 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '1000'::int4 < '999'::int4 AS false; -false ------ -f -(1 row) - -QUERY: SELECT 4! AS twenty_four; -twenty_four ------------ - 24 -(1 row) - -QUERY: SELECT !!3 AS six; -six ---- - 6 -(1 row) - -QUERY: SELECT 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 AS ten; -ten ---- - 10 -(1 row) - -QUERY: SELECT 2 + 2 / 2 AS three; -three ------ - 3 -(1 row) - -QUERY: SELECT (2 + 2) / 2 AS two; -two ---- - 2 -(1 row) - -QUERY: SELECT dsqrt('64'::float8) AS eight; -eight ------ - 8 -(1 row) - -QUERY: SELECT |/'64'::float8 AS eight; -eight ------ - 8 -(1 row) - -QUERY: SELECT ||/'27'::float8 AS three; -three ------ - 3 -(1 row) - diff --git a/src/test/regress/expected/int4-OSF1.out b/src/test/regress/expected/int4-OSF1.out deleted file mode 100644 index 5b55ab7ea1..0000000000 --- a/src/test/regress/expected/int4-OSF1.out +++ /dev/null @@ -1,302 +0,0 @@ -QUERY: CREATE TABLE INT4_TBL(f1 int4); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('0'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('123456'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-123456'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('34.5'); -ERROR: pg_atoi: error in "34.5": can't parse ".5" -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('2147483647'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-2147483647'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); -ERROR: pg_atoi: error reading "1000000000000": Result too large -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('asdf'); -ERROR: pg_atoi: error in "asdf": can't parse "asdf" -QUERY: SELECT '' AS five, INT4_TBL.*; -five| f1 -----+----------- - | 0 - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(5 rows) - -QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int2; -four| f1 -----+----------- - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(4 rows) - -QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int4; -four| f1 -----+----------- - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(4 rows) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int2; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int4; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int2; -two| f1 ----+----------- - | -123456 - |-2147483647 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int4; -two| f1 ----+----------- - | -123456 - |-2147483647 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int2; -three| f1 ------+----------- - | 0 - | -123456 - |-2147483647 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int4; -three| f1 ------+----------- - | 0 - | -123456 - |-2147483647 -(3 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int2; -two| f1 ----+---------- - | 123456 - |2147483647 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int4; -two| f1 ----+---------- - | 123456 - |2147483647 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int2; -three| f1 ------+---------- - | 0 - | 123456 - |2147483647 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int4; -three| f1 ------+---------- - | 0 - | 123456 - |2147483647 -(3 rows) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2; -one| f1 ----+---------- - |2147483647 -(1 row) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2; -three| f1 ------+------- - | 0 - | 123456 - |-123456 -(3 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+------- - | 0| 0 - | 123456| 246912 - | -123456|-246912 - | 2147483647| -2 - |-2147483647| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+------- - | 0| 0 - | 123456| 246912 - | -123456|-246912 - | 2147483647| -2 - |-2147483647| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 2 - | 123456| 123458 - | -123456| -123454 - | 2147483647|-2147483647 - |-2147483647|-2147483645 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 2 - | 123456| 123458 - | -123456| -123454 - | 2147483647|-2147483647 - |-2147483647|-2147483645 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+---------- - | 0| -2 - | 123456| 123454 - | -123456| -123458 - | 2147483647|2147483645 - |-2147483647|2147483647 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+---------- - | 0| -2 - | 123456| 123454 - | -123456| -123458 - | 2147483647|2147483645 - |-2147483647|2147483647 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 0 - | 123456| 61728 - | -123456| -61728 - | 2147483647| 1073741823 - |-2147483647|-1073741823 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 0 - | 123456| 61728 - | -123456| -61728 - | 2147483647| 1073741823 - |-2147483647|-1073741823 -(5 rows) - -QUERY: SELECT -2+3 AS one; -one ---- - 1 -(1 row) - -QUERY: SELECT 4-2 AS two; -two ---- - 2 -(1 row) - -QUERY: SELECT 2- -1 AS three; -three ------ - 3 -(1 row) - -QUERY: SELECT 2 - -2 AS four; -four ----- - 4 -(1 row) - -QUERY: SELECT '2'::int2 * '2'::int2 = '16'::int2 / '4'::int2 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '2'::int4 * '2'::int2 = '16'::int2 / '4'::int4 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '2'::int2 * '2'::int4 = '16'::int4 / '4'::int2 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '1000'::int4 < '999'::int4 AS false; -false ------ -f -(1 row) - -QUERY: SELECT 4! AS twenty_four; -twenty_four ------------ - 24 -(1 row) - -QUERY: SELECT !!3 AS six; -six ---- - 6 -(1 row) - -QUERY: SELECT 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 AS ten; -ten ---- - 10 -(1 row) - -QUERY: SELECT 2 + 2 / 2 AS three; -three ------ - 3 -(1 row) - -QUERY: SELECT (2 + 2) / 2 AS two; -two ---- - 2 -(1 row) - -QUERY: SELECT dsqrt('64'::float8) AS eight; -eight ------ - 8 -(1 row) - -QUERY: SELECT |/'64'::float8 AS eight; -eight ------ - 8 -(1 row) - -QUERY: SELECT ||/'27'::float8 AS three; -three ------ - 3 -(1 row) - diff --git a/src/test/regress/expected/int4-SunOS.out b/src/test/regress/expected/int4-SunOS.out deleted file mode 100644 index 5b55ab7ea1..0000000000 --- a/src/test/regress/expected/int4-SunOS.out +++ /dev/null @@ -1,302 +0,0 @@ -QUERY: CREATE TABLE INT4_TBL(f1 int4); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('0'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('123456'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-123456'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('34.5'); -ERROR: pg_atoi: error in "34.5": can't parse ".5" -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('2147483647'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('-2147483647'); -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('1000000000000'); -ERROR: pg_atoi: error reading "1000000000000": Result too large -QUERY: INSERT INTO INT4_TBL(f1) VALUES ('asdf'); -ERROR: pg_atoi: error in "asdf": can't parse "asdf" -QUERY: SELECT '' AS five, INT4_TBL.*; -five| f1 -----+----------- - | 0 - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(5 rows) - -QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int2; -four| f1 -----+----------- - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(4 rows) - -QUERY: SELECT '' AS four, i.* FROM INT4_TBL i WHERE i.f1 <> '0'::int4; -four| f1 -----+----------- - | 123456 - | -123456 - | 2147483647 - |-2147483647 -(4 rows) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int2; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE i.f1 = '0'::int4; -one|f1 ----+-- - | 0 -(1 row) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int2; -two| f1 ----+----------- - | -123456 - |-2147483647 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 < '0'::int4; -two| f1 ----+----------- - | -123456 - |-2147483647 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int2; -three| f1 ------+----------- - | 0 - | -123456 - |-2147483647 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 <= '0'::int4; -three| f1 ------+----------- - | 0 - | -123456 - |-2147483647 -(3 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int2; -two| f1 ----+---------- - | 123456 - |2147483647 -(2 rows) - -QUERY: SELECT '' AS two, i.* FROM INT4_TBL i WHERE i.f1 > '0'::int4; -two| f1 ----+---------- - | 123456 - |2147483647 -(2 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int2; -three| f1 ------+---------- - | 0 - | 123456 - |2147483647 -(3 rows) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE i.f1 >= '0'::int4; -three| f1 ------+---------- - | 0 - | 123456 - |2147483647 -(3 rows) - -QUERY: SELECT '' AS one, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int2) = '1'::int2; -one| f1 ----+---------- - |2147483647 -(1 row) - -QUERY: SELECT '' AS three, i.* FROM INT4_TBL i WHERE (i.f1 % '2'::int4) = '0'::int2; -three| f1 ------+------- - | 0 - | 123456 - |-123456 -(3 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+------- - | 0| 0 - | 123456| 246912 - | -123456|-246912 - | 2147483647| -2 - |-2147483647| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 * '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+------- - | 0| 0 - | 123456| 246912 - | -123456|-246912 - | 2147483647| -2 - |-2147483647| 2 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 2 - | 123456| 123458 - | -123456| -123454 - | 2147483647|-2147483647 - |-2147483647|-2147483645 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 + '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 2 - | 123456| 123458 - | -123456| -123454 - | 2147483647|-2147483647 - |-2147483647|-2147483645 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+---------- - | 0| -2 - | 123456| 123454 - | -123456| -123458 - | 2147483647|2147483645 - |-2147483647|2147483647 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 - '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+---------- - | 0| -2 - | 123456| 123454 - | -123456| -123458 - | 2147483647|2147483645 - |-2147483647|2147483647 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int2 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 0 - | 123456| 61728 - | -123456| -61728 - | 2147483647| 1073741823 - |-2147483647|-1073741823 -(5 rows) - -QUERY: SELECT '' AS five, i.f1, i.f1 / '2'::int4 AS x FROM INT4_TBL i; -five| f1| x -----+-----------+----------- - | 0| 0 - | 123456| 61728 - | -123456| -61728 - | 2147483647| 1073741823 - |-2147483647|-1073741823 -(5 rows) - -QUERY: SELECT -2+3 AS one; -one ---- - 1 -(1 row) - -QUERY: SELECT 4-2 AS two; -two ---- - 2 -(1 row) - -QUERY: SELECT 2- -1 AS three; -three ------ - 3 -(1 row) - -QUERY: SELECT 2 - -2 AS four; -four ----- - 4 -(1 row) - -QUERY: SELECT '2'::int2 * '2'::int2 = '16'::int2 / '4'::int2 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '2'::int4 * '2'::int2 = '16'::int2 / '4'::int4 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '2'::int2 * '2'::int4 = '16'::int4 / '4'::int2 AS true; -true ----- -t -(1 row) - -QUERY: SELECT '1000'::int4 < '999'::int4 AS false; -false ------ -f -(1 row) - -QUERY: SELECT 4! AS twenty_four; -twenty_four ------------ - 24 -(1 row) - -QUERY: SELECT !!3 AS six; -six ---- - 6 -(1 row) - -QUERY: SELECT 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 AS ten; -ten ---- - 10 -(1 row) - -QUERY: SELECT 2 + 2 / 2 AS three; -three ------ - 3 -(1 row) - -QUERY: SELECT (2 + 2) / 2 AS two; -two ---- - 2 -(1 row) - -QUERY: SELECT dsqrt('64'::float8) AS eight; -eight ------ - 8 -(1 row) - -QUERY: SELECT |/'64'::float8 AS eight; -eight ------ - 8 -(1 row) - -QUERY: SELECT ||/'27'::float8 AS three; -three ------ - 3 -(1 row) - -- 2.40.0