This is an automated email from the ASF dual-hosted git repository.
chenjinbao1989 pushed a commit to branch cbdb-postgres-merge
in repository https://gitbox.apache.org/repos/asf/cloudberry.git
The following commit(s) were added to refs/heads/cbdb-postgres-merge by this
push:
new efdbad28abf Fix some answer file for parallel schedule in pax
efdbad28abf is described below
commit efdbad28abf57d9eea7ad30fe28975bf63c49291
Author: Jinbao Chen <[email protected]>
AuthorDate: Sat Mar 14 22:43:09 2026 -0400
Fix some answer file for parallel schedule in pax
---
.../src/test/regress/expected/copydml.out | 6 +-
.../src/test/regress/expected/copyselect.out | 10 ++
.../src/test/regress/expected/create_index.out | 16 +-
.../src/test/regress/expected/create_view.out | 166 ++++++++++-----------
.../pax_storage/src/test/regress/expected/date.out | 28 ++--
.../src/test/regress/expected/expressions.out | 24 +--
.../src/test/regress/expected/geometry.out | 88 +++++++++--
.../src/test/regress/expected/horology.out | 80 +++++-----
.../src/test/regress/expected/interval.out | 4 +-
.../src/test/regress/expected/misc_sanity.out | 30 +++-
.../src/test/regress/expected/numeric.out | 130 ++++++++--------
.../src/test/regress/expected/opr_sanity.out | 16 +-
.../src/test/regress/expected/regproc.out | 28 +++-
.../pax_storage/src/test/regress/expected/time.out | 6 +-
.../src/test/regress/expected/timestamp.out | 6 +-
.../src/test/regress/expected/timestamptz.out | 130 ++++++++--------
.../src/test/regress/expected/timetz.out | 4 +-
.../src/test/regress/expected/tstypes.out | 12 +-
.../pax_storage/src/test/regress/expected/xid.out | 32 ++--
.../src/test/regress/input/tablespace.source | 2 +
.../src/test/regress/output/tablespace.source | 1 +
21 files changed, 462 insertions(+), 357 deletions(-)
diff --git a/contrib/pax_storage/src/test/regress/expected/copydml.out
b/contrib/pax_storage/src/test/regress/expected/copydml.out
index af5b38296ad..c3845d80973 100644
--- a/contrib/pax_storage/src/test/regress/expected/copydml.out
+++ b/contrib/pax_storage/src/test/regress/expected/copydml.out
@@ -38,7 +38,7 @@ ERROR: DO INSTEAD NOTHING rules are not supported for COPY
drop rule qqq on copydml_test;
create rule qqq as on insert to copydml_test do also delete from copydml_test;
copy (insert into copydml_test default values) to stdout;
-ERROR: DO ALSO rules are not supported for the COPY
+ERROR: DO ALSO rules are not supported for COPY
drop rule qqq on copydml_test;
create rule qqq as on insert to copydml_test do instead (delete from
copydml_test; delete from copydml_test);
copy (insert into copydml_test default values) to stdout;
@@ -54,7 +54,7 @@ ERROR: DO INSTEAD NOTHING rules are not supported for COPY
drop rule qqq on copydml_test;
create rule qqq as on update to copydml_test do also delete from copydml_test;
copy (update copydml_test set t = 'f') to stdout;
-ERROR: DO ALSO rules are not supported for the COPY
+ERROR: DO ALSO rules are not supported for COPY
drop rule qqq on copydml_test;
create rule qqq as on update to copydml_test do instead (delete from
copydml_test; delete from copydml_test);
copy (update copydml_test set t = 'f') to stdout;
@@ -70,7 +70,7 @@ ERROR: DO INSTEAD NOTHING rules are not supported for COPY
drop rule qqq on copydml_test;
create rule qqq as on delete to copydml_test do also insert into copydml_test
default values;
copy (delete from copydml_test) to stdout;
-ERROR: DO ALSO rules are not supported for the COPY
+ERROR: DO ALSO rules are not supported for COPY
drop rule qqq on copydml_test;
create rule qqq as on delete to copydml_test do instead (insert into
copydml_test default values; insert into copydml_test default values);
copy (delete from copydml_test) to stdout;
diff --git a/contrib/pax_storage/src/test/regress/expected/copyselect.out
b/contrib/pax_storage/src/test/regress/expected/copyselect.out
index bfa53a7fa63..e2970f9db99 100644
--- a/contrib/pax_storage/src/test/regress/expected/copyselect.out
+++ b/contrib/pax_storage/src/test/regress/expected/copyselect.out
@@ -133,6 +133,11 @@ ERROR: division by zero
copy (select 1) to stdout\; copy (select 2) to stdout\; select 0\; select 3;
-- 1 2 3
1
2
+ ?column?
+----------
+ 0
+(1 row)
+
?column?
----------
3
@@ -140,6 +145,11 @@ copy (select 1) to stdout\; copy (select 2) to stdout\;
select 0\; select 3; --
create table test3 (c int);
select 0\; copy test3 from stdin\; copy test3 from stdin\; select 1; -- 1
+ ?column?
+----------
+ 0
+(1 row)
+
?column?
----------
1
diff --git a/contrib/pax_storage/src/test/regress/expected/create_index.out
b/contrib/pax_storage/src/test/regress/expected/create_index.out
index ac4958d56dc..3d582fe5b98 100644
--- a/contrib/pax_storage/src/test/regress/expected/create_index.out
+++ b/contrib/pax_storage/src/test/regress/expected/create_index.out
@@ -2268,11 +2268,9 @@ WHERE classid = 'pg_class'::regclass AND
index concur_reindex_ind3 | column c1 of table
concur_reindex_tab | a
index concur_reindex_ind4 | column c1 of table
concur_reindex_tab | a
index concur_reindex_ind4 | column c2 of table
concur_reindex_tab | a
- materialized view concur_reindex_matview | access method pax
| n
materialized view concur_reindex_matview | schema public
| n
- table concur_reindex_tab | access method pax
| n
table concur_reindex_tab | schema public
| n
-(10 rows)
+(8 rows)
REINDEX INDEX concur_reindex_ind1;
REINDEX TABLE concur_reindex_tab;
@@ -2299,11 +2297,9 @@ WHERE classid = 'pg_class'::regclass AND
index concur_reindex_ind3 | column c1 of table
concur_reindex_tab | a
index concur_reindex_ind4 | column c1 of table
concur_reindex_tab | a
index concur_reindex_ind4 | column c2 of table
concur_reindex_tab | a
- materialized view concur_reindex_matview | access method pax
| n
materialized view concur_reindex_matview | schema public
| n
- table concur_reindex_tab | access method pax
| n
table concur_reindex_tab | schema public
| n
-(10 rows)
+(8 rows)
-- Check that comments are preserved
CREATE TABLE testcomment (i int);
@@ -2461,13 +2457,11 @@ WHERE classid = 'pg_class'::regclass AND
table concur_reindex_part | schema public
| n
table concur_reindex_part_0 | schema public
| n
table concur_reindex_part_0 | table concur_reindex_part
| a
- table concur_reindex_part_0_1 | access method pax
| n
table concur_reindex_part_0_1 | schema public
| n
table concur_reindex_part_0_1 | table concur_reindex_part_0
| a
- table concur_reindex_part_0_2 | access method pax
| n
table concur_reindex_part_0_2 | schema public
| n
table concur_reindex_part_0_2 | table concur_reindex_part_0
| a
-(21 rows)
+(19 rows)
REINDEX INDEX concur_reindex_part_index_0_1;
REINDEX INDEX concur_reindex_part_index_0_2;
@@ -2515,13 +2509,11 @@ WHERE classid = 'pg_class'::regclass AND
table concur_reindex_part | schema public
| n
table concur_reindex_part_0 | schema public
| n
table concur_reindex_part_0 | table concur_reindex_part
| a
- table concur_reindex_part_0_1 | access method pax
| n
table concur_reindex_part_0_1 | schema public
| n
table concur_reindex_part_0_1 | table concur_reindex_part_0
| a
- table concur_reindex_part_0_2 | access method pax
| n
table concur_reindex_part_0_2 | schema public
| n
table concur_reindex_part_0_2 | table concur_reindex_part_0
| a
-(21 rows)
+(19 rows)
SELECT relid, parentrelid, level FROM
pg_partition_tree('concur_reindex_part_index')
ORDER BY relid, level;
diff --git a/contrib/pax_storage/src/test/regress/expected/create_view.out
b/contrib/pax_storage/src/test/regress/expected/create_view.out
index d35d3a61066..bc50cdd27f9 100644
--- a/contrib/pax_storage/src/test/regress/expected/create_view.out
+++ b/contrib/pax_storage/src/test/regress/expected/create_view.out
@@ -346,10 +346,10 @@ CREATE VIEW tt1 AS
c | numeric | | | | main |
d | character varying(4) | | | | extended |
View definition:
- SELECT vv.a,
- vv.b,
- vv.c,
- vv.d
+ SELECT a,
+ b,
+ c,
+ d
FROM ( VALUES ('abc'::character varying(3),'0123456789'::character
varying,42,'abcd'::character varying(4)), ('0123456789'::character
varying,'abc'::character varying(3),42.12,'abc'::character varying(4))) vv(a,
b, c, d);
SELECT * FROM tt1;
@@ -391,9 +391,9 @@ CREATE VIEW aliased_view_4 AS
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.f1,
- tt1.f2,
- tt1.f3
+ SELECT f1,
+ f2,
+ f3
FROM tt1
WHERE (EXISTS ( SELECT 1
FROM tx1
@@ -407,9 +407,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a1.f1,
- a1.f2,
- a1.f3
+ SELECT f1,
+ f2,
+ f3
FROM tt1 a1
WHERE (EXISTS ( SELECT 1
FROM tx1
@@ -423,9 +423,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.f1,
- tt1.f2,
- tt1.f3
+ SELECT f1,
+ f2,
+ f3
FROM tt1
WHERE (EXISTS ( SELECT 1
FROM tx1 a2
@@ -439,9 +439,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.y1,
- tt1.f2,
- tt1.f3
+ SELECT y1,
+ f2,
+ f3
FROM temp_view_test.tt1
WHERE (EXISTS ( SELECT 1
FROM tt1 tt1_1
@@ -456,9 +456,9 @@ ALTER TABLE tx1 RENAME TO a1;
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.f1,
- tt1.f2,
- tt1.f3
+ SELECT f1,
+ f2,
+ f3
FROM tt1
WHERE (EXISTS ( SELECT 1
FROM a1
@@ -472,9 +472,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a1.f1,
- a1.f2,
- a1.f3
+ SELECT f1,
+ f2,
+ f3
FROM tt1 a1
WHERE (EXISTS ( SELECT 1
FROM a1 a1_1
@@ -488,9 +488,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.f1,
- tt1.f2,
- tt1.f3
+ SELECT f1,
+ f2,
+ f3
FROM tt1
WHERE (EXISTS ( SELECT 1
FROM a1 a2
@@ -504,9 +504,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.y1,
- tt1.f2,
- tt1.f3
+ SELECT y1,
+ f2,
+ f3
FROM temp_view_test.tt1
WHERE (EXISTS ( SELECT 1
FROM tt1 tt1_1
@@ -521,9 +521,9 @@ ALTER TABLE tt1 RENAME TO a2;
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a2.f1,
- a2.f2,
- a2.f3
+ SELECT f1,
+ f2,
+ f3
FROM a2
WHERE (EXISTS ( SELECT 1
FROM a1
@@ -537,9 +537,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a1.f1,
- a1.f2,
- a1.f3
+ SELECT f1,
+ f2,
+ f3
FROM a2 a1
WHERE (EXISTS ( SELECT 1
FROM a1 a1_1
@@ -553,9 +553,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a2.f1,
- a2.f2,
- a2.f3
+ SELECT f1,
+ f2,
+ f3
FROM a2
WHERE (EXISTS ( SELECT 1
FROM a1 a2_1
@@ -569,9 +569,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.y1,
- tt1.f2,
- tt1.f3
+ SELECT y1,
+ f2,
+ f3
FROM temp_view_test.tt1
WHERE (EXISTS ( SELECT 1
FROM a2
@@ -586,9 +586,9 @@ ALTER TABLE a1 RENAME TO tt1;
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a2.f1,
- a2.f2,
- a2.f3
+ SELECT f1,
+ f2,
+ f3
FROM a2
WHERE (EXISTS ( SELECT 1
FROM tt1
@@ -602,9 +602,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a1.f1,
- a1.f2,
- a1.f3
+ SELECT f1,
+ f2,
+ f3
FROM a2 a1
WHERE (EXISTS ( SELECT 1
FROM tt1
@@ -618,9 +618,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a2.f1,
- a2.f2,
- a2.f3
+ SELECT f1,
+ f2,
+ f3
FROM a2
WHERE (EXISTS ( SELECT 1
FROM tt1 a2_1
@@ -634,9 +634,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.y1,
- tt1.f2,
- tt1.f3
+ SELECT y1,
+ f2,
+ f3
FROM temp_view_test.tt1
WHERE (EXISTS ( SELECT 1
FROM a2
@@ -652,9 +652,9 @@ ALTER TABLE tx1 SET SCHEMA temp_view_test;
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tx1.f1,
- tx1.f2,
- tx1.f3
+ SELECT f1,
+ f2,
+ f3
FROM temp_view_test.tx1
WHERE (EXISTS ( SELECT 1
FROM tt1
@@ -668,9 +668,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a1.f1,
- a1.f2,
- a1.f3
+ SELECT f1,
+ f2,
+ f3
FROM temp_view_test.tx1 a1
WHERE (EXISTS ( SELECT 1
FROM tt1
@@ -684,9 +684,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tx1.f1,
- tx1.f2,
- tx1.f3
+ SELECT f1,
+ f2,
+ f3
FROM temp_view_test.tx1
WHERE (EXISTS ( SELECT 1
FROM tt1 a2
@@ -700,9 +700,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tt1.y1,
- tt1.f2,
- tt1.f3
+ SELECT y1,
+ f2,
+ f3
FROM temp_view_test.tt1
WHERE (EXISTS ( SELECT 1
FROM temp_view_test.tx1
@@ -719,9 +719,9 @@ ALTER TABLE tmp1 RENAME TO tx1;
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tx1.f1,
- tx1.f2,
- tx1.f3
+ SELECT f1,
+ f2,
+ f3
FROM temp_view_test.tx1
WHERE (EXISTS ( SELECT 1
FROM tt1
@@ -735,9 +735,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT a1.f1,
- a1.f2,
- a1.f3
+ SELECT f1,
+ f2,
+ f3
FROM temp_view_test.tx1 a1
WHERE (EXISTS ( SELECT 1
FROM tt1
@@ -751,9 +751,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tx1.f1,
- tx1.f2,
- tx1.f3
+ SELECT f1,
+ f2,
+ f3
FROM temp_view_test.tx1
WHERE (EXISTS ( SELECT 1
FROM tt1 a2
@@ -767,9 +767,9 @@ View definition:
f2 | integer | | | | plain |
f3 | text | | | | extended |
View definition:
- SELECT tx1.y1,
- tx1.f2,
- tx1.f3
+ SELECT y1,
+ f2,
+ f3
FROM tx1
WHERE (EXISTS ( SELECT 1
FROM temp_view_test.tx1 tx1_1
@@ -1256,10 +1256,10 @@ select pg_get_viewdef('v1', true);
select pg_get_viewdef('v4', true);
pg_get_viewdef
----------------
- SELECT v1.b, +
- v1.c, +
- v1.x AS a,+
- v1.ax +
+ SELECT b, +
+ c, +
+ x AS a, +
+ ax +
FROM v1;
(1 row)
@@ -1536,9 +1536,9 @@ create view tt14v as select t.* from tt14f() t;
select pg_get_viewdef('tt14v', true);
pg_get_viewdef
--------------------------------
- SELECT t.f1, +
- t.f3, +
- t.f4 +
+ SELECT f1, +
+ f3, +
+ f4 +
FROM tt14f() t(f1, f3, f4);
(1 row)
diff --git a/contrib/pax_storage/src/test/regress/expected/date.out
b/contrib/pax_storage/src/test/regress/expected/date.out
index c8b0566ff40..341123978ce 100644
--- a/contrib/pax_storage/src/test/regress/expected/date.out
+++ b/contrib/pax_storage/src/test/regress/expected/date.out
@@ -1129,15 +1129,15 @@ SELECT EXTRACT(DECADE FROM DATE '0012-12-31 BC'); -- -2
-- all possible fields
--
SELECT EXTRACT(MICROSECONDS FROM DATE '2020-08-11');
-ERROR: date units "microseconds" not supported
+ERROR: unit "microseconds" not supported for type date
SELECT EXTRACT(MILLISECONDS FROM DATE '2020-08-11');
-ERROR: date units "milliseconds" not supported
+ERROR: unit "milliseconds" not supported for type date
SELECT EXTRACT(SECOND FROM DATE '2020-08-11');
-ERROR: date units "second" not supported
+ERROR: unit "second" not supported for type date
SELECT EXTRACT(MINUTE FROM DATE '2020-08-11');
-ERROR: date units "minute" not supported
+ERROR: unit "minute" not supported for type date
SELECT EXTRACT(HOUR FROM DATE '2020-08-11');
-ERROR: date units "hour" not supported
+ERROR: unit "hour" not supported for type date
SELECT EXTRACT(DAY FROM DATE '2020-08-11');
extract
---------
@@ -1235,11 +1235,11 @@ SELECT EXTRACT(DOY FROM DATE '2020-08-11');
(1 row)
SELECT EXTRACT(TIMEZONE FROM DATE '2020-08-11');
-ERROR: date units "timezone" not supported
+ERROR: unit "timezone" not supported for type date
SELECT EXTRACT(TIMEZONE_M FROM DATE '2020-08-11');
-ERROR: date units "timezone_m" not supported
+ERROR: unit "timezone_m" not supported for type date
SELECT EXTRACT(TIMEZONE_H FROM DATE '2020-08-11');
-ERROR: date units "timezone_h" not supported
+ERROR: unit "timezone_h" not supported for type date
SELECT EXTRACT(EPOCH FROM DATE '2020-08-11');
extract
------------
@@ -1264,7 +1264,7 @@ SELECT DATE_TRUNC('MILLENNIUM', TIMESTAMP '1970-03-20
04:30:00.00000'); -- 1001
SELECT DATE_TRUNC('MILLENNIUM', DATE '1970-03-20'); -- 1001-01-01
date_trunc
------------------------------
- Thu Jan 01 00:00:00 1001 PST
+ Thu Jan 01 00:00:00 1001 LMT
(1 row)
SELECT DATE_TRUNC('CENTURY', TIMESTAMP '1970-03-20 04:30:00.00000'); -- 1901
@@ -1288,13 +1288,13 @@ SELECT DATE_TRUNC('CENTURY', DATE '2004-08-10'); --
2001-01-01
SELECT DATE_TRUNC('CENTURY', DATE '0002-02-04'); -- 0001-01-01
date_trunc
------------------------------
- Mon Jan 01 00:00:00 0001 PST
+ Mon Jan 01 00:00:00 0001 LMT
(1 row)
SELECT DATE_TRUNC('CENTURY', DATE '0055-08-10 BC'); -- 0100-01-01 BC
date_trunc
---------------------------------
- Tue Jan 01 00:00:00 0100 PST BC
+ Tue Jan 01 00:00:00 0100 LMT BC
(1 row)
SELECT DATE_TRUNC('DECADE', DATE '1993-12-25'); -- 1990-01-01
@@ -1306,13 +1306,13 @@ SELECT DATE_TRUNC('DECADE', DATE '1993-12-25'); --
1990-01-01
SELECT DATE_TRUNC('DECADE', DATE '0004-12-25'); -- 0001-01-01 BC
date_trunc
---------------------------------
- Sat Jan 01 00:00:00 0001 PST BC
+ Sat Jan 01 00:00:00 0001 LMT BC
(1 row)
SELECT DATE_TRUNC('DECADE', DATE '0002-12-31 BC'); -- 0011-01-01 BC
date_trunc
---------------------------------
- Mon Jan 01 00:00:00 0011 PST BC
+ Mon Jan 01 00:00:00 0011 LMT BC
(1 row)
--
@@ -1462,7 +1462,7 @@ SELECT EXTRACT(EPOCH FROM DATE 'infinity'); --
Infinity
-- wrong fields from non-finite date:
--
SELECT EXTRACT(MICROSEC FROM DATE 'infinity'); -- error
-ERROR: date units "microsec" not recognized
+ERROR: unit "microsec" not recognized for type date
-- test constructors
select make_date(2013, 7, 15);
make_date
diff --git a/contrib/pax_storage/src/test/regress/expected/expressions.out
b/contrib/pax_storage/src/test/regress/expected/expressions.out
index 4168cd55af6..9594db9d668 100644
--- a/contrib/pax_storage/src/test/regress/expected/expressions.out
+++ b/contrib/pax_storage/src/test/regress/expected/expressions.out
@@ -187,12 +187,12 @@ create view numeric_view as
f2164 | numeric(16,4) | | | | main |
f2n | numeric | | | | main |
View definition:
- SELECT numeric_tbl.f1,
- numeric_tbl.f1::numeric(16,4) AS f1164,
- numeric_tbl.f1::numeric AS f1n,
- numeric_tbl.f2,
- numeric_tbl.f2::numeric(16,4) AS f2164,
- numeric_tbl.f2 AS f2n
+ SELECT f1,
+ f1::numeric(16,4) AS f1164,
+ f1::numeric AS f1n,
+ f2,
+ f2::numeric(16,4) AS f2164,
+ f2 AS f2n
FROM numeric_tbl;
explain (verbose, costs off) select * from numeric_view;
@@ -224,12 +224,12 @@ create view bpchar_view as
f214 | character(14) | | | | extended |
f2n | bpchar | | | | extended |
View definition:
- SELECT bpchar_tbl.f1,
- bpchar_tbl.f1::character(14) AS f114,
- bpchar_tbl.f1::bpchar AS f1n,
- bpchar_tbl.f2,
- bpchar_tbl.f2::character(14) AS f214,
- bpchar_tbl.f2 AS f2n
+ SELECT f1,
+ f1::character(14) AS f114,
+ f1::bpchar AS f1n,
+ f2,
+ f2::character(14) AS f214,
+ f2 AS f2n
FROM bpchar_tbl;
explain (verbose, costs off) select * from bpchar_view
diff --git a/contrib/pax_storage/src/test/regress/expected/geometry.out
b/contrib/pax_storage/src/test/regress/expected/geometry.out
index 83f15159660..5307b3da34a 100644
--- a/contrib/pax_storage/src/test/regress/expected/geometry.out
+++ b/contrib/pax_storage/src/test/regress/expected/geometry.out
@@ -1470,9 +1470,15 @@ SELECT l1.s, l2.s, l1.s <-> l2.s FROM LINE_TBL l1,
LINE_TBL l2;
-- Distance to box
SELECT l.s, b.f1, l.s <-> b.f1 FROM LINE_TBL l, BOX_TBL b;
-ERROR: function "dist_lb" not implemented
+ERROR: operator does not exist: line <-> box
+LINE 1: SELECT l.s, b.f1, l.s <-> b.f1 FROM LINE_TBL l, BOX_TBL b;
+ ^
+HINT: No operator matches the given name and argument types. You might need
to add explicit type casts.
SELECT l.s, b.f1, b.f1 <-> l.s FROM LINE_TBL l, BOX_TBL b;
-ERROR: function "dist_bl" not implemented
+ERROR: operator does not exist: box <-> line
+LINE 1: SELECT l.s, b.f1, b.f1 <-> l.s FROM LINE_TBL l, BOX_TBL b;
+ ^
+HINT: No operator matches the given name and argument types. You might need
to add explicit type casts.
-- Intersect with line
SELECT l1.s, l2.s FROM LINE_TBL l1, LINE_TBL l2 WHERE l1.s ?# l2.s;
s | s
@@ -1776,7 +1782,10 @@ SELECT l.s, l1.s, l.s ## l1.s FROM LINE_TBL l, LSEG_TBL
l1;
-- Closest point to box
SELECT l.s, b.f1, l.s ## b.f1 FROM LINE_TBL l, BOX_TBL b;
-ERROR: function "close_lb" not implemented
+ERROR: operator does not exist: line ## box
+LINE 1: SELECT l.s, b.f1, l.s ## b.f1 FROM LINE_TBL l, BOX_TBL b;
+ ^
+HINT: No operator matches the given name and argument types. You might need
to add explicit type casts.
--
-- Line segments
--
@@ -2379,7 +2388,10 @@ SELECT l1.s, l2.s, l1.s # l2.s FROM LSEG_TBL l1,
LSEG_TBL l2;
-- Closest point to line
SELECT l.s, l1.s, l.s ## l1.s FROM LSEG_TBL l, LINE_TBL l1;
-ERROR: function "close_sl" not implemented
+ERROR: operator does not exist: lseg ## line
+LINE 1: SELECT l.s, l1.s, l.s ## l1.s FROM LSEG_TBL l, LINE_TBL l1;
+ ^
+HINT: No operator matches the given name and argument types. You might need
to add explicit type casts.
-- Closest point to line segment
SELECT l1.s, l2.s, l1.s ## l2.s FROM LSEG_TBL l1, LSEG_TBL l2;
s | s |
?column?
@@ -2925,7 +2937,10 @@ SELECT f1, @-@ f1 FROM PATH_TBL;
-- Center
SELECT f1, @@ f1 FROM PATH_TBL;
-ERROR: function "path_center" not implemented
+ERROR: operator does not exist: @@ path
+LINE 1: SELECT f1, @@ f1 FROM PATH_TBL;
+ ^
+HINT: No operator matches the given name and argument type. You might need to
add an explicit type cast.
-- To polygon
SELECT f1, f1::polygon FROM PATH_TBL WHERE isclosed(f1);
f1 | f1
@@ -4191,7 +4206,59 @@ SELECT p1.f1, p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2
WHERE p1.f1 |&> p2.f1;
-- Distance to polygon
SELECT p1.f1, p2.f1, p1.f1 <-> p2.f1 FROM POLYGON_TBL p1, POLYGON_TBL p2;
-ERROR: function "poly_distance" not implemented
+ f1 | f1 | ?column?
+----------------------------+----------------------------+----------------
+ ((2,0),(2,4),(0,0)) | ((2,0),(2,4),(0,0)) | 0
+ ((2,0),(2,4),(0,0)) | ((7,8),(5,6),(3,4),(1,2)) | 0
+ ((2,0),(2,4),(0,0)) | ((1,2),(7,8),(5,6),(3,-4)) | 0
+ ((2,0),(2,4),(0,0)) | ((0,0)) | 0
+ ((2,0),(2,4),(0,0)) | ((3,1),(3,3),(1,0)) | 0
+ ((2,0),(2,4),(0,0)) | ((1,2),(3,4),(5,6),(7,8)) | 0
+ ((2,0),(2,4),(0,0)) | ((0,1),(0,1)) | 0.4472135955
+ ((7,8),(5,6),(3,4),(1,2)) | ((2,0),(2,4),(0,0)) | 0
+ ((7,8),(5,6),(3,4),(1,2)) | ((7,8),(5,6),(3,4),(1,2)) | 0
+ ((7,8),(5,6),(3,4),(1,2)) | ((1,2),(7,8),(5,6),(3,-4)) | 0
+ ((7,8),(5,6),(3,4),(1,2)) | ((0,0)) | 2.2360679775
+ ((7,8),(5,6),(3,4),(1,2)) | ((3,1),(3,3),(1,0)) | 0.707106781187
+ ((7,8),(5,6),(3,4),(1,2)) | ((1,2),(3,4),(5,6),(7,8)) | 0
+ ((7,8),(5,6),(3,4),(1,2)) | ((0,1),(0,1)) | 1.41421356237
+ ((1,2),(7,8),(5,6),(3,-4)) | ((2,0),(2,4),(0,0)) | 0
+ ((1,2),(7,8),(5,6),(3,-4)) | ((7,8),(5,6),(3,4),(1,2)) | 0
+ ((1,2),(7,8),(5,6),(3,-4)) | ((1,2),(7,8),(5,6),(3,-4)) | 0
+ ((1,2),(7,8),(5,6),(3,-4)) | ((0,0)) | 1.58113883008
+ ((1,2),(7,8),(5,6),(3,-4)) | ((3,1),(3,3),(1,0)) | 0
+ ((1,2),(7,8),(5,6),(3,-4)) | ((1,2),(3,4),(5,6),(7,8)) | 0
+ ((1,2),(7,8),(5,6),(3,-4)) | ((0,1),(0,1)) | 1.26491106407
+ ((0,0)) | ((2,0),(2,4),(0,0)) | 0
+ ((0,0)) | ((7,8),(5,6),(3,4),(1,2)) | 2.2360679775
+ ((0,0)) | ((1,2),(7,8),(5,6),(3,-4)) | 1.58113883008
+ ((0,0)) | ((0,0)) | 0
+ ((0,0)) | ((3,1),(3,3),(1,0)) | 1
+ ((0,0)) | ((1,2),(3,4),(5,6),(7,8)) | 2.2360679775
+ ((0,0)) | ((0,1),(0,1)) | 1
+ ((3,1),(3,3),(1,0)) | ((2,0),(2,4),(0,0)) | 0
+ ((3,1),(3,3),(1,0)) | ((7,8),(5,6),(3,4),(1,2)) | 0.707106781187
+ ((3,1),(3,3),(1,0)) | ((1,2),(7,8),(5,6),(3,-4)) | 0
+ ((3,1),(3,3),(1,0)) | ((0,0)) | 1
+ ((3,1),(3,3),(1,0)) | ((3,1),(3,3),(1,0)) | 0
+ ((3,1),(3,3),(1,0)) | ((1,2),(3,4),(5,6),(7,8)) | 0.707106781187
+ ((3,1),(3,3),(1,0)) | ((0,1),(0,1)) | 1.38675049056
+ ((1,2),(3,4),(5,6),(7,8)) | ((2,0),(2,4),(0,0)) | 0
+ ((1,2),(3,4),(5,6),(7,8)) | ((7,8),(5,6),(3,4),(1,2)) | 0
+ ((1,2),(3,4),(5,6),(7,8)) | ((1,2),(7,8),(5,6),(3,-4)) | 0
+ ((1,2),(3,4),(5,6),(7,8)) | ((0,0)) | 2.2360679775
+ ((1,2),(3,4),(5,6),(7,8)) | ((3,1),(3,3),(1,0)) | 0.707106781187
+ ((1,2),(3,4),(5,6),(7,8)) | ((1,2),(3,4),(5,6),(7,8)) | 0
+ ((1,2),(3,4),(5,6),(7,8)) | ((0,1),(0,1)) | 1.41421356237
+ ((0,1),(0,1)) | ((2,0),(2,4),(0,0)) | 0.4472135955
+ ((0,1),(0,1)) | ((7,8),(5,6),(3,4),(1,2)) | 1.41421356237
+ ((0,1),(0,1)) | ((1,2),(7,8),(5,6),(3,-4)) | 1.26491106407
+ ((0,1),(0,1)) | ((0,0)) | 1
+ ((0,1),(0,1)) | ((3,1),(3,3),(1,0)) | 1.38675049056
+ ((0,1),(0,1)) | ((1,2),(3,4),(5,6),(7,8)) | 1.41421356237
+ ((0,1),(0,1)) | ((0,1),(0,1)) | 0
+(49 rows)
+
--
-- Circles
--
@@ -4337,16 +4404,15 @@ ERROR: cannot convert circle with radius zero to
polygon
SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 ~= c2.f1;
f1 | f1
----------------+----------------
- <(5,1),3> | <(5,1),3>
- <(1,2),100> | <(1,2),100>
<(1,3),5> | <(1,3),5>
<(1,2),3> | <(1,2),3>
+ <(3,5),NaN> | <(3,5),NaN>
+ <(5,1),3> | <(5,1),3>
<(100,200),10> | <(100,200),10>
<(100,1),115> | <(100,1),115>
<(3,5),0> | <(3,5),0>
- <(3,5),NaN> | <(3,5),0>
- <(3,5),NaN> | <(3,5),NaN>
-(9 rows)
+ <(1,2),100> | <(1,2),100>
+(8 rows)
-- Overlap with circle
SELECT c1.f1, c2.f1 FROM CIRCLE_TBL c1, CIRCLE_TBL c2 WHERE c1.f1 && c2.f1;
diff --git a/contrib/pax_storage/src/test/regress/expected/horology.out
b/contrib/pax_storage/src/test/regress/expected/horology.out
index 8c7fba0a988..b5a42852de6 100644
--- a/contrib/pax_storage/src/test/regress/expected/horology.out
+++ b/contrib/pax_storage/src/test/regress/expected/horology.out
@@ -3,9 +3,9 @@
--
SET DateStyle = 'Postgres, MDY';
SHOW TimeZone; -- Many of these tests depend on the prevailing setting
- TimeZone
-----------
- PST8PDT
+ TimeZone
+---------------------
+ America/Los_Angeles
(1 row)
--
@@ -98,29 +98,21 @@ SELECT timestamp with time zone '27/12/2001
04:05:06.789-08';
reset datestyle;
SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789+08';
- timestamptz
-----------------------------------
- Wed Dec 26 12:05:06.789 2001 PST
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone:
"Y2001M12D27H04M05S06.789+08"
+LINE 1: SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789+08...
+ ^
SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789-08';
- timestamptz
-----------------------------------
- Thu Dec 27 04:05:06.789 2001 PST
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone:
"Y2001M12D27H04M05S06.789-08"
+LINE 1: SELECT timestamp with time zone 'Y2001M12D27H04M05S06.789-08...
+ ^
SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789+08';
- timestamptz
-----------------------------------
- Wed Dec 26 12:05:06.789 2001 PST
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone:
"Y2001M12D27H04MM05S06.789+08"
+LINE 1: SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789+0...
+ ^
SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789-08';
- timestamptz
-----------------------------------
- Thu Dec 27 04:05:06.789 2001 PST
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone:
"Y2001M12D27H04MM05S06.789-08"
+LINE 1: SELECT timestamp with time zone 'Y2001M12D27H04MM05S06.789-0...
+ ^
SELECT timestamp with time zone 'J2452271+08';
timestamptz
------------------------------
@@ -761,12 +753,12 @@ SELECT d1 + interval '1 year' AS one_year FROM
TIMESTAMPTZ_TBL;
Sat Feb 14 17:32:01 1998 PST
Sun Feb 15 17:32:01 1998 PST
Mon Feb 16 17:32:01 1998 PST
- Thu Feb 16 17:32:01 0096 PST BC
- Sun Feb 16 17:32:01 0098 PST
- Fri Feb 16 17:32:01 0598 PST
- Wed Feb 16 17:32:01 1098 PST
- Sun Feb 16 17:32:01 1698 PST
- Fri Feb 16 17:32:01 1798 PST
+ Thu Feb 16 17:32:01 0096 LMT BC
+ Sun Feb 16 17:32:01 0098 LMT
+ Fri Feb 16 17:32:01 0598 LMT
+ Wed Feb 16 17:32:01 1098 LMT
+ Sun Feb 16 17:32:01 1698 LMT
+ Fri Feb 16 17:32:01 1798 LMT
Wed Feb 16 17:32:01 1898 PST
Mon Feb 16 17:32:01 1998 PST
Sun Feb 16 17:32:01 2098 PST
@@ -832,12 +824,12 @@ SELECT d1 - interval '1 year' AS one_year FROM
TIMESTAMPTZ_TBL;
Wed Feb 14 17:32:01 1996 PST
Thu Feb 15 17:32:01 1996 PST
Fri Feb 16 17:32:01 1996 PST
- Mon Feb 16 17:32:01 0098 PST BC
- Thu Feb 16 17:32:01 0096 PST
- Tue Feb 16 17:32:01 0596 PST
- Sun Feb 16 17:32:01 1096 PST
- Thu Feb 16 17:32:01 1696 PST
- Tue Feb 16 17:32:01 1796 PST
+ Mon Feb 16 17:32:01 0098 LMT BC
+ Thu Feb 16 17:32:01 0096 LMT
+ Tue Feb 16 17:32:01 0596 LMT
+ Sun Feb 16 17:32:01 1096 LMT
+ Thu Feb 16 17:32:01 1696 LMT
+ Tue Feb 16 17:32:01 1796 LMT
Sun Feb 16 17:32:01 1896 PST
Fri Feb 16 17:32:01 1996 PST
Thu Feb 16 17:32:01 2096 PST
@@ -2116,7 +2108,7 @@ SELECT '2020-10-05'::timestamptz > '2202020-10-05'::date
as f;
SELECT '4714-11-24 BC'::date::timestamptz;
timestamptz
---------------------------------
- Mon Nov 24 00:00:00 4714 PST BC
+ Mon Nov 24 00:00:00 4714 LMT BC
(1 row)
SET TimeZone = 'UTC-2';
@@ -2623,13 +2615,13 @@ RESET DateStyle;
SELECT to_timestamp('0097/Feb/16 --> 08:14:30', 'YYYY/Mon/DD --> HH:MI:SS');
to_timestamp
------------------------------
- Sat Feb 16 08:14:30 0097 PST
+ Sat Feb 16 08:14:30 0097 LMT
(1 row)
SELECT to_timestamp('97/2/16 8:14:30', 'FMYYYY/FMMM/FMDD FMHH:FMMI:FMSS');
to_timestamp
------------------------------
- Sat Feb 16 08:14:30 0097 PST
+ Sat Feb 16 08:14:30 0097 LMT
(1 row)
SELECT to_timestamp('2011$03!18 23_38_15', 'YYYY-MM-DD HH24:MI:SS');
@@ -2666,7 +2658,7 @@ SELECT to_timestamp('My birthday-> Year: 1976, Month:
May, Day: 16',
SELECT to_timestamp('1,582nd VIII 21', 'Y,YYYth FMRM DD');
to_timestamp
------------------------------
- Sat Aug 21 00:00:00 1582 PST
+ Sat Aug 21 00:00:00 1582 LMT
(1 row)
SELECT to_timestamp('15 "text between quote marks" 98 54 45',
@@ -2730,7 +2722,7 @@ SELECT to_timestamp('1997 AD 11 16', 'YYYY BC MM DD');
SELECT to_timestamp('1997 BC 11 16', 'YYYY BC MM DD');
to_timestamp
---------------------------------
- Tue Nov 16 00:00:00 1997 PST BC
+ Tue Nov 16 00:00:00 1997 LMT BC
(1 row)
SELECT to_timestamp('1997 A.D. 11 16', 'YYYY B.C. MM DD');
@@ -2742,7 +2734,7 @@ SELECT to_timestamp('1997 A.D. 11 16', 'YYYY B.C. MM DD');
SELECT to_timestamp('1997 B.C. 11 16', 'YYYY B.C. MM DD');
to_timestamp
---------------------------------
- Tue Nov 16 00:00:00 1997 PST BC
+ Tue Nov 16 00:00:00 1997 LMT BC
(1 row)
SELECT to_timestamp('9-1116', 'Y-MMDD');
@@ -3012,19 +3004,19 @@ SELECT to_date('-44-02-01 BC','YYYY-MM-DD BC');
SELECT to_timestamp('44-02-01 11:12:13 BC','YYYY-MM-DD HH24:MI:SS BC');
to_timestamp
---------------------------------
- Fri Feb 01 11:12:13 0044 PST BC
+ Fri Feb 01 11:12:13 0044 LMT BC
(1 row)
SELECT to_timestamp('-44-02-01 11:12:13','YYYY-MM-DD HH24:MI:SS');
to_timestamp
---------------------------------
- Fri Feb 01 11:12:13 0044 PST BC
+ Fri Feb 01 11:12:13 0044 LMT BC
(1 row)
SELECT to_timestamp('-44-02-01 11:12:13 BC','YYYY-MM-DD HH24:MI:SS BC');
to_timestamp
------------------------------
- Mon Feb 01 11:12:13 0044 PST
+ Mon Feb 01 11:12:13 0044 LMT
(1 row)
--
diff --git a/contrib/pax_storage/src/test/regress/expected/interval.out
b/contrib/pax_storage/src/test/regress/expected/interval.out
index 2df26ee2fb0..8cf15c8cd47 100644
--- a/contrib/pax_storage/src/test/regress/expected/interval.out
+++ b/contrib/pax_storage/src/test/regress/expected/interval.out
@@ -966,9 +966,9 @@ SELECT f1,
(10 rows)
SELECT EXTRACT(FORTNIGHT FROM INTERVAL '2 days'); -- error
-ERROR: interval units "fortnight" not recognized
+ERROR: unit "fortnight" not recognized for type interval
SELECT EXTRACT(TIMEZONE FROM INTERVAL '2 days'); -- error
-ERROR: interval units "timezone" not supported
+ERROR: unit "timezone" not supported for type interval
SELECT EXTRACT(DECADE FROM INTERVAL '100 y');
extract
---------
diff --git a/contrib/pax_storage/src/test/regress/expected/misc_sanity.out
b/contrib/pax_storage/src/test/regress/expected/misc_sanity.out
index c88ab2025e3..71107ffc3b1 100644
--- a/contrib/pax_storage/src/test/regress/expected/misc_sanity.out
+++ b/contrib/pax_storage/src/test/regress/expected/misc_sanity.out
@@ -76,12 +76,37 @@ loop
end if;
end loop;
end$$;
+NOTICE: pg_am contains unpinned initdb-created object(s)
+NOTICE: pg_amop contains unpinned initdb-created object(s)
+NOTICE: pg_amproc contains unpinned initdb-created object(s)
+NOTICE: pg_auth_members contains unpinned initdb-created object(s)
+NOTICE: pg_authid contains unpinned initdb-created object(s)
+NOTICE: pg_cast contains unpinned initdb-created object(s)
+NOTICE: pg_class contains unpinned initdb-created object(s)
+NOTICE: pg_collation contains unpinned initdb-created object(s)
+NOTICE: pg_constraint contains unpinned initdb-created object(s)
+NOTICE: pg_conversion contains unpinned initdb-created object(s)
NOTICE: pg_database contains unpinned initdb-created object(s)
NOTICE: pg_extension contains unpinned initdb-created object(s)
NOTICE: pg_foreign_data_wrapper contains unpinned initdb-created object(s)
NOTICE: pg_foreign_server contains unpinned initdb-created object(s)
+NOTICE: pg_language contains unpinned initdb-created object(s)
+NOTICE: pg_namespace contains unpinned initdb-created object(s)
+NOTICE: pg_opclass contains unpinned initdb-created object(s)
+NOTICE: pg_operator contains unpinned initdb-created object(s)
+NOTICE: pg_opfamily contains unpinned initdb-created object(s)
+NOTICE: pg_proc contains unpinned initdb-created object(s)
+NOTICE: pg_profile contains unpinned initdb-created object(s)
+NOTICE: pg_resgroup contains unpinned initdb-created object(s)
+NOTICE: pg_resourcetype contains unpinned initdb-created object(s)
+NOTICE: pg_resqueue contains unpinned initdb-created object(s)
NOTICE: pg_rewrite contains unpinned initdb-created object(s)
NOTICE: pg_tablespace contains unpinned initdb-created object(s)
+NOTICE: pg_ts_config contains unpinned initdb-created object(s)
+NOTICE: pg_ts_dict contains unpinned initdb-created object(s)
+NOTICE: pg_ts_parser contains unpinned initdb-created object(s)
+NOTICE: pg_ts_template contains unpinned initdb-created object(s)
+NOTICE: pg_type contains unpinned initdb-created object(s)
-- **************** pg_class ****************
-- Look for system tables with varlena columns but no toast table. All
-- system tables with toastable columns should have toast tables, with
@@ -157,6 +182,8 @@ ORDER BY 1;
gp_distribution_policy
gp_fastsequence
gp_id
+ gp_matview_aux
+ gp_matview_tables
gp_partition_template
gp_version_at_initdb
gp_warehouse
@@ -166,6 +193,7 @@ ORDER BY 1;
pg_compression
pg_depend
pg_extprotocol
+ pg_foreign_table_seg
pg_password_history
pg_proc_callback
pg_profile
@@ -178,7 +206,7 @@ ORDER BY 1;
pg_stat_last_operation
pg_stat_last_shoperation
pg_type_encoding
-(25 rows)
+(28 rows)
-- end_ignore
-- system catalog unique indexes not wrapped in a constraint
diff --git a/contrib/pax_storage/src/test/regress/expected/numeric.out
b/contrib/pax_storage/src/test/regress/expected/numeric.out
index bea33181bee..f3ae421a6c8 100644
--- a/contrib/pax_storage/src/test/regress/expected/numeric.out
+++ b/contrib/pax_storage/src/test/regress/expected/numeric.out
@@ -952,44 +952,44 @@ WITH v(x) AS
SELECT x1, x2,
power(x1, x2)
FROM v AS v1(x1), v AS v2(x2) WHERE x1 != 0 OR x2 >= 0;
- x1 | x2 | power
-----------+----------+---------------------
- 0 | 0 | 1.0000000000000000
- 0 | 1 | 0.0000000000000000
- 0 | 2 | 0.0000000000000000
- 0 | 4.2 | 0.0000000000000000
- 0 | Infinity | 0
- 0 | NaN | NaN
- 1 | 0 | 1.0000000000000000
- 1 | 1 | 1.0000000000000000
- 1 | 2 | 1.0000000000000000
- 1 | 4.2 | 1.0000000000000000
- 1 | Infinity | 1
- 1 | NaN | 1
- 2 | 0 | 1.0000000000000000
- 2 | 1 | 2.0000000000000000
- 2 | 2 | 4.0000000000000000
- 2 | 4.2 | 18.379173679952560
- 2 | Infinity | Infinity
- 2 | NaN | NaN
- 4.2 | 0 | 1.0000000000000000
- 4.2 | 1 | 4.2000000000000000
- 4.2 | 2 | 17.6400000000000000
- 4.2 | 4.2 | 414.61691860129675
- 4.2 | Infinity | Infinity
- 4.2 | NaN | NaN
- Infinity | 0 | 1
- Infinity | 1 | Infinity
- Infinity | 2 | Infinity
- Infinity | 4.2 | Infinity
- Infinity | Infinity | Infinity
- Infinity | NaN | NaN
- NaN | 0 | 1
- NaN | 1 | NaN
- NaN | 2 | NaN
- NaN | 4.2 | NaN
- NaN | Infinity | NaN
- NaN | NaN | NaN
+ x1 | x2 | power
+----------+----------+--------------------
+ 0 | 0 | 1.0000000000000000
+ 0 | 1 | 0.0000000000000000
+ 0 | 2 | 0.0000000000000000
+ 0 | 4.2 | 0.0000000000000000
+ 0 | Infinity | 0
+ 0 | NaN | NaN
+ 1 | 0 | 1.0000000000000000
+ 1 | 1 | 1.0000000000000000
+ 1 | 2 | 1.0000000000000000
+ 1 | 4.2 | 1.0000000000000000
+ 1 | Infinity | 1
+ 1 | NaN | 1
+ 2 | 0 | 1.0000000000000000
+ 2 | 1 | 2.0000000000000000
+ 2 | 2 | 4.0000000000000000
+ 2 | 4.2 | 18.379173679952560
+ 2 | Infinity | Infinity
+ 2 | NaN | NaN
+ 4.2 | 0 | 1.0000000000000000
+ 4.2 | 1 | 4.2000000000000000
+ 4.2 | 2 | 17.640000000000000
+ 4.2 | 4.2 | 414.61691860129675
+ 4.2 | Infinity | Infinity
+ 4.2 | NaN | NaN
+ Infinity | 0 | 1
+ Infinity | 1 | Infinity
+ Infinity | 2 | Infinity
+ Infinity | 4.2 | Infinity
+ Infinity | Infinity | Infinity
+ Infinity | NaN | NaN
+ NaN | 0 | 1
+ NaN | 1 | NaN
+ NaN | 2 | NaN
+ NaN | 4.2 | NaN
+ NaN | Infinity | NaN
+ NaN | NaN | NaN
(36 rows)
SELECT power('0'::numeric, '-1');
@@ -2368,15 +2368,15 @@ select
sqrt(8015491789940783531003294973900307::numeric);
-- Test code path for raising to integer powers
--
select 10.0 ^ -2147483648 as rounds_to_zero;
- rounds_to_zero
---------------------
- 0.0000000000000000
+
[...]
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
+
0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
[...]
(1 row)
select 10.0 ^ -2147483647 as rounds_to_zero;
- rounds_to_zero
---------------------
- 0.0000000000000000
+
[...]
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
+
0.000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
[...]
(1 row)
select 10.0 ^ 2147483647 as overflows;
@@ -2385,27 +2385,27 @@ select 117743296169.0 ^ 1000000000 as overflows;
ERROR: value overflows numeric format
-- cases that used to return inaccurate results
select 3.789 ^ 21;
- ?column?
---------------------------------
- 1409343026052.8716016316022141
+ ?column?
+--------------------
+ 1409343026052.8716
(1 row)
select 3.789 ^ 35;
- ?column?
-----------------------------------------
- 177158169650516670809.3820586142670135
+ ?column?
+---------------------------
+ 177158169650516670809.382
(1 row)
select 1.2 ^ 345;
- ?column?
------------------------------------------------
- 2077446682327378559843444695.5827049735727869
+ ?column?
+--------------------------------
+ 2077446682327378559843444695.6
(1 row)
select 0.12 ^ (-20);
- ?column?
---------------------------------------
- 2608405330458882702.5529619561355838
+ ?column?
+------------------------
+ 2608405330458882702.55
(1 row)
select 1.000000000123 ^ (-2147483648);
@@ -2428,15 +2428,15 @@ select round(((1 - 1.500012345678e-1000) ^ 1.45e1003) *
1e1000);
-- cases that used to error out
select 0.12 ^ (-25);
- ?column?
--------------------------------------------
- 104825960103961013959336.4983657883169110
+ ?column?
+-----------------------------
+ 104825960103961013959336.50
(1 row)
select 0.5678 ^ (-85);
- ?column?
-----------------------------------------
- 782333637740774446257.7719390061997396
+ ?column?
+----------------------------
+ 782333637740774446257.7719
(1 row)
select coalesce(nullif(0.9999999999 ^ 70000000000000, 0), 0) as underflows;
@@ -2567,9 +2567,9 @@ select 12.3 ^ (-45.6);
-- big test
select 1.234 ^ 5678;
-
?column?
[...]
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
-
30723929566209074164458487259395617349356823859507414125434956540666143963659889679887682322090408495323301555399485487589089085811865646865864391816980527739940254228177790102934633770762218157434658598961334428501076450101762536674286506694885616136022480137048217145803053334630975055714054962131351575207863862071473283181529716823179077929629026620731534400888393501027404400152260623557658421599926011752311429703394401869969102410682343843175407308681338224214060229121514975952083320
[...]
+
?column?
[...]
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
[...]
+
30723929566209074164458487259395617349356823859507414125434956540666143963659889679887682322090408495323301555399485487589089085811865646865864391816980527739940254228177790102934633770762218157434658598961334428501076450101762536674286506694885616136022480137048217145803053334630975055714054962131351575207863862071473283181529716823179077929629026620731534400888393501027404400152260623557658421599926011752311429703394401869969102410682343843175407308681338224214060229121514975952083320
[...]
(1 row)
--
diff --git a/contrib/pax_storage/src/test/regress/expected/opr_sanity.out
b/contrib/pax_storage/src/test/regress/expected/opr_sanity.out
index 2fb7ba06584..71652a16cd0 100644
--- a/contrib/pax_storage/src/test/regress/expected/opr_sanity.out
+++ b/contrib/pax_storage/src/test/regress/expected/opr_sanity.out
@@ -131,10 +131,10 @@ WHERE p1.oid < p2.oid AND
oid | proname | oid | proname
------+--------------------------------+------+--------------------------------
7203 | gp_log_backend_memory_contexts | 7204 | gp_log_backend_memory_contexts
- 6212 | int2_matrix_accum | 6215 | float8_matrix_accum
- 6212 | int2_matrix_accum | 6214 | int8_matrix_accum
- 6213 | int4_matrix_accum | 6215 | float8_matrix_accum
- 6213 | int4_matrix_accum | 6214 | int8_matrix_accum
+ 6405 | int2_matrix_accum | 6414 | float8_matrix_accum
+ 6405 | int2_matrix_accum | 6406 | int8_matrix_accum
+ 6407 | int4_matrix_accum | 6414 | float8_matrix_accum
+ 6406 | int8_matrix_accum | 6407 | int4_matrix_accum
(5 rows)
-- Look for uses of different type OIDs in the argument/result type fields
@@ -217,7 +217,8 @@ ORDER BY 1, 2;
timestamp without time zone | timestamp with time zone
bit | bit varying
txid_snapshot | pg_snapshot
-(4 rows)
+ anyrange | anymultirange
+(5 rows)
SELECT DISTINCT p1.proargtypes[2]::regtype, p2.proargtypes[2]::regtype
FROM pg_proc AS p1, pg_proc AS p2
@@ -854,7 +855,6 @@ macaddr8_ge(macaddr8,macaddr8)
macaddr8_ne(macaddr8,macaddr8)
macaddr8_cmp(macaddr8,macaddr8)
macaddr8(macaddr)
-sm3(bytea)
xid8lt(xid8,xid8)
xid8gt(xid8,xid8)
xid8le(xid8,xid8)
@@ -862,6 +862,7 @@ xid8ge(xid8,xid8)
xid8eq(xid8,xid8)
xid8ne(xid8,xid8)
xid8cmp(xid8,xid8)
+sm3(bytea)
-- restore normal output mode
\a\t
-- List of functions used by libpq's fe-lobj.c
@@ -2231,6 +2232,7 @@ ORDER BY 1, 2, 3;
| complex_ops | complex_ops | complex
| float_ops | float4_ops | real
| float_ops | float8_ops | double precision
+ | interval_ops | interval_ops | interval
| jsonb_ops | jsonb_ops | jsonb
| multirange_ops | multirange_ops | anymultirange
| numeric_ops | numeric_ops | numeric
@@ -2239,7 +2241,7 @@ ORDER BY 1, 2, 3;
| record_ops | record_ops | record
| tsquery_ops | tsquery_ops | tsquery
| tsvector_ops | tsvector_ops | tsvector
-(16 rows)
+(17 rows)
-- **************** pg_index ****************
-- Look for illegal values in pg_index fields.
diff --git a/contrib/pax_storage/src/test/regress/expected/regproc.out
b/contrib/pax_storage/src/test/regress/expected/regproc.out
index 7188cf58677..4f3efb2c11f 100644
--- a/contrib/pax_storage/src/test/regress/expected/regproc.out
+++ b/contrib/pax_storage/src/test/regress/expected/regproc.out
@@ -247,7 +247,7 @@ LINE 1: SELECT regtype('int3');
^
-- with schemaname
SELECT regoper('ng_catalog.||/');
-ERROR: schema "ng_catalog" does not exist
+ERROR: operator does not exist: ng_catalog.||/
LINE 1: SELECT regoper('ng_catalog.||/');
^
SELECT regoperator('ng_catalog.+(int4,int4)');
@@ -255,15 +255,15 @@ ERROR: operator does not exist: ng_catalog.+(int4,int4)
LINE 1: SELECT regoperator('ng_catalog.+(int4,int4)');
^
SELECT regproc('ng_catalog.now');
-ERROR: schema "ng_catalog" does not exist
+ERROR: function "ng_catalog.now" does not exist
LINE 1: SELECT regproc('ng_catalog.now');
^
SELECT regprocedure('ng_catalog.abs(numeric)');
-ERROR: schema "ng_catalog" does not exist
+ERROR: function "ng_catalog.abs(numeric)" does not exist
LINE 1: SELECT regprocedure('ng_catalog.abs(numeric)');
^
SELECT regclass('ng_catalog.pg_class');
-ERROR: schema "ng_catalog" does not exist
+ERROR: relation "ng_catalog.pg_class" does not exist
LINE 1: SELECT regclass('ng_catalog.pg_class');
^
SELECT regtype('ng_catalog.int4');
@@ -271,7 +271,7 @@ ERROR: schema "ng_catalog" does not exist
LINE 1: SELECT regtype('ng_catalog.int4');
^
SELECT regcollation('ng_catalog."POSIX"');
-ERROR: schema "ng_catalog" does not exist
+ERROR: collation "ng_catalog.POSIX" for encoding "UTF8" does not exist
LINE 1: SELECT regcollation('ng_catalog."POSIX"');
^
-- schemaname not applicable
@@ -408,7 +408,11 @@ SELECT to_regrole('"regress_regrole_test"');
(1 row)
SELECT to_regrole('foo.bar');
-ERROR: invalid name syntax
+ to_regrole
+------------
+
+(1 row)
+
SELECT to_regrole('Nonexistent');
to_regrole
------------
@@ -422,7 +426,11 @@ SELECT to_regrole('"Nonexistent"');
(1 row)
SELECT to_regrole('foo.bar');
-ERROR: invalid name syntax
+ to_regrole
+------------
+
+(1 row)
+
SELECT to_regnamespace('Nonexistent');
to_regnamespace
-----------------
@@ -436,4 +444,8 @@ SELECT to_regnamespace('"Nonexistent"');
(1 row)
SELECT to_regnamespace('foo.bar');
-ERROR: invalid name syntax
+ to_regnamespace
+-----------------
+
+(1 row)
+
diff --git a/contrib/pax_storage/src/test/regress/expected/time.out
b/contrib/pax_storage/src/test/regress/expected/time.out
index 39b409feca9..f3a71503c25 100644
--- a/contrib/pax_storage/src/test/regress/expected/time.out
+++ b/contrib/pax_storage/src/test/regress/expected/time.out
@@ -161,11 +161,11 @@ SELECT EXTRACT(HOUR FROM TIME '2020-05-26
13:30:25.575401');
(1 row)
SELECT EXTRACT(DAY FROM TIME '2020-05-26 13:30:25.575401'); -- error
-ERROR: "time" units "day" not recognized
+ERROR: unit "day" not supported for type time without time zone
SELECT EXTRACT(FORTNIGHT FROM TIME '2020-05-26 13:30:25.575401'); -- error
-ERROR: "time" units "fortnight" not recognized
+ERROR: unit "fortnight" not recognized for type time without time zone
SELECT EXTRACT(TIMEZONE FROM TIME '2020-05-26 13:30:25.575401'); -- error
-ERROR: "time" units "timezone" not recognized
+ERROR: unit "timezone" not supported for type time without time zone
SELECT EXTRACT(EPOCH FROM TIME '2020-05-26 13:30:25.575401');
extract
--------------
diff --git a/contrib/pax_storage/src/test/regress/expected/timestamp.out
b/contrib/pax_storage/src/test/regress/expected/timestamp.out
index 2e84c6b2b04..6043b37ffa3 100644
--- a/contrib/pax_storage/src/test/regress/expected/timestamp.out
+++ b/contrib/pax_storage/src/test/regress/expected/timestamp.out
@@ -2007,13 +2007,13 @@ SELECT i,
SELECT '' AS to_timestamp_1, to_timestamp('0097/Feb/16 --> 08:14:30',
'YYYY/Mon/DD --> HH:MI:SS');
to_timestamp_1 | to_timestamp
----------------+------------------------------
- | Sat Feb 16 08:14:30 0097 PST
+ | Sat Feb 16 08:14:30 0097 LMT
(1 row)
SELECT '' AS to_timestamp_2, to_timestamp('97/2/16 8:14:30', 'FMYYYY/FMMM/FMDD
FMHH:FMMI:FMSS');
to_timestamp_2 | to_timestamp
----------------+------------------------------
- | Sat Feb 16 08:14:30 0097 PST
+ | Sat Feb 16 08:14:30 0097 LMT
(1 row)
SELECT '' AS to_timestamp_3, to_timestamp('1985 January 12', 'YYYY FMMonth
DD');
@@ -2032,7 +2032,7 @@ SELECT '' AS to_timestamp_4, to_timestamp('My birthday->
Year: 1976, Month: May,
SELECT '' AS to_timestamp_5, to_timestamp('1,582nd VIII 21', 'Y,YYYth FMRM
DD');
to_timestamp_5 | to_timestamp
----------------+------------------------------
- | Sat Aug 21 00:00:00 1582 PST
+ | Sat Aug 21 00:00:00 1582 LMT
(1 row)
SELECT '' AS to_timestamp_6, to_timestamp('15 "text between quote marks" 98 54
45',
diff --git a/contrib/pax_storage/src/test/regress/expected/timestamptz.out
b/contrib/pax_storage/src/test/regress/expected/timestamptz.out
index c477dbb08f0..b39107a2075 100644
--- a/contrib/pax_storage/src/test/regress/expected/timestamptz.out
+++ b/contrib/pax_storage/src/test/regress/expected/timestamptz.out
@@ -293,12 +293,12 @@ SELECT d1 FROM TIMESTAMPTZ_TBL;
Fri Feb 14 17:32:01 1997 PST
Sat Feb 15 17:32:01 1997 PST
Sun Feb 16 17:32:01 1997 PST
- Tue Feb 16 17:32:01 0097 PST BC
- Sat Feb 16 17:32:01 0097 PST
- Thu Feb 16 17:32:01 0597 PST
- Tue Feb 16 17:32:01 1097 PST
- Sat Feb 16 17:32:01 1697 PST
- Thu Feb 16 17:32:01 1797 PST
+ Tue Feb 16 17:32:01 0097 LMT BC
+ Sat Feb 16 17:32:01 0097 LMT
+ Thu Feb 16 17:32:01 0597 LMT
+ Tue Feb 16 17:32:01 1097 LMT
+ Sat Feb 16 17:32:01 1697 LMT
+ Thu Feb 16 17:32:01 1797 LMT
Tue Feb 16 17:32:01 1897 PST
Sun Feb 16 17:32:01 1997 PST
Sat Feb 16 17:32:01 2097 PST
@@ -322,19 +322,19 @@ SELECT d1 FROM TIMESTAMPTZ_TBL;
SELECT '4714-11-24 00:00:00+00 BC'::timestamptz;
timestamptz
---------------------------------
- Sun Nov 23 16:00:00 4714 PST BC
+ Sun Nov 23 16:07:02 4714 LMT BC
(1 row)
SELECT '4714-11-23 16:00:00-08 BC'::timestamptz;
timestamptz
---------------------------------
- Sun Nov 23 16:00:00 4714 PST BC
+ Sun Nov 23 16:07:02 4714 LMT BC
(1 row)
SELECT 'Sun Nov 23 16:00:00 4714 PST BC'::timestamptz;
timestamptz
---------------------------------
- Sun Nov 23 16:00:00 4714 PST BC
+ Sun Nov 23 16:07:02 4714 LMT BC
(1 row)
SELECT '4714-11-23 23:59:59+00 BC'::timestamptz; -- out of range
@@ -424,12 +424,12 @@ SELECT d1 FROM TIMESTAMPTZ_TBL
---------------------------------
-infinity
Wed Dec 31 16:00:00 1969 PST
- Tue Feb 16 17:32:01 0097 PST BC
- Sat Feb 16 17:32:01 0097 PST
- Thu Feb 16 17:32:01 0597 PST
- Tue Feb 16 17:32:01 1097 PST
- Sat Feb 16 17:32:01 1697 PST
- Thu Feb 16 17:32:01 1797 PST
+ Tue Feb 16 17:32:01 0097 LMT BC
+ Sat Feb 16 17:32:01 0097 LMT
+ Thu Feb 16 17:32:01 0597 LMT
+ Tue Feb 16 17:32:01 1097 LMT
+ Sat Feb 16 17:32:01 1697 LMT
+ Thu Feb 16 17:32:01 1797 LMT
Tue Feb 16 17:32:01 1897 PST
Wed Feb 28 17:32:01 1996 PST
Thu Feb 29 17:32:01 1996 PST
@@ -492,12 +492,12 @@ SELECT d1 FROM TIMESTAMPTZ_TBL
Fri Feb 14 17:32:01 1997 PST
Sat Feb 15 17:32:01 1997 PST
Sun Feb 16 17:32:01 1997 PST
- Tue Feb 16 17:32:01 0097 PST BC
- Sat Feb 16 17:32:01 0097 PST
- Thu Feb 16 17:32:01 0597 PST
- Tue Feb 16 17:32:01 1097 PST
- Sat Feb 16 17:32:01 1697 PST
- Thu Feb 16 17:32:01 1797 PST
+ Tue Feb 16 17:32:01 0097 LMT BC
+ Sat Feb 16 17:32:01 0097 LMT
+ Thu Feb 16 17:32:01 0597 LMT
+ Tue Feb 16 17:32:01 1097 LMT
+ Sat Feb 16 17:32:01 1697 LMT
+ Thu Feb 16 17:32:01 1797 LMT
Tue Feb 16 17:32:01 1897 PST
Sun Feb 16 17:32:01 1997 PST
Sat Feb 16 17:32:01 2097 PST
@@ -524,12 +524,12 @@ SELECT d1 FROM TIMESTAMPTZ_TBL
-infinity
Wed Dec 31 16:00:00 1969 PST
Thu Jan 02 00:00:00 1997 PST
- Tue Feb 16 17:32:01 0097 PST BC
- Sat Feb 16 17:32:01 0097 PST
- Thu Feb 16 17:32:01 0597 PST
- Tue Feb 16 17:32:01 1097 PST
- Sat Feb 16 17:32:01 1697 PST
- Thu Feb 16 17:32:01 1797 PST
+ Tue Feb 16 17:32:01 0097 LMT BC
+ Sat Feb 16 17:32:01 0097 LMT
+ Thu Feb 16 17:32:01 0597 LMT
+ Tue Feb 16 17:32:01 1097 LMT
+ Sat Feb 16 17:32:01 1697 LMT
+ Thu Feb 16 17:32:01 1797 LMT
Tue Feb 16 17:32:01 1897 PST
Wed Feb 28 17:32:01 1996 PST
Thu Feb 29 17:32:01 1996 PST
@@ -869,12 +869,12 @@ SELECT d1 as timestamptz,
Fri Feb 14 17:32:01 1997 PST | 1997 | 2 | 14 | 17 | 32 |
1
Sat Feb 15 17:32:01 1997 PST | 1997 | 2 | 15 | 17 | 32 |
1
Sun Feb 16 17:32:01 1997 PST | 1997 | 2 | 16 | 17 | 32 |
1
- Tue Feb 16 17:32:01 0097 PST BC | -97 | 2 | 16 | 17 | 32 |
1
- Sat Feb 16 17:32:01 0097 PST | 97 | 2 | 16 | 17 | 32 |
1
- Thu Feb 16 17:32:01 0597 PST | 597 | 2 | 16 | 17 | 32 |
1
- Tue Feb 16 17:32:01 1097 PST | 1097 | 2 | 16 | 17 | 32 |
1
- Sat Feb 16 17:32:01 1697 PST | 1697 | 2 | 16 | 17 | 32 |
1
- Thu Feb 16 17:32:01 1797 PST | 1797 | 2 | 16 | 17 | 32 |
1
+ Tue Feb 16 17:32:01 0097 LMT BC | -97 | 2 | 16 | 17 | 32 |
1
+ Sat Feb 16 17:32:01 0097 LMT | 97 | 2 | 16 | 17 | 32 |
1
+ Thu Feb 16 17:32:01 0597 LMT | 597 | 2 | 16 | 17 | 32 |
1
+ Tue Feb 16 17:32:01 1097 LMT | 1097 | 2 | 16 | 17 | 32 |
1
+ Sat Feb 16 17:32:01 1697 LMT | 1697 | 2 | 16 | 17 | 32 |
1
+ Thu Feb 16 17:32:01 1797 LMT | 1797 | 2 | 16 | 17 | 32 |
1
Tue Feb 16 17:32:01 1897 PST | 1897 | 2 | 16 | 17 | 32 |
1
Sun Feb 16 17:32:01 1997 PST | 1997 | 2 | 16 | 17 | 32 |
1
Sat Feb 16 17:32:01 2097 PST | 2097 | 2 | 16 | 17 | 32 |
1
@@ -943,12 +943,12 @@ SELECT d1 as timestamptz,
Fri Feb 14 17:32:01 1997 PST | 1 | 1000 | 1000000
Sat Feb 15 17:32:01 1997 PST | 1 | 1000 | 1000000
Sun Feb 16 17:32:01 1997 PST | 1 | 1000 | 1000000
- Tue Feb 16 17:32:01 0097 PST BC | 1 | 1000 | 1000000
- Sat Feb 16 17:32:01 0097 PST | 1 | 1000 | 1000000
- Thu Feb 16 17:32:01 0597 PST | 1 | 1000 | 1000000
- Tue Feb 16 17:32:01 1097 PST | 1 | 1000 | 1000000
- Sat Feb 16 17:32:01 1697 PST | 1 | 1000 | 1000000
- Thu Feb 16 17:32:01 1797 PST | 1 | 1000 | 1000000
+ Tue Feb 16 17:32:01 0097 LMT BC | 1 | 1000 | 1000000
+ Sat Feb 16 17:32:01 0097 LMT | 1 | 1000 | 1000000
+ Thu Feb 16 17:32:01 0597 LMT | 1 | 1000 | 1000000
+ Tue Feb 16 17:32:01 1097 LMT | 1 | 1000 | 1000000
+ Sat Feb 16 17:32:01 1697 LMT | 1 | 1000 | 1000000
+ Thu Feb 16 17:32:01 1797 LMT | 1 | 1000 | 1000000
Tue Feb 16 17:32:01 1897 PST | 1 | 1000 | 1000000
Sun Feb 16 17:32:01 1997 PST | 1 | 1000 | 1000000
Sat Feb 16 17:32:01 2097 PST | 1 | 1000 | 1000000
@@ -1018,12 +1018,12 @@ SELECT d1 as timestamptz,
Fri Feb 14 17:32:01 1997 PST | 1997 | 7 | 5 | 5 | 45
Sat Feb 15 17:32:01 1997 PST | 1997 | 7 | 6 | 6 | 46
Sun Feb 16 17:32:01 1997 PST | 1997 | 7 | 7 | 0 | 47
- Tue Feb 16 17:32:01 0097 PST BC | -97 | 7 | 2 | 2 | 47
- Sat Feb 16 17:32:01 0097 PST | 97 | 7 | 6 | 6 | 47
- Thu Feb 16 17:32:01 0597 PST | 597 | 7 | 4 | 4 | 47
- Tue Feb 16 17:32:01 1097 PST | 1097 | 7 | 2 | 2 | 47
- Sat Feb 16 17:32:01 1697 PST | 1697 | 7 | 6 | 6 | 47
- Thu Feb 16 17:32:01 1797 PST | 1797 | 7 | 4 | 4 | 47
+ Tue Feb 16 17:32:01 0097 LMT BC | -97 | 7 | 2 | 2 | 47
+ Sat Feb 16 17:32:01 0097 LMT | 97 | 7 | 6 | 6 | 47
+ Thu Feb 16 17:32:01 0597 LMT | 597 | 7 | 4 | 4 | 47
+ Tue Feb 16 17:32:01 1097 LMT | 1097 | 7 | 2 | 2 | 47
+ Sat Feb 16 17:32:01 1697 LMT | 1697 | 7 | 6 | 6 | 47
+ Thu Feb 16 17:32:01 1797 LMT | 1797 | 7 | 4 | 4 | 47
Tue Feb 16 17:32:01 1897 PST | 1897 | 7 | 2 | 2 | 47
Sun Feb 16 17:32:01 1997 PST | 1997 | 7 | 7 | 0 | 47
Sat Feb 16 17:32:01 2097 PST | 2097 | 7 | 6 | 6 | 47
@@ -1095,12 +1095,12 @@ SELECT d1 as timestamptz,
Fri Feb 14 17:32:01 1997 PST | 199 | 20 | 2 |
2450495 | 855970321
Sat Feb 15 17:32:01 1997 PST | 199 | 20 | 2 |
2450496 | 856056721
Sun Feb 16 17:32:01 1997 PST | 199 | 20 | 2 |
2450497 | 856143121
- Tue Feb 16 17:32:01 0097 PST BC | -10 | -1 | -1 |
1686043 | -65192682479
- Sat Feb 16 17:32:01 0097 PST | 9 | 1 | 1 |
1756537 | -59102000879
- Thu Feb 16 17:32:01 0597 PST | 59 | 6 | 1 |
1939158 | -43323546479
- Tue Feb 16 17:32:01 1097 PST | 109 | 11 | 2 |
2121779 | -27545092079
- Sat Feb 16 17:32:01 1697 PST | 169 | 17 | 2 |
2340925 | -8610877679
- Thu Feb 16 17:32:01 1797 PST | 179 | 18 | 2 |
2377449 | -5455204079
+ Tue Feb 16 17:32:01 0097 LMT BC | -10 | -1 | -1 |
1686043 | -65192682901
+ Sat Feb 16 17:32:01 0097 LMT | 9 | 1 | 1 |
1756537 | -59102001301
+ Thu Feb 16 17:32:01 0597 LMT | 59 | 6 | 1 |
1939158 | -43323546901
+ Tue Feb 16 17:32:01 1097 LMT | 109 | 11 | 2 |
2121779 | -27545092501
+ Sat Feb 16 17:32:01 1697 LMT | 169 | 17 | 2 |
2340925 | -8610878101
+ Thu Feb 16 17:32:01 1797 LMT | 179 | 18 | 2 |
2377449 | -5455204501
Tue Feb 16 17:32:01 1897 PST | 189 | 19 | 2 |
2413973 | -2299530479
Sun Feb 16 17:32:01 1997 PST | 199 | 20 | 2 |
2450497 | 856143121
Sat Feb 16 17:32:01 2097 PST | 209 | 21 | 3 |
2487022 | 4011903121
@@ -1170,12 +1170,12 @@ SELECT d1 as timestamptz,
Fri Feb 14 17:32:01 1997 PST | -28800 | -8 | 0
Sat Feb 15 17:32:01 1997 PST | -28800 | -8 | 0
Sun Feb 16 17:32:01 1997 PST | -28800 | -8 | 0
- Tue Feb 16 17:32:01 0097 PST BC | -28800 | -8 | 0
- Sat Feb 16 17:32:01 0097 PST | -28800 | -8 | 0
- Thu Feb 16 17:32:01 0597 PST | -28800 | -8 | 0
- Tue Feb 16 17:32:01 1097 PST | -28800 | -8 | 0
- Sat Feb 16 17:32:01 1697 PST | -28800 | -8 | 0
- Thu Feb 16 17:32:01 1797 PST | -28800 | -8 | 0
+ Tue Feb 16 17:32:01 0097 LMT BC | -28378 | -7 | -52
+ Sat Feb 16 17:32:01 0097 LMT | -28378 | -7 | -52
+ Thu Feb 16 17:32:01 0597 LMT | -28378 | -7 | -52
+ Tue Feb 16 17:32:01 1097 LMT | -28378 | -7 | -52
+ Sat Feb 16 17:32:01 1697 LMT | -28378 | -7 | -52
+ Thu Feb 16 17:32:01 1797 LMT | -28378 | -7 | -52
Tue Feb 16 17:32:01 1897 PST | -28800 | -8 | 0
Sun Feb 16 17:32:01 1997 PST | -28800 | -8 | 0
Sat Feb 16 17:32:01 2097 PST | -28800 | -8 | 0
@@ -1249,12 +1249,12 @@ SELECT d1 as "timestamp",
Fri Feb 14 17:32:01 1997 PST | 1000000 | 1000.000 | 1.000000 |
2450495 | 855970321.000000
Sat Feb 15 17:32:01 1997 PST | 1000000 | 1000.000 | 1.000000 |
2450496 | 856056721.000000
Sun Feb 16 17:32:01 1997 PST | 1000000 | 1000.000 | 1.000000 |
2450497 | 856143121.000000
- Tue Feb 16 17:32:01 0097 PST BC | 1000000 | 1000.000 | 1.000000 |
1686043 | -65192682479.000000
- Sat Feb 16 17:32:01 0097 PST | 1000000 | 1000.000 | 1.000000 |
1756537 | -59102000879.000000
- Thu Feb 16 17:32:01 0597 PST | 1000000 | 1000.000 | 1.000000 |
1939158 | -43323546479.000000
- Tue Feb 16 17:32:01 1097 PST | 1000000 | 1000.000 | 1.000000 |
2121779 | -27545092079.000000
- Sat Feb 16 17:32:01 1697 PST | 1000000 | 1000.000 | 1.000000 |
2340925 | -8610877679.000000
- Thu Feb 16 17:32:01 1797 PST | 1000000 | 1000.000 | 1.000000 |
2377449 | -5455204079.000000
+ Tue Feb 16 17:32:01 0097 LMT BC | 1000000 | 1000.000 | 1.000000 |
1686043 | -65192682901.000000
+ Sat Feb 16 17:32:01 0097 LMT | 1000000 | 1000.000 | 1.000000 |
1756537 | -59102001301.000000
+ Thu Feb 16 17:32:01 0597 LMT | 1000000 | 1000.000 | 1.000000 |
1939158 | -43323546901.000000
+ Tue Feb 16 17:32:01 1097 LMT | 1000000 | 1000.000 | 1.000000 |
2121779 | -27545092501.000000
+ Sat Feb 16 17:32:01 1697 LMT | 1000000 | 1000.000 | 1.000000 |
2340925 | -8610878101.000000
+ Thu Feb 16 17:32:01 1797 LMT | 1000000 | 1000.000 | 1.000000 |
2377449 | -5455204501.000000
Tue Feb 16 17:32:01 1897 PST | 1000000 | 1000.000 | 1.000000 |
2413973 | -2299530479.000000
Sun Feb 16 17:32:01 1997 PST | 1000000 | 1000.000 | 1.000000 |
2450497 | 856143121.000000
Sat Feb 16 17:32:01 2097 PST | 1000000 | 1000.000 | 1.000000 |
2487022 | 4011903121.000000
@@ -2251,7 +2251,7 @@ INSERT INTO TIMESTAMPTZ_TST VALUES(4, '1000000312
23:58:48 IST');
SELECT * FROM TIMESTAMPTZ_TST ORDER BY a;
a | b
---+--------------------------------
- 1 | Wed Mar 12 13:58:48 1000 PST
+ 1 | Wed Mar 12 14:05:50 1000 LMT
2 | Sun Mar 12 14:58:48 10000 PDT
3 | Sun Mar 12 14:58:48 100000 PDT
3 | Sun Mar 12 14:58:48 10000 PDT
@@ -2338,7 +2338,7 @@ SELECT make_timestamptz(2014, 12, 10, 0, 0, 0,
'Europe/Prague') AT TIME ZONE 'UT
SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE
'UTC';
timezone
--------------------------
- Wed Dec 09 15:56:00 1846
+ Wed Dec 09 15:56:08 1846
(1 row)
SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE
'UTC';
diff --git a/contrib/pax_storage/src/test/regress/expected/timetz.out
b/contrib/pax_storage/src/test/regress/expected/timetz.out
index 62084eb5f64..228a6dd5d5f 100644
--- a/contrib/pax_storage/src/test/regress/expected/timetz.out
+++ b/contrib/pax_storage/src/test/regress/expected/timetz.out
@@ -222,9 +222,9 @@ SELECT EXTRACT(HOUR FROM TIME WITH TIME ZONE
'2020-05-26 13:30:25.575401-
(1 row)
SELECT EXTRACT(DAY FROM TIME WITH TIME ZONE '2020-05-26
13:30:25.575401-04'); -- error
-ERROR: "time with time zone" units "day" not recognized
+ERROR: unit "day" not supported for type time with time zone
SELECT EXTRACT(FORTNIGHT FROM TIME WITH TIME ZONE '2020-05-26
13:30:25.575401-04'); -- error
-ERROR: "time with time zone" units "fortnight" not recognized
+ERROR: unit "fortnight" not recognized for type time with time zone
SELECT EXTRACT(TIMEZONE FROM TIME WITH TIME ZONE '2020-05-26
13:30:25.575401-04:30');
extract
---------
diff --git a/contrib/pax_storage/src/test/regress/expected/tstypes.out
b/contrib/pax_storage/src/test/regress/expected/tstypes.out
index 2601e312df4..5c6ab35b493 100644
--- a/contrib/pax_storage/src/test/regress/expected/tstypes.out
+++ b/contrib/pax_storage/src/test/regress/expected/tstypes.out
@@ -1259,7 +1259,11 @@ SELECT ts_delete('base hidden rebel spaceship
strike'::tsvector, ARRAY['spaceshi
(1 row)
SELECT ts_delete('base hidden rebel spaceship strike'::tsvector,
ARRAY['spaceship','leya','rebel', NULL]);
-ERROR: lexeme array may not contain nulls
+ ts_delete
+--------------------------
+ 'base' 'hidden' 'strike'
+(1 row)
+
SELECT unnest('base:7 hidden:6 rebel:1 spaceship:2,33A,34B,35C,36D
strike:3'::tsvector);
unnest
---------------------------------------------
@@ -1374,7 +1378,11 @@ SELECT setweight('a asd w:5,6,12B,13A zxc'::tsvector,
'c', '{a,zxc}');
(1 row)
SELECT setweight('a asd w:5,6,12B,13A zxc'::tsvector, 'c', ARRAY['a', 'zxc',
NULL]);
-ERROR: lexeme array may not contain nulls
+ setweight
+---------------------------------
+ 'a' 'asd' 'w':5,6,12B,13A 'zxc'
+(1 row)
+
SELECT ts_filter('base:7A empir:17 evil:15 first:11 galact:16 hidden:6A
rebel:1A spaceship:2A strike:3A victori:12 won:9'::tsvector, '{a}');
ts_filter
-------------------------------------------------------------
diff --git a/contrib/pax_storage/src/test/regress/expected/xid.out
b/contrib/pax_storage/src/test/regress/expected/xid.out
index b7a1ed0f9ee..7c1ed723100 100644
--- a/contrib/pax_storage/src/test/regress/expected/xid.out
+++ b/contrib/pax_storage/src/test/regress/expected/xid.out
@@ -15,29 +15,21 @@ select '010'::xid,
-- garbage values are not yet rejected (perhaps they should be)
select ''::xid;
- xid
------
- 0
-(1 row)
-
+ERROR: invalid input syntax for type xid: ""
+LINE 1: select ''::xid;
+ ^
select 'asdf'::xid;
- xid
------
- 0
-(1 row)
-
+ERROR: invalid input syntax for type xid: "asdf"
+LINE 1: select 'asdf'::xid;
+ ^
select ''::xid8;
- xid8
-------
- 0
-(1 row)
-
+ERROR: invalid input syntax for type xid8: ""
+LINE 1: select ''::xid8;
+ ^
select 'asdf'::xid8;
- xid8
-------
- 0
-(1 row)
-
+ERROR: invalid input syntax for type xid8: "asdf"
+LINE 1: select 'asdf'::xid8;
+ ^
-- equality
select '1'::xid = '1'::xid;
?column?
diff --git a/contrib/pax_storage/src/test/regress/input/tablespace.source
b/contrib/pax_storage/src/test/regress/input/tablespace.source
index 009df17e61a..8a0ed49a355 100644
--- a/contrib/pax_storage/src/test/regress/input/tablespace.source
+++ b/contrib/pax_storage/src/test/regress/input/tablespace.source
@@ -3,6 +3,8 @@
-- m/DETAIL: The symlinked path \".*\" will be truncated to 100 characters
when sending a TAR to the utilities \(e.g. pg_basebackup\)/
-- end_matchignore
-- create a tablespace using WITH clause
+GRANT ALL ON SCHEMA public TO public;
+
CREATE TABLESPACE regress_tblspacewith LOCATION '@testtablespace@' WITH
(some_nonexistent_parameter = true); -- fail
CREATE TABLESPACE regress_tblspacewith LOCATION '@testtablespace@' WITH
(random_page_cost = 3.0); -- ok
diff --git a/contrib/pax_storage/src/test/regress/output/tablespace.source
b/contrib/pax_storage/src/test/regress/output/tablespace.source
index 066b1a08f23..938bfaa0a94 100644
--- a/contrib/pax_storage/src/test/regress/output/tablespace.source
+++ b/contrib/pax_storage/src/test/regress/output/tablespace.source
@@ -3,6 +3,7 @@
-- m/DETAIL: The symlinked path \".*\" will be truncated to 100 characters
when sending a TAR to the utilities \(e.g. pg_basebackup\)/
-- end_matchignore
-- create a tablespace using WITH clause
+GRANT ALL ON SCHEMA public TO public;
CREATE TABLESPACE regress_tblspacewith LOCATION '@testtablespace@' WITH
(some_nonexistent_parameter = true); -- fail
ERROR: unrecognized parameter "some_nonexistent_parameter"
CREATE TABLESPACE regress_tblspacewith LOCATION '@testtablespace@' WITH
(random_page_cost = 3.0); -- ok
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
