This robot generates gigabytes of CI logs every week. Here is an attempt to
search for "highlights", so it's easier to find actionable information
quickly. New ideas for what patterns to search for are very welcome.
"Current" shows only the most recent results from each submission. The
wider time ranges also show information about historical versions, which
may be useful for flapping tests, and also for hunting for bugs in master.
| 51/5417 |
pure parsers and reentrant scanners |
 |
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out /tmp/cirrus-ci-build/build/testrun/plpgsql/...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:15.632219000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:45:16.257550000 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out /tmp/cirrus-ci-build/src/pl/plpgsql/src/res...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:10.440800468 +0000
+++ /tmp/cirrus-ci-build/src/pl/plpgsql/src/results/plpgsql_record.out 2024-12-26 18:44:35.728059028 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out /tmp/cirrus-ci-build/build/testrun/plpgsql/...
--- /tmp/cirrus-ci-build/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:09.721107522 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:45:48.999413916 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_record.out /Users/admin/pgsql/build/testrun/plpgsql/regr...
--- /Users/admin/pgsql/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:08
+++ /Users/admin/pgsql/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:46:03
@@ -619,256 +619,8 @@
create function sillyaddtwo(int) returns int language plpgsql as
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
-select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_record.out C:/cirrus/build/testrun/plpgsql/re...
--- C:/cirrus/src/pl/plpgsql/src/expected/plpgsql_record.out 2024-12-26 18:43:15.766382500 +0000
+++ C:/cirrus/build/testrun/plpgsql/regress/results/plpgsql_record.out 2024-12-26 18:48:37.683737200 +0000
@@ -620,255 +620,7 @@
$$ declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end $$;
reset check_function_bodies;
select sillyaddtwo(42); -- fail
-ERROR: type "mutable2" does not exist
-LINE 1: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
- ^
-QUERY: declare r mutable2; begin r.f1 := $1; return r.f1 + 2; end
-CONTEXT: compilation of PL/pgSQL function "sillyaddtwo" near line 1
-create table mutable2(f1 int, f2 text);
-select sillyaddtwo(42);
- sillyaddtwo
--------------
- 44
-(1 row)
-
-drop table mutable2;
... |
| 51/5153 |
Prohibit to use EphemeralNamedRelation in materialized views |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.278217000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:31:28.347680000...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.278217000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:32:10.5716090...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.278217000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:31:28.200559000 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.933152676 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2024-12-26 15:34:20.208565009 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.933152676 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/triggers.out 2024-12-26 15:36:57.708380318 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.933152676 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2024-12-26 15:32:09.488706367 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.529903301 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:32:03.540013429...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.529903301 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:32:41.9440730...
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-12-26 15:30:25.529903301 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:32:00.720097483 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-26 15:30:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:31:38
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-26 15:30:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:32:24
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-12-26 15:30:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:31:37
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-26 15:30:30.911958200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-12-26 15:32:55.004165600 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-26 15:30:30.911958200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-12-26 15:35:08.404084100 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-12-26 15:30:30.911958200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/triggers.out 2024-12-26 15:32:44.056895900 +0000
@@ -3737,7 +3737,7 @@
referencing new table as new_table
for each statement execute function make_matview();
insert into my_table values (42);
-ERROR: transition tables cannot be used in rule
+ERROR: transition table cannot be used in rule
CONTEXT: SQL statement "create materialized view mv as select * from new_table"
PL/pgSQL function make_matview() line 1 at SQL statement
drop table my_table; |
| 51/4929 |
apply_scanjoin_target_to_paths and partitionwise join |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:19.338947000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:43:10.376...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:19.338947000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:44:05.5...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:19.338947000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:43:06.969772000 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:18.101028754 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/partition_join.out 2024-12-26 01:47:01.964386223 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/test/recovery/tmp_ch...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:18.101028754 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/partition_join.out 2024-12-26 01:48:31.355719094 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/src/test/regress/results...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:18.101028754 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/partition_join.out 2024-12-26 01:44:38.960777492 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:15.203566128 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:44:06.247...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/recovery/0...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:15.203566128 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:44:41.1...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out /tmp/cirrus-ci-build/build/testrun/regress/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/partition_join.out 2024-12-26 01:41:15.203566128 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:44:03.683899082 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/pg_upgrade/002...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-26 01:40:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:42:11
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/recovery/027_s...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-26 01:40:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:43:10
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/partition_join.out /Users/admin/pgsql/build/testrun/regress/regres...
--- /Users/admin/pgsql/src/test/regress/expected/partition_join.out 2024-12-26 01:40:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:42:11
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/pg_upgrade/0...
--- C:/cirrus/src/test/regress/expected/partition_join.out 2024-12-26 01:41:21.070874400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/partition_join.out 2024-12-26 01:45:05.790164500 +000...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/recovery/027...
--- C:/cirrus/src/test/regress/expected/partition_join.out 2024-12-26 01:41:21.070874400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/partition_join.out 2024-12-26 01:47:29.615757300 +0...
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/partition_join.out C:/cirrus/build/testrun/regress/regr...
--- C:/cirrus/src/test/regress/expected/partition_join.out 2024-12-26 01:41:21.070874400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/partition_join.out 2024-12-26 01:44:59.917093900 +0000
@@ -65,31 +65,24 @@
-- inner join with partially-redundant join clauses
EXPLAIN (COSTS OFF)
SELECT t1.a, t1.c, t2.b, t2.c FROM prt1 t1, prt2 t2 WHERE t1.a = t2.a AND t1.a = t2.b ORDER BY t1.a, t2.b;
- QUERY PLAN
----------------------------------------------------------------
- Sort
- Sort Key: t1.a
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (t1.a = t2.a)
-> Append
- -> Merge Join
- Merge Cond: (t1_1.a = t2_1.a)
- -> Index Scan using iprt1_p1_a on prt1_p1 t1_1
- -> Sort
... |
| 51/4720 |
"unexpected duplicate for tablespace" problem in logical replication |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:08.233571000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:30:51.176942...
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39428 | | 0 | 39428 | pktable
+ 39435 | | 0 | 39435 | fktable
+ 39432 | | 0 | 39432 | pktable_pkey
+ 40235 | | 0 | 40240 | foo
+ 40244 | | 0 | 40244 | pg_toast_40235_index
+ 40243 | | 0 | 40243 | pg_toast_40235
+ 40473 | | 0 | 40473 | old_oids
+ 40490 | | 0 | 40490 | pg_toast_40487
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:08.233571000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:31:34.2980...
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39598 | | 0 | 39598 | pktable_pkey
+ 39594 | | 0 | 39594 | pktable
+ 39600 | | 0 | 39600 | fktable
+ 40105 | | 0 | 40113 | foo
+ 40117 | | 0 | 40117 | pg_toast_40105_index
+ 40116 | | 0 | 40116 | pg_toast_40105
+ 40407 | | 0 | 40407 | recur1
+ 40398 | | 0 | 40398 | old_oids
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:08.233571000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:30:47.490434000 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39605 | | 0 | 39605 | pktable_pkey
+ 39599 | | 0 | 39599 | pktable
+ 39608 | | 0 | 39608 | fktable
+ 40233 | | 0 | 40238 | foo
+ 40242 | | 0 | 40242 | pg_toast_40233_index
+ 40241 | | 0 | 40241 | pg_toast_40233
+ 40471 | | 0 | 40471 | old_oids
+ 40488 | | 0 | 40488 | pg_toast_40485
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.898824595 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/alter_table.out 2024-12-25 20:34:49.954189907 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39829 | | 0 | 39829 | pktable_pkey
+ 39825 | | 0 | 39825 | pktable
+ 39831 | | 0 | 39831 | fktable
+ 40322 | | 0 | 40336 | foo
+ 40340 | | 0 | 40340 | pg_toast_40322_index
+ 40339 | | 0 | 40339 | pg_toast_40322
+ 40558 | | 0 | 40558 | old_oids
+ 40579 | | 0 | 40579 | pg_toast_40576
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.898824595 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/alter_table.out 2024-12-25 20:36:00.062181455 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39730 | | 0 | 39730 | pktable_pkey
+ 39726 | | 0 | 39726 | pktable
+ 39735 | | 0 | 39735 | fktable
+ 40216 | | 0 | 40224 | foo
+ 40228 | | 0 | 40228 | pg_toast_40216_index
+ 40227 | | 0 | 40227 | pg_toast_40216
+ 40475 | | 0 | 40475 | old_oids
+ 40492 | | 0 | 40492 | pg_toast_40489
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/regress/results/al...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.898824595 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/alter_table.out 2024-12-25 20:32:12.362230958 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39807 | | 0 | 39807 | pktable_pkey
+ 39803 | | 0 | 39803 | pktable
+ 39809 | | 0 | 39809 | fktable
+ 40287 | | 0 | 40292 | foo
+ 40296 | | 0 | 40296 | pg_toast_40287_index
+ 40295 | | 0 | 40295 | pg_toast_40287
+ 40546 | | 0 | 40546 | old_oids
+ 40565 | | 0 | 40565 | pg_toast_40562
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.295837565 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:31:38.494453...
@@ -3488,9 +3488,29 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39845 | | 0 | 39845 | pg_toast_39839_index
+ 39839 | | 0 | 39839 | users
+ 39838 | | 0 | 39838 | users_id_seq
+ 39844 | | 0 | 39844 | pg_toast_39839
+ 40051 | | 0 | 40051 | foo
+ 40216 | | 0 | 40216 | forc_test
+ 40682 | | 0 | 40682 | pg_toast_40679
+ 40683 | | 0 | 40683 | pg_toast_40679_index
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.295837565 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:32:13.6553...
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39562 | | 0 | 39562 | pktable_pkey
+ 39558 | | 0 | 39558 | pktable
+ 39564 | | 0 | 39564 | fktable
+ 40035 | | 0 | 40040 | foo
+ 40044 | | 0 | 40044 | pg_toast_40035_index
+ 40043 | | 0 | 40043 | pg_toast_40035
+ 40275 | | 0 | 40275 | old_oids
+ 40294 | | 0 | 40294 | pg_toast_40291
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-12-25 20:29:06.295837565 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:31:31.718308815 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39622 | | 0 | 39622 | pktable_pkey
+ 39618 | | 0 | 39618 | pktable
+ 39624 | | 0 | 39624 | fktable
+ 40119 | | 0 | 40126 | foo
+ 40130 | | 0 | 40130 | pg_toast_40119_index
+ 40129 | | 0 | 40129 | pg_toast_40119
+ 40367 | | 0 | 40367 | old_oids
+ 40385 | | 0 | 40385 | pg_toast_40382
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-12-25 20:28:11
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:30:21
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 38532 | | 0 | 38532 | pktable_pkey
+ 38528 | | 0 | 38528 | pktable
+ 38553 | | 0 | 38553 | fktable
+ 40132 | | 0 | 40137 | foo
+ 40141 | | 0 | 40141 | pg_toast_40132_index
+ 40140 | | 0 | 40140 | pg_toast_40132
+ 40433 | | 0 | 40433 | old_oids
+ 40450 | | 0 | 40450 | pg_toast_40447
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-12-25 20:28:11
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:31:15
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39344 | | 0 | 39344 | pktable_pkey
+ 39338 | | 0 | 39338 | pktable
+ 39350 | | 0 | 39350 | fktable
+ 40052 | | 0 | 40057 | foo
+ 40061 | | 0 | 40061 | pg_toast_40052_index
+ 40060 | | 0 | 40060 | pg_toast_40052
+ 40262 | | 0 | 40262 | old_oids
+ 40288 | | 0 | 40288 | pg_toast_40283
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-12-25 20:28:11
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:30:25
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39531 | | 0 | 39531 | pktable_pkey
+ 39527 | | 0 | 39527 | pktable
+ 39533 | | 0 | 39533 | fktable
+ 40141 | | 0 | 40146 | foo
+ 40150 | | 0 | 40150 | pg_toast_40141_index
+ 40149 | | 0 | 40149 | pg_toast_40141
+ 40357 | | 0 | 40357 | old_oids
+ 40377 | | 0 | 40377 | pg_toast_40374
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-12-25 20:29:13.346342700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-12-25 20:32:52.682167300 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39032 | | 0 | 39032 | pktable_pkey
+ 39028 | | 0 | 39028 | pktable
+ 39035 | | 0 | 39035 | fktable
+ 39763 | | 0 | 39763 | pg_toast_39745_index
+ 39745 | | 0 | 39758 | foo
+ 39761 | | 0 | 39761 | pg_toast_39745
+ 39998 | | 0 | 39998 | old_oids
+ 40016 | | 0 | 40016 | pg_toast_40013
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-12-25 20:29:13.346342700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-12-25 20:35:05.324360200 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 38818 | | 0 | 38818 | pktable_pkey
+ 38813 | | 0 | 38813 | pktable
+ 38821 | | 0 | 38821 | fktable
+ 39712 | | 0 | 39717 | foo
+ 39721 | | 0 | 39721 | pg_toast_39712_index
+ 39720 | | 0 | 39720 | pg_toast_39712
+ 39991 | | 0 | 39991 | old_oids
+ 40008 | | 0 | 40008 | pg_toast_40005
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-12-25 20:29:13.346342700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/alter_table.out 2024-12-25 20:32:47.986854200 +0000
@@ -3488,9 +3488,20 @@
WHERE relkind IN ('r', 'i', 'S', 't', 'm') AND mapped_oid IS DISTINCT FROM oid;
SELECT m.* FROM filenode_mapping m LEFT JOIN pg_class c ON c.oid = m.oid
WHERE c.oid IS NOT NULL OR m.mapped_oid IS NOT NULL;
- oid | mapped_oid | reltablespace | relfilenode | relname
------+------------+---------------+-------------+---------
-(0 rows)
+ oid | mapped_oid | reltablespace | relfilenode | relname
+-------+------------+---------------+-------------+----------------------
+ 39387 | | 0 | 39387 | pktable_pkey
+ 39383 | | 0 | 39383 | pktable
+ 39391 | | 0 | 39391 | fktable
+ 39900 | | 0 | 39905 | foo
+ 39909 | | 0 | 39909 | pg_toast_39900_index
+ 39908 | | 0 | 39908 | pg_toast_39900
+ 40101 | | 0 | 40101 | old_oids
+ 40118 | | 0 | 40118 | pg_toast_40115
... |
| 51/5357 |
New predefined role pg_manage_extensions |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:26.343310000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:29:22.799470000 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:23.543282500 +0000
+++ /tmp/cirrus-ci-build/src/pl/plperl/results/plperl_setup.out 2024-12-25 12:28:44.822942247 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out /tmp/cirrus-ci-build/build/testrun/plperl/regress/...
--- /tmp/cirrus-ci-build/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:25.598226619 +0000
+++ /tmp/cirrus-ci-build/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:30:04.168385696 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out /Users/admin/pgsql/build/testrun/plperl/regress/resu...
--- /Users/admin/pgsql/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:11
+++ /Users/admin/pgsql/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:29:49
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/pl/plperl/expected/plperl_setup.out C:/cirrus/build/testrun/plperl/regress/re...
--- C:/cirrus/src/pl/plperl/expected/plperl_setup.out 2024-12-25 12:27:27.981901400 +0000
+++ C:/cirrus/build/testrun/plperl/regress/results/plperl_setup.out 2024-12-25 12:32:41.967228500 +0000
@@ -12,7 +12,7 @@
HINT: Must have CREATE privilege on current database to create this extension.
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
RESET ROLE;
DO $$
begin
@@ -24,7 +24,7 @@
CREATE EXTENSION plperl;
CREATE EXTENSION plperlu; -- fail
ERROR: permission denied to create extension "plperlu"
-HINT: Must be superuser to create this extension.
+HINT: Only roles with privileges of the "pg_manage_extensions" role are allowed to create this extension.
CREATE SCHEMA plperl_setup_scratch;
SET search_path = plperl_setup_scratch;
... |
| 51/5231 |
Consider the number of columns in the sort cost model |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:44.853542000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:45:43.2746140...
@@ -383,26 +383,24 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/contrib/pg_sta...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:41.267289208 +0000
+++ /tmp/cirrus-ci-build/contrib/pg_stat_statements/results/level_tracking.out 2024-12-25 04:48:22.386557776 +0000
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:40.779184813 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:48:34.6344829...
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out /Users/admin/pgsql/build/testrun/pg_s...
--- /Users/admin/pgsql/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:10
+++ /Users/admin/pgsql/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:45:37
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out C:/cirrus/build/testrun/pg...
--- C:/cirrus/contrib/pg_stat_statements/expected/level_tracking.out 2024-12-25 04:42:45.634097900 +0000
+++ C:/cirrus/build/testrun/pg_stat_statements/regress/results/level_tracking.out 2024-12-25 04:49:04.401937200 +0000
@@ -383,25 +383,23 @@
(1 row)
EXPLAIN (COSTS OFF) SELECT 1, 2 UNION SELECT 3, 4\; EXPLAIN (COSTS OFF) (SELECT 1, 2, 3) UNION SELECT 3, 4, 5;
+ QUERY PLAN
+-----------------------
+ HashAggregate
+ Group Key: (1), (2)
+ -> Append
+ -> Result
+ -> Result
+(5 rows)
+
QUERY PLAN
----------------------------
- Unique
- -> Sort
... |
| 51/5283 |
Replace IN VALUES with ANY in WHERE clauses during optimization |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress-running...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-25 02:18:12.369503000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/subselect.out 2024-12-25 02:23:02.551671000 +0000
@@ -2831,15 +2831,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::integer[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/subselect.out /Users/admin/pgsql/build/testrun/regress/regress/res...
--- /Users/admin/pgsql/src/test/regress/expected/subselect.out 2024-12-25 02:17:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/subselect.out 2024-12-25 02:18:40
@@ -2831,15 +2831,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::integer[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/subselect.out C:/cirrus/build/testrun/pg_upgrade/002_pg...
--- C:/cirrus/src/test/regress/expected/subselect.out 2024-12-25 02:18:12.988955400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/subselect.out 2024-12-25 02:20:43.914777300 +0000
@@ -2831,15 +2831,16 @@
EXPLAIN (COSTS OFF)
SELECT c.oid,c.relname FROM pg_class c JOIN pg_am a USING (oid)
WHERE c.oid IN (VALUES (1), (2));
- QUERY PLAN
----------------------------------------------------------------
- Hash Join
- Hash Cond: (a.oid = c.oid)
- -> Seq Scan on pg_am a
- -> Hash
- -> Index Scan using pg_class_oid_index on pg_class c
- Index Cond: (oid = ANY ('{1,2}'::integer[]))
-(6 rows)
+ QUERY PLAN
+---------------------------------------------------------
+ Merge Join
+ Merge Cond: (c.oid = a.oid)
... |
| 51/5426 |
Add a warning message when using unencrypted passwords |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:09.516418000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:36:56.957338000 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/src/interfaces...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:05.781787584 +0000
+++ /tmp/cirrus-ci-build/src/interfaces/ecpg/test/results/connect-test5.stderr 2024-12-24 23:36:07.767947448 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:04.398228592 +0000
+++ /tmp/cirrus-ci-build/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:37:26.827199872 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/interfaces/ecpg/test/expected/connect-test5.stderr /Users/admin/pgsql/build/testrun/ecpg...
--- /Users/admin/pgsql/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:33:11
+++ /Users/admin/pgsql/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:36:16
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/interfaces/ecpg/test/expected/connect-test5.stderr C:/cirrus/build/testrun/ec...
--- C:/cirrus/src/interfaces/ecpg/test/expected/connect-test5.stderr 2024-12-24 23:34:10.389485400 +0000
+++ C:/cirrus/build/testrun/ecpg/ecpg/results/connect-test5.stderr 2024-12-24 23:41:21.430007700 +0000
@@ -4,16 +4,24 @@
[NO_PID]: sqlca: code: 0, state: 00000
[NO_PID]: ecpg_execute on line 24: query: alter user regress_ecpg_user2 encrypted password 'insecure'; with 0 parameter...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: ECPGnoticeReceiver: using a plaintext password in a query
[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: raising sqlcode 0
+[NO_PID]: sqlca: code: 0, state: 01000
+[NO_PID]: ecpg_execute on line 24: using PQexec
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_process_output on line 24: OK: ALTER ROLE
-[NO_PID]: sqlca: code: 0, state: 00000
+[NO_PID]: sqlca: code: 0, state: 01000
[NO_PID]: ecpg_execute on line 25: query: alter user regress_ecpg_user1 encrypted password 'connectpw'; with 0 paramete...
[NO_PID]: sqlca: code: 0, state: 00000
-[NO_PID]: ecpg_execute on line 25: using PQexec
... |
| 51/5004 |
CREATE INDEX CONCURRENTLY for partitioned tables |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:53.795053000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:44:34.421142000...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:53.795053000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:45:16.4076170...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:53.795053000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:44:27.234053000 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:52.095517833 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/indexing.out 2024-12-24 21:50:00.885064045 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/partitioned-cic.out /tmp/cirrus-ci-build/src/test/isolation/ou...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/partitioned-cic.out 2024-12-24 21:41:51.935899903 +0000
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/partitioned-cic.out 2024-12-24 22:11:20.726967585 +0000
@@ -3,10 +3,14 @@
starting permutation: lock_p1 cic insert drop2 commit chk_content
step lock_p1: lock cictab_part_1 in row exclusive mode;
step cic: CREATE INDEX CONCURRENTLY ON cictab(i); <waiting ...>
-step insert: insert into cictab values (1, 1), (11, 1);
-step drop2: DROP TABLE cictab_part_2;
+step insert: insert into cictab values (1, 1), (11, 1); <waiting ...>
+isolationtester: canceling step insert after 360 seconds
+step insert: <... completed>
+ERROR: canceling statement due to user request
+step drop2: DROP TABLE cictab_part_2; <waiting ...>
step commit: COMMIT;
step cic: <... completed>
+step drop2: <... completed>
step chk_content:
set enable_seqscan to off;
explain (costs off) select * from cictab where i > 0;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/re...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:52.095517833 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/indexing.out 2024-12-24 21:51:11.109182786 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/src/test/regress/results/index...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:52.095517833 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/indexing.out 2024-12-24 21:47:28.793561102 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:49.897450807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:47:28.752822999...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:49.897450807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:47:56.5447977...
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/indexing.out 2024-12-24 21:41:49.897450807 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:47:22.008829612 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2024-12-24 21:41:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:46:31
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2024-12-24 21:41:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:47:13
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/indexing.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/indexing.out 2024-12-24 21:41:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:46:34
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/indexing.out 2024-12-24 21:41:57.321626000 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/indexing.out 2024-12-24 21:45:43.545955900 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/indexing.out 2024-12-24 21:41:57.321626000 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/indexing.out 2024-12-24 21:47:43.918950300 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/indexing.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/indexing.out 2024-12-24 21:41:57.321626000 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/indexing.out 2024-12-24 21:45:38.816478000 +0000
@@ -77,7 +77,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart_a_idx" btree (a)
- "idxpart_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 3 (Use \d+ to list them.)
\d idxpart1
@@ -91,7 +90,6 @@
Partition key: RANGE (a)
Indexes:
"idxpart1_a_idx" btree (a)
- "idxpart1_a_idx1" UNIQUE, btree (a) INVALID
Number of partitions: 1 (Use \d+ to list them.)
\d idxpart11
@@ -105,7 +103,6 @@
... |
| 51/5421 |
Use streaming read API in pgstattuple. |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out /tmp/cirrus-ci-build/build-32/testrun/pgstatt...
--- /tmp/cirrus-ci-build/contrib/pgstattuple/expected/pgstattuple.out 2024-12-24 15:54:19.852404282 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pgstattuple/regress/results/pgstattuple.out 2024-12-24 16:03:33.235581706 +000...
@@ -134,7 +134,7 @@
select * from pgstathashindex('test_hashidx');
version | bucket_pages | overflow_pages | bitmap_pages | unused_pages | live_items | dead_items | free_percent
---------+--------------+----------------+--------------+--------------+------------+------------+--------------
- 4 | 4 | 0 | 1 | 0 | 0 | 0 | 100
+ 4 | 2 | 0 | 1 | 0 | 0 | 0 | 100
(1 row)
create index test_gistidx ON test USING gist(c);
@@ -166,7 +166,7 @@
select pgstattuple('test_hashidx');
pgstattuple
---------------------------------
- (49152,0,0,0,0,0,0,32608,66.34)
+ (32768,0,0,0,0,0,0,16304,49.76)
(1 row)
... |
| 51/5284 |
database-specific role memberships |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out /tmp/cirrus-ci-build/build/testrun/regress-runni...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privs_in_db.out 2024-12-24 13:46:12.561476000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/privs_in_db.out 2024-12-24 13:52:20.405797000 +00...
@@ -756,9 +756,10 @@
DROP DATABASE regression_db_0;
DROP ROLE regress_role_admin;
SELECT datname FROM pg_database WHERE datname LIKE 'regression_db_%';
- datname
----------
-(0 rows)
+ datname
+-------------------
+ regression_dblink
+(1 row)
SELECT rolname FROM pg_roles WHERE rolname LIKE 'regress_role_%';
rolname |
| 51/5404 |
Self contradictory examining on rel's baserestrictinfo |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/r...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:40.429167000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:12:22.617855000 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:42.001962000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:11:06.337289000...
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:42.001962000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:11:45.0405330...
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:42.001962000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2024-12-24 13:11:05.482641000 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/contrib/btree_gin/results/bool.ou...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:38.150463286 +0000
+++ /tmp/cirrus-ci-build/contrib/btree_gin/results/bool.out 2024-12-24 13:14:39.638541081 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:40.096883002 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/horology.out 2024-12-24 13:14:57.958497556 +0000
@@ -2541,18 +2541,18 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+--------------------------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
+ Filter: (f1 <= '01-01-1998'::date)
(3 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/src/test/regress/results/horol...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:40.096883002 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/horology.out 2024-12-24 13:12:58.206642600 +0000
@@ -2541,18 +2541,18 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+--------------------------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
+ Filter: (f1 <= '01-01-1998'::date)
(3 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/r...
--- /tmp/cirrus-ci-build/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:36.694570253 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:13:46.162002211 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:38.582570322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:13:03.814097954...
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:38.582570322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:13:30.6340355...
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/horology.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/horology.out 2024-12-24 13:09:38.582570322 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/horology.out 2024-12-24 13:13:00.442099198 +0000
@@ -2541,1334 +2541,7 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
- Aggregate
- -> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
-
-select count(*) from date_tbl
- where f1 between symmetric '1997-01-01' and '1998-01-01';
- count
--------
- 3
-(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/btree_gin/expected/bool.out /Users/admin/pgsql/build/testrun/btree_gin/regress/resul...
--- /Users/admin/pgsql/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:10
+++ /Users/admin/pgsql/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:12:15
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-24 13:09:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:10:57
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-24 13:09:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:11:42
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/horology.out /Users/admin/pgsql/build/testrun/regress/regress/resu...
--- /Users/admin/pgsql/src/test/regress/expected/horology.out 2024-12-24 13:09:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/horology.out 2024-12-24 13:10:55
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/btree_gin/expected/bool.out C:/cirrus/build/testrun/btree_gin/regress/res...
--- C:/cirrus/contrib/btree_gin/expected/bool.out 2024-12-24 13:09:40.220296400 +0000
+++ C:/cirrus/build/testrun/btree_gin/regress/results/bool.out 2024-12-24 13:15:26.926398700 +0000
@@ -109,15 +109,13 @@
(6 rows)
EXPLAIN (COSTS OFF) SELECT * FROM test_bool WHERE i>true ORDER BY i;
- QUERY PLAN
--------------------------------------------
+ QUERY PLAN
+--------------------------------
Sort
Sort Key: i
- -> Bitmap Heap Scan on test_bool
- Recheck Cond: (i > true)
- -> Bitmap Index Scan on idx_bool
- Index Cond: (i > true)
-(6 rows)
+ -> Result
+ One-Time Filter: false
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/pg_upgrade/002_pg_...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-24 13:09:44.946359300 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/horology.out 2024-12-24 13:11:50.208965100 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-24 13:09:44.946359300 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/horology.out 2024-12-24 13:13:59.773093700 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/horology.out C:/cirrus/build/testrun/regress/regress/re...
--- C:/cirrus/src/test/regress/expected/horology.out 2024-12-24 13:09:44.946359300 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/horology.out 2024-12-24 13:11:44.560454000 +0000
@@ -2541,18 +2541,17 @@
explain (costs off)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
- QUERY PLAN
------------------------------------------------------------------------------
+ QUERY PLAN
+----------------------------
Aggregate
-> Seq Scan on date_tbl
- Filter: ((f1 >= '01-01-1997'::date) AND (f1 <= '01-01-1998'::date))
-(3 rows)
+(2 rows)
select count(*) from date_tbl
where f1 between symmetric '1997-01-01' and '1998-01-01';
count
... |
| 51/5410 |
Disable installcheck for tap and regress tests for injection_points module |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/build/testrun/in...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:12.572348000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:43:45.933680000 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-24 11:41:12.572541000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/inplace.out 2024-12-24 11:43:45.993155000 +000...
@@ -1,340 +1,2 @@
Parsed test spec with 3 sessions
-
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/src/test/modules...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:08.612625080 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/crash.out 2024-12-24 11:46:06.431478570 +0...
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/src/test/modul...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-24 11:41:08.612625080 +0000
+++ /tmp/cirrus-ci-build/src/test/modules/injection_points/output_iso/results/inplace.out 2024-12-24 11:46:07.023485363 ...
@@ -14,327 +14,6 @@
step vac1: VACUUM vactest.orig50; -- wait during inplace update <waiting ...>
step grant2: GRANT SELECT ON TABLE vactest.orig50 TO PUBLIC;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out /tmp/cirrus-ci-build/build/testrun/in...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:07.706979560 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:43:59.238721127 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT;
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/inplace.out 2024-12-24 11:41:07.706979560 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points/isolation/results/inplace.out 2024-12-24 11:43:59.742720942 +000...
@@ -47,294 +47,6 @@
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/modules/injection_points/expected/crash.out /Users/admin/pgsql/build/testrun/inject...
--- /Users/admin/pgsql/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:40:11
+++ /Users/admin/pgsql/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:43:32
@@ -23,4 +23,20 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+s2: WARNING: AbortTransaction while in ABORT state
+ERROR: ResourceOwnerEnlarge called after release started
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
+s3: WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
step c3: COMMIT;
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/modules/injection_points/expected/crash.out C:/cirrus/build/testrun/inje...
--- C:/cirrus/src/test/modules/injection_points/expected/crash.out 2024-12-24 11:41:12.775965400 +0000
+++ C:/cirrus/build/testrun/injection_points/isolation/results/crash.out 2024-12-24 11:48:28.716653100 +0000
@@ -23,4 +23,10 @@
step c2: COMMIT;
ERROR: could not serialize access due to read/write dependencies among transactions
+ERROR: ResourceOwnerEnlarge called after release started
+s2: WARNING: AbortTransaction while in ABORT state
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+
step c3: COMMIT; |
| 51/5117 |
VACUUM FULL / CLUSTER CONCURRENTLY |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/cluster.out /tmp/cirrus-ci-build/build/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/injection_points/expected/cluster.out 2024-12-24 08:28:02.575619000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/injection_points-running/isolation/results/cluster.out 2024-12-24 08:34:11.781113...
@@ -8,7 +8,8 @@
step wait_before_lock:
CLUSTER (CONCURRENTLY) clstr_test USING clstr_test_pkey;
- <waiting ...>
+
+ERROR: logical decoding requires "wal_level" >= "logical"
step change_existing:
UPDATE clstr_test SET i=10 where i=1;
UPDATE clstr_test SET j=20 where i=2;
@@ -63,12 +64,7 @@
step wakeup_before_lock:
SELECT injection_points_wakeup('cluster-concurrently-before-lock');
-injection_points_wakeup
------------------------
-
... |
| 51/4980 |
Expand applicability of aggregate's sortop optimization |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/build/testrun/regress/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-24 07:43:04.231869000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/subselect.out 2024-12-24 07:45:13.759204000 +0000
@@ -1029,7 +1029,7 @@
-> Seq Scan on tenk1 t
Filter: ((ANY (unique2 = (hashed SubPlan 2).col1)) OR (ten < 0))
SubPlan 2
- -> Index Only Scan using tenk1_unique1 on tenk1 k
+ -> Index Only Scan using idx_int4 on tenk1 k
(5 rows)
select count(*) from tenk1 t |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/subselect.out 2024-12-24 07:43:04.253707613 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/subselect.out 2024-12-24 07:50:28.703533314 +0000
@@ -1029,7 +1029,7 @@
-> Seq Scan on tenk1 t
Filter: ((ANY (unique2 = (hashed SubPlan 2).col1)) OR (ten < 0))
SubPlan 2
- -> Index Only Scan using tenk1_unique1 on tenk1 k
+ -> Index Only Scan using idx_int4 on tenk1 k
(5 rows)
select count(*) from tenk1 t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/test/regress/results/bt...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-12-24 07:43:04.169778473 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/btree_index.out 2024-12-24 07:47:35.479861429 +0000
@@ -158,13 +158,10 @@
set enable_bitmapscan to false;
explain (costs off)
select hundred, twenty from tenk1 where hundred < 48 order by hundred desc limit 1;
- QUERY PLAN
---------------------------------------------------------
- Limit
- -> Index Scan Backward using tenk1_hundred on tenk1
- Index Cond: (hundred < 48)
-(3 rows)
-
+ERROR: deadlock detected
+DETAIL: Process 24182 waits for AccessShareLock on relation 25247 of database 16384; blocked by process 24171.
+Process 24171 waits for AccessExclusiveLock on relation 16418 of database 16384; blocked by process 24182.
+HINT: See server log for query details.
select hundred, twenty from tenk1 where hundred < 48 order by hundred desc limit 1;
hundred | twenty
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_distinct.out 2024-12-24 07:43:06.334965020 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_distinct.out 2024-12-24 07:48:11.51...
@@ -334,13 +334,10 @@
-- Ensure we get a plan with a Limit 1 when the SELECT list contains constants
EXPLAIN (COSTS OFF)
SELECT DISTINCT four,1,2,3 FROM tenk1 WHERE four = 0;
- QUERY PLAN
-----------------------------
- Limit
- -> Seq Scan on tenk1
- Filter: (four = 0)
-(3 rows)
-
+ERROR: deadlock detected
+DETAIL: Process 30127 waits for AccessShareLock on relation 25296 of database 16387; blocked by process 30131.
+Process 30131 waits for AccessExclusiveLock on relation 16421 of database 16387; blocked by process 30127.
+HINT: See server log for query details.
-- Ensure we only get 1 row
SELECT DISTINCT four,1,2,3 FROM tenk1 WHERE four = 0;
... |
| 51/5446 |
Improving default column names/aliases of subscript text expressions |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-24 07:24:31.945023000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:27:08.272283000 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.457245000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:26:31.962999000 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.457245000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:27:18.769405000 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.457245000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:26:29.351402000 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-24 07:24:32.014939519 +0000
+++ /tmp/cirrus-ci-build/contrib/hstore/results/hstore.out 2024-12-24 07:29:38.911119229 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.905849886 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/jsonb.out 2024-12-24 07:31:09.814775232 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.905849886 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/jsonb.out 2024-12-24 07:33:11.135683375 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/src/test/regress/results/jsonb.ou...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.905849886 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/jsonb.out 2024-12-24 07:29:15.226774157 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out /tmp/cirrus-ci-build/build/testrun/hstore/regress/resul...
--- /tmp/cirrus-ci-build/contrib/hstore/expected/hstore.out 2024-12-24 07:24:32.053727994 +0000
+++ /tmp/cirrus-ci-build/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:29:32.739505344 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_u...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.937838051 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:29:08.731541223 +0...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.937838051 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:29:49.099463646 ...
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out /tmp/cirrus-ci-build/build/testrun/regress/regress/res...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb.out 2024-12-24 07:24:33.937838051 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:29:01.035544555 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/hstore/expected/hstore.out /Users/admin/pgsql/build/testrun/hstore/regress/results/h...
--- /Users/admin/pgsql/contrib/hstore/expected/hstore.out 2024-12-24 07:24:10
+++ /Users/admin/pgsql/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:27:06
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgra...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-24 07:24:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:25:58
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/recovery/027_stream_reg...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-24 07:24:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:27:02
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/jsonb.out /Users/admin/pgsql/build/testrun/regress/regress/results...
--- /Users/admin/pgsql/src/test/regress/expected/jsonb.out 2024-12-24 07:24:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:26:01
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/hstore/expected/hstore.out C:/cirrus/build/testrun/hstore/regress/results...
--- C:/cirrus/contrib/hstore/expected/hstore.out 2024-12-24 07:24:32.456402100 +0000
+++ C:/cirrus/build/testrun/hstore/regress/results/hstore.out 2024-12-24 07:30:31.197262300 +0000
@@ -1597,7 +1597,7 @@
-- Test subscripting
insert into test_json_agg default values;
select f2['d'], f2['x'] is null as x_isnull from test_json_agg;
- f2 | x_isnull
+ d | x_isnull
--------+----------
12345 | t
-12345 | t |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upg...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-24 07:24:36.640422900 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb.out 2024-12-24 07:28:04.375925500 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/recovery/027_stream_r...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-24 07:24:36.640422900 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/jsonb.out 2024-12-24 07:30:24.009757000 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/jsonb.out C:/cirrus/build/testrun/regress/regress/resul...
--- C:/cirrus/src/test/regress/expected/jsonb.out 2024-12-24 07:24:36.640422900 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/jsonb.out 2024-12-24 07:27:55.078067100 +0000
@@ -4934,8 +4934,8 @@
HINT: Try using the function jsonb_set to replace key value.
-- jsonb subscript
select ('123'::jsonb)['a'];
- jsonb
--------
+ a
+---
(1 row)
@@ -4952,8 +4952,8 @@
(1 row)
select ('{"a": 1}'::jsonb)['a'];
- jsonb
--------
... |
| 51/4620 |
CRC32C Parallel Computation Optimization on ARM |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/test_crc32c/expected/test_crc32c.out /tmp/cirrus-ci-build/build-32/testrun/test_cr...
--- /tmp/cirrus-ci-build/contrib/test_crc32c/expected/test_crc32c.out 2024-12-24 07:07:46.541145890 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/test_crc32c/regress/results/test_crc32c.out 2024-12-24 07:17:10.868461790 +000...
@@ -1,57 +1,6 @@
CREATE EXTENSION test_crc32c;
select drive_crc32c(1, i) from generate_series(100, 300, 4) i;
- drive_crc32c
---------------
- 532139994
- 2103623867
- 785984197
- 2686825890
- 3213049059
- 3819630168
- 1389234603
- 534072900
- 2930108140
- 2496889855
- 1475239611
- 136366931
... |
| 51/5323 |
Support enabling checksums online |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/brin.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/brin.out 2024-12-24 06:02:59.907817800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out 2024-12-24 06:05:47.671263100 +0000
@@ -574,18 +574,10 @@
SET LOCAL min_parallel_table_scan_size = 0;
SET LOCAL max_parallel_maintenance_workers = 4;
CREATE INDEX brintest_expr_idx ON brintest_expr USING brin (brintest_func());
-COMMIT;
-DROP TABLE brintest_expr;
-DROP FUNCTION brintest_func();
--- test an unlogged table, mostly to get coverage of brinbuildempty
-CREATE UNLOGGED TABLE brintest_unlogged (n numrange);
-CREATE INDEX brinidx_unlogged ON brintest_unlogged USING brin (n);
-INSERT INTO brintest_unlogged VALUES (numrange(0, 2^1000::numeric));
-DROP TABLE brintest_unlogged;
--- test that the insert optimization works if no rows end up inserted
-CREATE TABLE brin_insert_optimization (a int);
-INSERT INTO brin_insert_optimization VALUES (1);
-CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
-UPDATE brin_insert_optimization SET a = a;
... |
| 51/5371 |
TimestampTz->Text->TimestampTz casting fails with DateStyle 'Postgres' |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:12.446168000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:45:00.831733...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:12.446168000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:45:40.2874...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:12.446168000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:44:58.841736000 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.801446819 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/timestamptz.out 2024-12-24 05:47:49.905456024 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.801446819 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/timestamptz.out 2024-12-24 05:50:15.809286738 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/src/test/regress/results/ti...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.801446819 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/timestamptz.out 2024-12-24 05:45:34.701571060 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.399777318 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:45:34.743440...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.399777318 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:46:09.5553...
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:09.399777318 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:45:30.915454246 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-24 05:43:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:44:27
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-24 05:43:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:45:13
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/timestamptz.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/timestamptz.out 2024-12-24 05:43:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:44:26
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:14.762700200 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/timestamptz.out 2024-12-24 05:46:18.149717300 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:14.762700200 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/timestamptz.out 2024-12-24 05:48:38.076536900 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/timestamptz.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/timestamptz.out 2024-12-24 05:44:14.762700200 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/timestamptz.out 2024-12-24 05:46:11.925099400 +0000
@@ -184,30 +184,22 @@
(1 row)
SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
- timestamptz
-------------------------------
- Wed Jan 01 00:00:00 1000 LMT
-(1 row)
-
+ERROR: invalid input syntax for type timestamp with time zone: "Jan 01 00:00:00 1000 LMT"
+LINE 1: SELECT 'Jan 01 00:00:00 1000 LMT'::timestamptz;
+ ^
SELECT 'Jan 01 00:00:00 2024 LMT'::timestamptz;
- timestamptz
-------------------------------
- Sun Dec 31 23:52:58 2023 PST
-(1 row)
... |
| 51/5012 |
Vacuum statistics |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/vacuum-extending-in-repetable-read.out /tmp/cirrus-ci-build/bu...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/vacuum-extending-in-repetable-read.out 2024-12-16 04:03:06.97794300...
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/vacuum-extending-in-repetable-read.out 2024-12-16 04:...
@@ -9,10 +9,7 @@
FROM pg_stat_get_vacuum_tables vt, pg_class c
WHERE vt.relname = 'test_vacuum_stat_isolation' AND vt.relid = c.oid;
-relname|tuples_deleted|dead_tuples|tuples_frozen
--------+--------------+-----------+-------------
-(0 rows)
-
+ERROR: relation "pg_stat_get_vacuum_tables" does not exist
step s1_begin_repeatable_read:
BEGIN transaction ISOLATION LEVEL REPEATABLE READ;
select count(ival) from test_vacuum_stat_isolation where id>900;
@@ -22,7 +19,8 @@
100
(1 row)
-step s2_update: UPDATE test_vacuum_stat_isolation SET ival = ival + 2 where id > 900;
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/vacuum-extending-in-repetable-read.out /tmp/cirrus-ci-build/sr...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/vacuum-extending-in-repetable-read.out 2024-12-16 04:03:05.22601433...
+++ /tmp/cirrus-ci-build/src/test/isolation/output_iso/results/vacuum-extending-in-repetable-read.out 2024-12-16 04:09:1...
@@ -9,10 +9,7 @@
FROM pg_stat_get_vacuum_tables vt, pg_class c
WHERE vt.relname = 'test_vacuum_stat_isolation' AND vt.relid = c.oid;
-relname|tuples_deleted|dead_tuples|tuples_frozen
--------+--------------+-----------+-------------
-(0 rows)
-
+ERROR: relation "pg_stat_get_vacuum_tables" does not exist
step s1_begin_repeatable_read:
BEGIN transaction ISOLATION LEVEL REPEATABLE READ;
select count(ival) from test_vacuum_stat_isolation where id>900;
@@ -22,7 +19,8 @@
100
(1 row)
-step s2_update: UPDATE test_vacuum_stat_isolation SET ival = ival + 2 where id > 900;
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/isolation/expected/vacuum-extending-in-repetable-read.out /tmp/cirrus-ci-build/bu...
--- /tmp/cirrus-ci-build/src/test/isolation/expected/vacuum-extending-in-repetable-read.out 2024-12-16 04:03:04.42046300...
+++ /tmp/cirrus-ci-build/build/testrun/isolation/isolation/results/vacuum-extending-in-repetable-read.out 2024-12-16 04:...
@@ -9,10 +9,7 @@
FROM pg_stat_get_vacuum_tables vt, pg_class c
WHERE vt.relname = 'test_vacuum_stat_isolation' AND vt.relid = c.oid;
-relname|tuples_deleted|dead_tuples|tuples_frozen
--------+--------------+-----------+-------------
-(0 rows)
-
+ERROR: relation "pg_stat_get_vacuum_tables" does not exist
step s1_begin_repeatable_read:
BEGIN transaction ISOLATION LEVEL REPEATABLE READ;
select count(ival) from test_vacuum_stat_isolation where id>900;
@@ -22,7 +19,8 @@
100
(1 row)
-step s2_update: UPDATE test_vacuum_stat_isolation SET ival = ival + 2 where id > 900;
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/isolation/expected/vacuum-extending-in-repetable-read.out /Users/admin/pgsql/build/...
--- /Users/admin/pgsql/src/test/isolation/expected/vacuum-extending-in-repetable-read.out 2024-12-16 04:02:12
+++ /Users/admin/pgsql/build/testrun/isolation/isolation/results/vacuum-extending-in-repetable-read.out 2024-12-16 04:05...
@@ -9,10 +9,7 @@
FROM pg_stat_get_vacuum_tables vt, pg_class c
WHERE vt.relname = 'test_vacuum_stat_isolation' AND vt.relid = c.oid;
-relname|tuples_deleted|dead_tuples|tuples_frozen
--------+--------------+-----------+-------------
-(0 rows)
-
+ERROR: relation "pg_stat_get_vacuum_tables" does not exist
step s1_begin_repeatable_read:
BEGIN transaction ISOLATION LEVEL REPEATABLE READ;
select count(ival) from test_vacuum_stat_isolation where id>900;
@@ -22,7 +19,8 @@
100
(1 row)
-step s2_update: UPDATE test_vacuum_stat_isolation SET ival = ival + 2 where id > 900;
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/isolation/expected/vacuum-extending-in-repetable-read.out C:/cirrus/buil...
--- C:/cirrus/src/test/isolation/expected/vacuum-extending-in-repetable-read.out 2024-12-16 04:03:17.079230600 +0000
+++ C:/cirrus/build/testrun/isolation/isolation/results/vacuum-extending-in-repetable-read.out 2024-12-16 04:07:32.34122...
@@ -9,10 +9,7 @@
FROM pg_stat_get_vacuum_tables vt, pg_class c
WHERE vt.relname = 'test_vacuum_stat_isolation' AND vt.relid = c.oid;
-relname|tuples_deleted|dead_tuples|tuples_frozen
--------+--------------+-----------+-------------
-(0 rows)
-
+ERROR: relation "pg_stat_get_vacuum_tables" does not exist
step s1_begin_repeatable_read:
BEGIN transaction ISOLATION LEVEL REPEATABLE READ;
select count(ival) from test_vacuum_stat_isolation where id>900;
@@ -22,7 +19,8 @@
100
(1 row)
-step s2_update: UPDATE test_vacuum_stat_isolation SET ival = ival + 2 where id > 900;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/vacuum_index_statistics.out C:/cirrus/build/testrun/rec...
--- C:/cirrus/src/test/regress/expected/vacuum_index_statistics.out 2024-12-16 04:03:17.749188400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/vacuum_index_statistics.out 2024-12-16 04:09:47.056...
@@ -54,7 +54,7 @@
WHERE vt.relname = 'vestat_pkey' AND vt.relid = c.oid;
relname | relpages | pages_deleted | tuples_deleted
-------------+----------+---------------+----------------
- vestat_pkey | t | t | t
+ vestat_pkey | t | t | f
(1 row)
SELECT vt.relname,relpages AS irp,pages_deleted AS ipd,tuples_deleted AS itd
@@ -67,7 +67,7 @@
FROM pg_stat_get_vacuum_indexes WHERE relname = 'vestat_pkey';
diwr | diwb
------+------
- t | t
+ f | f
(1 row)
... |
| 51/5099 |
CREATE OR REPLACE MATERIALIZED VIEW |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:17.798499000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out 2024-12-13 13:20:27.066589000 +00...
@@ -588,4 +588,10 @@
CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
UPDATE brin_insert_optimization SET a = a;
REINDEX INDEX CONCURRENTLY brin_insert_optimization_idx;
-DROP TABLE brin_insert_optimization;
+WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2024-12-13 13:18:17.854439000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/privileges.out 2024-12-13 13:20:27.0661170...
@@ -1846,1413 +1846,10 @@
REINDEX TABLE sro_tab;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:17.798499000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/brin.out 2024-12-13 13:21:03.525785000 +...
@@ -588,4 +588,10 @@
CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
UPDATE brin_insert_optimization SET a = a;
REINDEX INDEX CONCURRENTLY brin_insert_optimization_idx;
-DROP TABLE brin_insert_optimization;
+WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2024-12-13 13:18:17.854439000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/privileges.out 2024-12-13 13:21:03.52542...
@@ -1846,1413 +1846,10 @@
REINDEX TABLE sro_tab;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:17.798499000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/brin.out 2024-12-13 13:20:25.356997000 +0000
@@ -588,4 +588,10 @@
CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
UPDATE brin_insert_optimization SET a = a;
REINDEX INDEX CONCURRENTLY brin_insert_optimization_idx;
-DROP TABLE brin_insert_optimization;
+WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out /tmp/cirrus-ci-build/build/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/privileges.out 2024-12-13 13:18:17.854439000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/privileges.out 2024-12-13 13:20:25.355307000 +0000
@@ -1842,1417 +1842,10 @@
-- Do the same concurrently
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:09.332636754 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/brin.out 2024-12-13 13:24:38.215727832 +0000
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/src/test/regress/results/brin.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:09.332636754 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/brin.out 2024-12-13 13:22:36.507831152 +0000
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_up...
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:07.709047615 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out 2024-12-13 13:22:58.813282168 +00...
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:07.709047615 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/brin.out 2024-12-13 13:23:31.649189481 +...
@@ -363,229 +363,10 @@
END LOOP;
END;
$x$;
-RESET enable_seqscan;
-RESET enable_bitmapscan;
-INSERT INTO brintest SELECT
- repeat(stringu1, 42)::bytea,
- substr(stringu1, 1, 1)::"char",
- stringu1::name, 142857 * tenthous,
- thousand,
- twothousand,
- repeat(stringu1, 42),
- unique1::oid,
- format('(%s,%s)', tenthous, twenty)::tid,
- (four + 1.0)/(hundred+1),
- odd::float8 / (tenthous + 1),
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/brin.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resu...
--- /tmp/cirrus-ci-build/src/test/regress/expected/brin.out 2024-12-13 13:18:07.709047615 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/brin.out 2024-12-13 13:22:54.397291332 +0000
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/brin.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrad...
--- /Users/admin/pgsql/src/test/regress/expected/brin.out 2024-12-13 13:17:12
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out 2024-12-13 13:20:09
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/brin.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regr...
--- /Users/admin/pgsql/src/test/regress/expected/brin.out 2024-12-13 13:17:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/brin.out 2024-12-13 13:21:01
@@ -588,4 +588,10 @@
CREATE INDEX brin_insert_optimization_idx ON brin_insert_optimization USING brin (a);
UPDATE brin_insert_optimization SET a = a;
REINDEX INDEX CONCURRENTLY brin_insert_optimization_idx;
-DROP TABLE brin_insert_optimization;
+WARNING: terminating connection because of crash of another server process
+DETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because anothe...
+HINT: In a moment you should be able to reconnect to the database and repeat your command.
+server closed the connection unexpectedly
+ This probably means the server terminated abnormally
+ before or while processing the request.
+connection to server was lost
diff -U3 /Users/admin/pgsql/src/test/regress/expected/privileges.out /Users/admin/pgsql/build/testrun/recovery/027_strea...
--- /Users/admin/pgsql/src/test/regress/expected/privileges.out 2024-12-13 13:17:12
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/privileges.out 2024-12-13 13:21:01
@@ -1846,1413 +1846,10 @@
REINDEX TABLE sro_tab;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/brin.out /Users/admin/pgsql/build/testrun/regress/regress/results/...
--- /Users/admin/pgsql/src/test/regress/expected/brin.out 2024-12-13 13:17:12
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/brin.out 2024-12-13 13:20:09
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/brin.out C:/cirrus/build/testrun/pg_upgrade/002_pg_upgr...
--- C:/cirrus/src/test/regress/expected/brin.out 2024-12-13 13:18:31.344091800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/brin.out 2024-12-13 13:21:33.969096100 +0000
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/brin.out C:/cirrus/build/testrun/recovery/027_stream_re...
--- C:/cirrus/src/test/regress/expected/brin.out 2024-12-13 13:18:31.344091800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/brin.out 2024-12-13 13:23:44.511563300 +0000
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/brin.out C:/cirrus/build/testrun/regress/regress/result...
--- C:/cirrus/src/test/regress/expected/brin.out 2024-12-13 13:18:31.344091800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/brin.out 2024-12-13 13:21:25.283060600 +0000
@@ -539,53 +539,10 @@
-- vacuum actually removes the TOAST rows. Creating an index concurrently
-- is a one way to achieve that, because it does exactly such wait.
CREATE INDEX CONCURRENTLY brin_test_temp_idx ON brintest_3(a);
-DROP INDEX brin_test_temp_idx;
--- vacuum the table, to discard TOAST data
-VACUUM brintest_3;
--- retry insert with a different random-looking (but deterministic) value
--- the value is different, and so should replace either min or max in the
--- brin summary
-WITH rand_value AS (SELECT string_agg(fipshash((-i)::text),'') AS val FROM generate_series(1,60) s(i))
-INSERT INTO brintest_3
-SELECT val, val, val, val FROM rand_value;
--- now try some queries, accessing the brin index
-SET enable_seqscan = off;
-EXPLAIN (COSTS OFF)
-SELECT * FROM brintest_3 WHERE b < '0';
... |
| 50/5270 |
jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out /tmp/cirrus-ci-build/build-32/testrun/pg_upgr...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out 2024-11-29 14:31:16.474625998 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/pg_upgrade/002_pg_upgrade/data/results/jsonb_jsonpath.out 2024-11-29 14:37:31....
@@ -3082,7 +3082,7 @@
select jsonb_path_query('"abc~@~def~@~ghi"', '$.split_part("~@~", 2)');
jsonb_path_query
------------------
- "def"
+ ""
(1 row)
-- Test string methods play nicely together |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out /tmp/cirrus-ci-build/build-32/testrun/recover...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out 2024-11-29 14:31:16.474625998 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/jsonb_jsonpath.out 2024-11-29 14:38:1...
@@ -3082,7 +3082,7 @@
select jsonb_path_query('"abc~@~def~@~ghi"', '$.split_part("~@~", 2)');
jsonb_path_query
------------------
- "def"
+ ""
(1 row)
-- Test string methods play nicely together |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out /tmp/cirrus-ci-build/build-32/testrun/regress...
--- /tmp/cirrus-ci-build/src/test/regress/expected/jsonb_jsonpath.out 2024-11-29 14:31:16.474625998 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/jsonb_jsonpath.out 2024-11-29 14:37:28.656595197 +0000
@@ -3082,7 +3082,7 @@
select jsonb_path_query('"abc~@~def~@~ghi"', '$.split_part("~@~", 2)');
jsonb_path_query
------------------
- "def"
+ ""
(1 row)
-- Test string methods play nicely together |
| 51/5334 |
Support regular expressions with nondeterministic collations |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/citext/expected/citext.out /tmp/cirrus-ci-build/build-32/testrun/citext/regress/re...
--- /tmp/cirrus-ci-build/contrib/citext/expected/citext.out 2024-11-24 10:01:13.969088011 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/citext/regress/results/citext.out 2024-11-24 10:07:27.360352379 +0000
@@ -500,2185 +500,7 @@
-- SIMILAR TO should be case-insensitive.
SELECT name FROM srt WHERE name SIMILAR TO '%a.*';
- name
-------
- ABA
-(1 row)
-
-SELECT name FROM srt WHERE name SIMILAR TO '%A.*';
- name
-------
- ABA
-(1 row)
-
--- Explicit casts.
-SELECT true::citext = 'true' AS t;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/strings.out /tmp/cirrus-ci-build/build-32/testrun/recovery/027_s...
--- /tmp/cirrus-ci-build/src/test/regress/expected/strings.out 2024-11-24 10:01:15.908705241 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/recovery/027_stream_regress/data/results/strings.out 2024-11-24 10:07:02.74814...
@@ -438,2255 +438,7 @@
ERROR: negative substring length not allowed
-- T581 regular expression substring (with SQL's bizarre regexp syntax)
SELECT SUBSTRING('abcdefg' SIMILAR 'a#"(b_d)#"%' ESCAPE '#') AS "bcd";
- bcd
------
- bcd
-(1 row)
-
--- obsolete SQL99 syntax
-SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d)#"%' FOR '#') AS "bcd";
- bcd
------
- bcd
-(1 row)
-
--- No match should return NULL
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/strings.out /tmp/cirrus-ci-build/build-32/testrun/regress/regres...
--- /tmp/cirrus-ci-build/src/test/regress/expected/strings.out 2024-11-24 10:01:15.908705241 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/regress/regress/results/strings.out 2024-11-24 10:06:24.863921507 +0000
@@ -438,2255 +438,7 @@
ERROR: negative substring length not allowed
-- T581 regular expression substring (with SQL's bizarre regexp syntax)
SELECT SUBSTRING('abcdefg' SIMILAR 'a#"(b_d)#"%' ESCAPE '#') AS "bcd";
- bcd
------
- bcd
-(1 row)
-
--- obsolete SQL99 syntax
-SELECT SUBSTRING('abcdefg' FROM 'a#"(b_d)#"%' FOR '#') AS "bcd";
- bcd
------
- bcd
-(1 row)
-
--- No match should return NULL
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_regex/expected/test_regex.out /tmp/cirrus-ci-build/build-32/testrun/...
--- /tmp/cirrus-ci-build/src/test/modules/test_regex/expected/test_regex.out 2024-11-24 10:01:15.761575425 +0000
+++ /tmp/cirrus-ci-build/build-32/testrun/test_regex/regress/results/test_regex.out 2024-11-24 10:07:47.096538073 +0000
@@ -1010,4089 +1010,7 @@
ERROR: invalid regular expression: invalid character range
-- expectMatch 9.15 &LP {[[:<:]]a} a a
select * from test_regex('[[:<:]]a', 'a', 'LP');
- test_regex
--------------------------------
- {0,REG_UNONPOSIX,REG_ULOCALE}
- {a}
-(2 rows)
-
-select * from test_regex('[[:<:]]a', 'a', 'LPb');
- test_regex
--------------------------------
- {0,REG_UNONPOSIX,REG_ULOCALE}
- {a}
-(2 rows)
-
... |
| 51/5246 |
Allow SQL functions use CachedPlan machinery |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:12.942262000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2024-11-23 04:58:47.435372000 +000...
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:12.942262000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/xml.out 2024-11-23 04:59:36.829717000 +0...
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:12.942262000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/xml.out 2024-11-23 04:58:44.678898000 +0000
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:11.221321176 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/xml.out 2024-11-23 05:02:03.374309155 +0000
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/src/test/regress/results/xml.out
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:11.221321176 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/xml.out 2024-11-23 05:00:16.054504202 +0000
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:13.128322101 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2024-11-23 04:59:26.955524411 +000...
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:13.128322101 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/xml.out 2024-11-23 05:00:03.688970930 +0...
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/xml.out /tmp/cirrus-ci-build/build/testrun/regress/regress/resul...
--- /tmp/cirrus-ci-build/src/test/regress/expected/xml.out 2024-11-23 04:57:13.128322101 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/xml.out 2024-11-23 04:59:20.571381816 +0000
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/xml.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade...
--- /Users/admin/pgsql/src/test/regress/expected/xml.out 2024-11-23 04:57:09
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/xml.out 2024-11-23 04:58:54
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/xml.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regre...
--- /Users/admin/pgsql/src/test/regress/expected/xml.out 2024-11-23 04:57:09
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/xml.out 2024-11-23 04:59:50
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/xml.out /Users/admin/pgsql/build/testrun/regress/regress/results/x...
--- /Users/admin/pgsql/src/test/regress/expected/xml.out 2024-11-23 04:57:09
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/xml.out 2024-11-23 04:58:54
@@ -855,7 +855,7 @@
SELECT xpath('', '<!-- error -->');
ERROR: empty XPath expression
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
SELECT xpath('//text()', '<local:data xmlns:local="http://127.0.0.1"><local:piece id="1">number one</local:piece><local...
xpath
----------------
@@ -1221,7 +1221,7 @@
DETAIL: line 1: Namespace prefix nosuchprefix on tag is not defined
<nosuchprefix:tag/>
^
-CONTEXT: SQL function "xpath" statement 1
+CONTEXT: SQL function "xpath" during startup
-- XPath deprecates relative namespaces, but they're not supposed to
-- throw an error, only a warning.
... |
| 51/4874 |
BitmapHeapScan table AM violation removal (and use streaming read API) |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress-running/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-10-24 15:29:17.228211000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/triggers.out 2024-10-24 15:34:41.423741000 +0000
@@ -2505,19 +2505,23 @@
insert into parted values (1, 1, 'uno uno v6');
create table parted_3 partition of parted for values in (3);
update parted set a = a + 1;
+ERROR: error triggered for injection point typecache-before-rel-type-cache-insert
+CONTEXT: PL/pgSQL function parted_trigfunc() during initialization of execution state
select tableoid::regclass, * from parted;
- tableoid | a | b | c
-----------+---+---+---------------------------------------------
- parted_3 | 3 | 1 | uno uno v6 did INSERT did UPDATE did INSERT
+ tableoid | a | b | c
+------------+---+---+-----------------------
+ parted_1_1 | 1 | 1 | uno uno v6 did INSERT
(1 row)
-- there's no partition for a=0, but this update works anyway because
-- the trigger causes the tuple to be routed to another partition
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/modules/test_tidstore/expected/test_tidstore.out /tmp/cirrus-ci-build/build/testr...
--- /tmp/cirrus-ci-build/src/test/modules/test_tidstore/expected/test_tidstore.out 2024-10-24 15:29:17.107930000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/test_tidstore-running/regress/results/test_tidstore.out 2024-10-24 15:34:40.31857...
@@ -32,20 +32,17 @@
(VALUES (0), (1), (:maxblkno / 2), (:maxblkno - 1), (:maxblkno)) AS blocks(blk),
(VALUES (1), (2), (:maxoffset / 2), (:maxoffset - 1), (:maxoffset)) AS offsets(off)
GROUP BY blk;
+ERROR: error triggered for injection point typecache-before-rel-type-cache-insert
+LINE 6: GROUP BY blk;
+ ^
-- Test offsets embedded in the bitmap header.
SELECT do_set_block_offsets(501, array[greatest((random() * :maxoffset)::int, 1)]::int2[]);
- do_set_block_offsets
-----------------------
- 501
-(1 row)
-
+ERROR: error triggered for injection point typecache-before-rel-type-cache-insert
SELECT do_set_block_offsets(502, array_agg(DISTINCT greatest((random() * :maxoffset)::int, 1))::int2[])
FROM generate_series(1, 3);
... |
| 50/5317 |
type cache cleanup improvements |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress-running/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-10-22 18:23:14.676052000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress-running/regress/results/triggers.out 2024-10-22 18:28:03.168650000 +0000
@@ -2145,14 +2145,9 @@
create table trigpart3 (like trigpart);
create trigger trg1 after insert on trigpart3 for each row execute procedure trigger_nothing();
\d trigpart3
- Table "public.trigpart3"
- Column | Type | Collation | Nullable | Default
---------+---------+-----------+----------+---------
- a | integer | | |
- b | integer | | |
-Triggers:
- trg1 AFTER INSERT ON trigpart3 FOR EACH ROW EXECUTE FUNCTION trigger_nothing()
-
+ERROR: error triggered for injection point typecache-before-rel-type-cache-insert
+LINE 2: ....pg_roles where oid = any (pol.polroles) order by 1),',') EN...
+ ^
alter table trigpart attach partition trigpart3 FOR VALUES FROM (2000) to (3000); -- fail
ERROR: trigger "trg1" for relation "trigpart3" already exists
... |
| 49/4617 |
Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:49.564336000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-09-30 20:44:15.383031000...
@@ -2574,1184 +2574,7 @@
drop table parted;
drop function parted_trigfunc();
---
--- Constraint triggers and partitioned tables
-create table parted_constr_ancestor (a int, b text)
- partition by range (b);
-create table parted_constr (a int, b text)
- partition by range (b);
-alter table parted_constr_ancestor attach partition parted_constr
- for values from ('aaaa') to ('zzzz');
-create table parted1_constr (a int, b text);
-alter table parted_constr attach partition parted1_constr
- for values from ('aaaa') to ('bbbb');
-create constraint trigger parted_trig after insert on parted_constr_ancestor
- deferrable
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:49.564336000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-09-30 20:44:37.4183580...
@@ -2625,1133 +2625,10 @@
NOTICE: trigger parted_trig_two on parted1_constr AFTER INSERT for ROW: (a,b)=(3,aasvogel)
drop table parted_constr_ancestor;
drop function bark(text);
--- Test that the WHEN clause is set properly to partitions
-create table parted_trigger (a int, b text) partition by range (a);
-create table parted_trigger_1 partition of parted_trigger for values from (0) to (1000);
-create table parted_trigger_2 (drp int, a int, b text);
-alter table parted_trigger_2 drop column drp;
-alter table parted_trigger attach partition parted_trigger_2 for values from (1000) to (2000);
-create trigger parted_trigger after update on parted_trigger
- for each row when (new.a % 2 = 1 and length(old.b) >= 2) execute procedure trigger_notice_ab();
-create table parted_trigger_3 (b text, a int) partition by range (length(b));
-create table parted_trigger_3_1 partition of parted_trigger_3 for values from (1) to (3);
-create table parted_trigger_3_2 partition of parted_trigger_3 for values from (3) to (5);
-alter table parted_trigger attach partition parted_trigger_3 for values from (2000) to (3000);
-insert into parted_trigger values
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:49.564336000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-09-30 20:44:12.046090000 +0000
@@ -2607,1151 +2607,7 @@
NOTICE: trigger parted_trig on parted1_constr AFTER INSERT for ROW: (a,b)=(3,aasvogel)
commit;
NOTICE: trigger parted_trig_two on parted1_constr AFTER INSERT for ROW: (a,b)=(1,aardvark)
-NOTICE: trigger parted_trig_two on parted1_constr AFTER INSERT for ROW: (a,b)=(3,aasvogel)
--- The WHEN clause is immediate, and both constraint triggers are fired at
--- commit time.
-begin;
-set constraints parted_trig deferred;
-insert into parted_constr values (1, 'aardvark');
-NOTICE: aardvark <- woof!
-insert into parted1_constr values (2, 'aardwolf'), (3, 'aasvogel');
-NOTICE: aardwolf <- woof!
-NOTICE: aasvogel <- woof!
-commit;
-NOTICE: trigger parted_trig on parted1_constr AFTER INSERT for ROW: (a,b)=(1,aardvark)
-NOTICE: trigger parted_trig_two on parted1_constr AFTER INSERT for ROW: (a,b)=(1,aardvark)
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:47.105343454 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/triggers.out 2024-09-30 20:46:58.537011418 +0000
@@ -2691,1067 +2691,10 @@
for each row execute procedure trigger_notice_ab();
create table parted_trigger_3 (b text, a int) partition by range (length(b));
create table parted_trigger_3_1 partition of parted_trigger_3 for values from (1) to (4);
-create table parted_trigger_3_2 partition of parted_trigger_3 for values from (4) to (8);
-alter table parted_trigger attach partition parted_trigger_3 for values from (2000) to (3000);
-insert into parted_trigger values (0, 'a'), (1000, 'c'), (2000, 'e'), (2001, 'eeee');
-update parted_trigger set a = a + 2; -- no notices here
-update parted_trigger set b = b || 'b'; -- all triggers should fire
-NOTICE: trigger parted_trigger on parted_trigger_1 AFTER UPDATE for ROW: (a,b)=(2,ab)
-NOTICE: trigger parted_trigger on parted_trigger_2 AFTER UPDATE for ROW: (a,b)=(1002,cb)
-NOTICE: trigger parted_trigger on parted_trigger_3_1 AFTER UPDATE for ROW: (a,b)=(2002,eb)
-NOTICE: trigger parted_trigger on parted_trigger_3_2 AFTER UPDATE for ROW: (a,b)=(2003,eeeeb)
-drop table parted_trigger;
-drop function trigger_notice_ab();
--- Make sure we don't end up with unnecessary copies of triggers, when
--- cloning them.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/src/test/regress/results/trigg...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:47.105343454 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/triggers.out 2024-09-30 20:45:40.717093299 +0000
@@ -3153,605 +3153,10 @@
for each statement execute procedure dump_delete();
-- insert directly into children sees respective child-format tuples
insert into child1 values ('AAA', 42);
-NOTICE: trigger = child1_insert_trig, new table = (AAA,42)
-insert into child2 values (42, 'BBB');
-NOTICE: trigger = child2_insert_trig, new table = (42,BBB)
-insert into child3 values ('CCC', 42, 'foo');
-NOTICE: trigger = child3_insert_trig, new table = (CCC,42,foo)
--- update via parent sees parent-format tuples
-update parent set b = b + 1;
-NOTICE: trigger = parent_update_trig, old table = (AAA,42), (BBB,42), (CCC,42), new table = (AAA,43), (BBB,43), (CCC,4...
--- delete via parent sees parent-format tuples
-delete from parent;
-NOTICE: trigger = parent_delete_trig, old table = (AAA,43), (BBB,43), (CCC,43)
--- reinsert values into children for next test...
-insert into child1 values ('AAA', 42);
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_p...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:45.946820836 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-09-30 20:46:06.737761322...
@@ -2560,1198 +2560,7 @@
create trigger t before insert or update on parted
for each row execute function parted_trigfunc();
insert into parted values (0, 1, 'zero win');
-insert into parted values (1, 1, 'one fail');
-ERROR: moving row to another partition during a BEFORE FOR EACH ROW trigger is not supported
-DETAIL: Before executing trigger "t", the row was to be in partition "public.parted_1".
-insert into parted values (1, 2, 'two fail');
-ERROR: moving row to another partition during a BEFORE FOR EACH ROW trigger is not supported
-DETAIL: Before executing trigger "t", the row was to be in partition "public.parted_2".
-select * from parted;
- a | b | c
----+---+----------
- 1 | 1 | zero win
-(1 row)
-
-drop table parted;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/recovery/027_str...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:45.946820836 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-09-30 20:46:35.1897302...
@@ -1643,2115 +1643,10 @@
$$;
create trigger depth_b_tr before insert on depth_b
for each row execute procedure depth_b_tf();
-create function depth_c_tf() returns trigger
- language plpgsql as $$
-begin
- raise notice '%: depth = %', tg_name, pg_trigger_depth();
- if new.id = 1 then
- raise exception sqlstate 'U9999';
- end if;
- raise notice '%: depth = %', tg_name, pg_trigger_depth();
- return new;
-end;
-$$;
-create trigger depth_c_tr before insert on depth_c
- for each row execute procedure depth_c_tf();
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out /tmp/cirrus-ci-build/build/testrun/regress/regress/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/triggers.out 2024-09-30 20:42:45.946820836 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/triggers.out 2024-09-30 20:46:02.877766172 +0000
@@ -2625,1133 +2625,10 @@
NOTICE: trigger parted_trig_two on parted1_constr AFTER INSERT for ROW: (a,b)=(3,aasvogel)
drop table parted_constr_ancestor;
drop function bark(text);
--- Test that the WHEN clause is set properly to partitions
-create table parted_trigger (a int, b text) partition by range (a);
-create table parted_trigger_1 partition of parted_trigger for values from (0) to (1000);
-create table parted_trigger_2 (drp int, a int, b text);
-alter table parted_trigger_2 drop column drp;
-alter table parted_trigger attach partition parted_trigger_2 for values from (1000) to (2000);
-create trigger parted_trigger after update on parted_trigger
- for each row when (new.a % 2 = 1 and length(old.b) >= 2) execute procedure trigger_notice_ab();
-create table parted_trigger_3 (b text, a int) partition by range (length(b));
-create table parted_trigger_3_1 partition of parted_trigger_3 for values from (1) to (3);
-create table parted_trigger_3_2 partition of parted_trigger_3 for values from (3) to (5);
-alter table parted_trigger attach partition parted_trigger_3 for values from (2000) to (3000);
-insert into parted_trigger values
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_up...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-09-30 20:42:45
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/triggers.out 2024-09-30 20:45:56
@@ -999,2759 +999,10 @@
f2 int,
f3 int);
INSERT INTO min_updates_test VALUES ('a',1,2),('b','2',null);
-CREATE TRIGGER z_min_update
-BEFORE UPDATE ON min_updates_test
-FOR EACH ROW EXECUTE PROCEDURE suppress_redundant_updates_trigger();
-\set QUIET false
-UPDATE min_updates_test SET f1 = f1;
-UPDATE 0
-UPDATE min_updates_test SET f2 = f2 + 1;
-UPDATE 2
-UPDATE min_updates_test SET f3 = 2 WHERE f3 is null;
-UPDATE 1
-\set QUIET true
-SELECT * FROM min_updates_test;
- f1 | f2 | f3
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/triggers.out /Users/admin/pgsql/build/testrun/recovery/027_stream_...
--- /Users/admin/pgsql/src/test/regress/expected/triggers.out 2024-09-30 20:42:45
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-09-30 20:47:22
@@ -1618,2140 +1618,14 @@
begin
raise notice '%: depth = %', tg_name, pg_trigger_depth();
insert into depth_b values (new.id);
- raise notice '%: depth = %', tg_name, pg_trigger_depth();
- return new;
-end;
-$$;
-create trigger depth_a_tr before insert on depth_a
- for each row execute procedure depth_a_tf();
-create function depth_b_tf() returns trigger
- language plpgsql as $$
-begin
- raise notice '%: depth = %', tg_name, pg_trigger_depth();
- begin
- execute 'insert into depth_c values (' || new.id::text || ')';
- exception
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/updatable_views.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/updatable_views.out 2024-09-30 20:42:45
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/updatable_views.out 2024-09-30 20:45:56
@@ -1157,2853 +1157,10 @@
MERGE INTO rw_view2 t
USING (SELECT x, 'R'||x FROM generate_series(0,3) x) AS s(a,b) ON t.a = s.a
WHEN MATCHED AND t.a <= 1 THEN DELETE
- WHEN MATCHED THEN UPDATE SET b = s.b
- WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
- RETURNING merge_action(), s.*, t.*;
- merge_action | a | b | a | b
---------------+---+----+---+-------
- DELETE | 1 | R1 | 1 | Row 1
- UPDATE | 2 | R2 | 2 | R2
- INSERT | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a | b
-----+--------
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/updatable_views.out 2024-09-30 20:42:54.923191100 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/updatable_views.out 2024-09-30 20:45:22.136883700 +00...
@@ -1160,2850 +1160,7 @@
WHEN MATCHED THEN UPDATE SET b = s.b
WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
RETURNING merge_action(), s.*, t.*;
- merge_action | a | b | a | b
---------------+---+----+---+-------
- DELETE | 1 | R1 | 1 | Row 1
- UPDATE | 2 | R2 | 2 | R2
- INSERT | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a | b
-----+--------
- -2 | Row -2
- -1 | Row -1
- 0 | Row 0
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/triggers.out C:/cirrus/build/testrun/recovery/027_strea...
--- C:/cirrus/src/test/regress/expected/triggers.out 2024-09-30 20:42:54.909600700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/triggers.out 2024-09-30 20:47:23.093525700 +0000
@@ -3738,20 +3738,10 @@
drop table grandparent;
-- Trigger renaming does not recurse on legacy inheritance
create table parent (a int);
-create table child () inherits (parent);
-create trigger parenttrig after insert on parent
-for each row execute procedure f();
-create trigger parenttrig after insert on child
-for each row execute procedure f();
-alter trigger parenttrig on parent rename to anothertrig;
-\d+ child
- Table "public.child"
- Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
---------+---------+-----------+----------+---------+---------+--------------+-------------
- a | integer | | | | plain | |
-Triggers:
- parenttrig AFTER INSERT ON child FOR EACH ROW EXECUTE FUNCTION f()
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/updatable_views.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/updatable_views.out 2024-09-30 20:42:54.923191100 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/updatable_views.out 2024-09-30 20:45:20.543140600 +0000
@@ -1160,2850 +1160,7 @@
WHEN MATCHED THEN UPDATE SET b = s.b
WHEN NOT MATCHED AND s.a > 0 THEN INSERT VALUES (s.a, s.b)
RETURNING merge_action(), s.*, t.*;
- merge_action | a | b | a | b
---------------+---+----+---+-------
- DELETE | 1 | R1 | 1 | Row 1
- UPDATE | 2 | R2 | 2 | R2
- INSERT | 3 | R3 | 3 | R3
-(3 rows)
-
-SELECT * FROM base_tbl ORDER BY a;
- a | b
-----+--------
- -2 | Row -2
- -1 | Row -1
- 0 | Row 0
... |
| 49/3246 |
Parallelize correlated subqueries that execute within each worker |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:17.812776000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-09-29 21:30:00.36...
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:17.812776000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-09-29 21:30:43....
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:17.812776000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2024-09-29 21:29:57.714959000 +0000
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:16.554677753 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/select_parallel.out 2024-09-29 21:34:02.757341506 +0000
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/recovery/tmp_c...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:16.554677753 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/select_parallel.out 2024-09-29 21:35:40.985511862 +0000
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/src/test/regress/result...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:16.554677753 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/select_parallel.out 2024-09-29 21:31:46.273488891 +0000
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/pg_upgrad...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:16.095001483 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-09-29 21:31:31.75...
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/recovery/...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:16.095001483 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-09-29 21:32:12....
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out /tmp/cirrus-ci-build/build/testrun/regress/r...
--- /tmp/cirrus-ci-build/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:16.095001483 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/select_parallel.out 2024-09-29 21:31:29.104345850 +0000
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/pg_upgrade/00...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:21
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-09-29 21:30:26
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/recovery/027_...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:21
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-09-29 21:31:31
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/select_parallel.out /Users/admin/pgsql/build/testrun/regress/regre...
--- /Users/admin/pgsql/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:21
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/select_parallel.out 2024-09-29 21:30:26
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/pg_upgrade/...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:28.524331700 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/select_parallel.out 2024-09-29 21:31:37.171944500 +00...
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/recovery/02...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:28.524331700 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/select_parallel.out 2024-09-29 21:33:58.633858300 +...
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/select_parallel.out C:/cirrus/build/testrun/regress/reg...
--- C:/cirrus/src/test/regress/expected/select_parallel.out 2024-09-29 21:28:28.524331700 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/select_parallel.out 2024-09-29 21:31:35.323798800 +0000
@@ -451,26 +451,36 @@
join tenk1 t3 on t3.stringu1 = tenk1.stringu1
where tenk1.four = t.four
);
- ...
------------------------------------------------------------------------------------------------------------------------...
- Seq Scan on public.tenk1 t
+ ...
+-----------------------------------------------------------------------------------------------------------------------...
+ Hash Join
Output: t.unique1, t.unique2, t.two, t.four, t.ten, t.twenty, t.hundred, t.thousand, t.twothousand, t.fivethous, t.t...
- Filter: (SubPlan 1)
- SubPlan 1
- -> Hash Join
- Output: t.two
- Hash Cond: (tenk1.stringu1 = t3.stringu1)
- -> Seq Scan on public.tenk1
... |
| 49/4946 |
Partitioned tables and [un]loggedness |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:19.292256000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-09-23 08:35:59.079318...
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:19.292256000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-09-23 08:36:45.9655...
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:19.292256000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-09-23 08:35:54.515008000 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:17.849944613 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/alter_table.out 2024-09-23 08:40:06.409651473 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:17.849944613 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/alter_table.out 2024-09-23 08:41:24.566490457 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/src/test/regress/results/al...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:17.849944613 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/alter_table.out 2024-09-23 08:37:37.826103940 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:15.207581083 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-09-23 08:36:54.592717...
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:15.207581083 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-09-23 08:37:26.8210...
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/alter_table.out 2024-09-23 08:34:15.207581083 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/alter_table.out 2024-09-23 08:36:49.180671412 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-09-23 08:34:18
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-09-23 08:36:18
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-09-23 08:34:18
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-09-23 08:37:25
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-09-23 08:34:18
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/alter_table.out 2024-09-23 08:36:18
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-09-23 08:34:34.262682400 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/alter_table.out 2024-09-23 08:38:19.092584300 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-09-23 08:34:34.262682400 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-09-23 08:40:36.114558500 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/alter_table.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/alter_table.out 2024-09-23 08:34:34.262682400 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/alter_table.out 2024-09-23 08:38:11.541798300 +0000
@@ -3911,7 +3911,8 @@
);
CREATE TABLE fail_part (like unparted);
ALTER TABLE unparted ATTACH PARTITION fail_part FOR VALUES IN ('a');
-ERROR: table "unparted" is not partitioned
+ERROR: ALTER action ATTACH PARTITION cannot be performed on relation "unparted"
+DETAIL: This operation is not supported for tables.
DROP TABLE unparted, fail_part;
-- check that partition bound is compatible
CREATE TABLE list_parted (
@@ -4281,7 +4282,8 @@
-- check that the table is partitioned at all
CREATE TABLE regular_table (a int);
ALTER TABLE regular_table DETACH PARTITION any_name;
-ERROR: table "regular_table" is not partitioned
+ERROR: ALTER action DETACH PARTITION cannot be performed on relation "regular_table"
+DETAIL: This operation is not supported for tables.
... |
| 51/4871 |
KNN-btree |
|
FreeBSD - 13 - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/init.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/init.out 2024-08-11 11:48:03.214239000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/init.out 2024-08-11 11:51:07.842611000 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION btree_gist;
+ERROR: extension "btree_gist" has no installation script nor update path for version "1.8"
-- Check whether any of our opclasses fail amvalidate
SELECT amname, opcname
FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/int2.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/int2.out 2024-08-11 11:48:03.214311000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/int2.out 2024-08-11 11:51:07.896977000 +0000
@@ -41,6 +41,8 @@
(3 rows)
CREATE INDEX int2idx ON int2tmp USING gist ( a );
+ERROR: data type smallint has no default operator class for access method "gist"
+HINT: You must specify an operator class for the index or define a default operator class for the data type.
SET enable_seqscan=off;
SELECT count(*) FROM int2tmp WHERE a < 237::int2;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:04.725006000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/btree_index.out 2024-08-11 11:50:13.130212...
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:04.725006000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/btree_index.out 2024-08-11 11:50:53.9471...
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:04.725006000 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/btree_index.out 2024-08-11 11:50:10.898413000 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
|
Linux - Debian Bookworm - Autoconf |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_chec...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:02.776379012 +0000
+++ /tmp/cirrus-ci-build/src/bin/pg_upgrade/tmp_check/results/btree_index.out 2024-08-11 11:55:04.814746193 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/test/recovery/tmp_check...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:02.776379012 +0000
+++ /tmp/cirrus-ci-build/src/test/recovery/tmp_check/results/btree_index.out 2024-08-11 11:56:59.282665717 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/src/test/regress/results/bt...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:02.776379012 +0000
+++ /tmp/cirrus-ci-build/src/test/regress/results/btree_index.out 2024-08-11 11:52:42.302301902 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
|
Linux - Debian Bookworm - Meson |
| regress |
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/init.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/init.out 2024-08-11 11:48:01.711619909 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/init.out 2024-08-11 11:53:53.018533047 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION btree_gist;
+ERROR: extension "btree_gist" has no installation script nor update path for version "1.8"
-- Check whether any of our opclasses fail amvalidate
SELECT amname, opcname
FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
diff -U3 /tmp/cirrus-ci-build/contrib/btree_gist/expected/int2.out /tmp/cirrus-ci-build/build/testrun/btree_gist/regress...
--- /tmp/cirrus-ci-build/contrib/btree_gist/expected/int2.out 2024-08-11 11:48:01.711619909 +0000
+++ /tmp/cirrus-ci-build/build/testrun/btree_gist/regress/results/int2.out 2024-08-11 11:53:53.290534582 +0000
@@ -41,6 +41,8 @@
(3 rows)
CREATE INDEX int2idx ON int2tmp USING gist ( a );
+ERROR: data type smallint has no default operator class for access method "gist"
+HINT: You must specify an operator class for the index or define a default operator class for the data type.
SET enable_seqscan=off;
SELECT count(*) FROM int2tmp WHERE a < 237::int2;
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/pg_upgrade/00...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:03.553128068 +0000
+++ /tmp/cirrus-ci-build/build/testrun/pg_upgrade/002_pg_upgrade/data/results/btree_index.out 2024-08-11 11:52:56.434315...
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/recovery/027_...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:03.553128068 +0000
+++ /tmp/cirrus-ci-build/build/testrun/recovery/027_stream_regress/data/results/btree_index.out 2024-08-11 11:53:42.0064...
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff -U3 /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out /tmp/cirrus-ci-build/build/testrun/regress/regre...
--- /tmp/cirrus-ci-build/src/test/regress/expected/btree_index.out 2024-08-11 11:48:03.553128068 +0000
+++ /tmp/cirrus-ci-build/build/testrun/regress/regress/results/btree_index.out 2024-08-11 11:52:51.278309928 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
|
macOS - Sonoma - Meson |
| regress |
diff -U3 /Users/admin/pgsql/contrib/btree_gist/expected/init.out /Users/admin/pgsql/build/testrun/btree_gist/regress/res...
--- /Users/admin/pgsql/contrib/btree_gist/expected/init.out 2024-08-11 11:48:10
+++ /Users/admin/pgsql/build/testrun/btree_gist/regress/results/init.out 2024-08-11 11:51:50
@@ -1,4 +1,5 @@
CREATE EXTENSION btree_gist;
+ERROR: extension "btree_gist" has no installation script nor update path for version "1.8"
-- Check whether any of our opclasses fail amvalidate
SELECT amname, opcname
FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
diff -U3 /Users/admin/pgsql/contrib/btree_gist/expected/int2.out /Users/admin/pgsql/build/testrun/btree_gist/regress/res...
--- /Users/admin/pgsql/contrib/btree_gist/expected/int2.out 2024-08-11 11:48:10
+++ /Users/admin/pgsql/build/testrun/btree_gist/regress/results/int2.out 2024-08-11 11:51:50
@@ -41,6 +41,8 @@
(3 rows)
CREATE INDEX int2idx ON int2tmp USING gist ( a );
+ERROR: data type smallint has no default operator class for access method "gist"
+HINT: You must specify an operator class for the index or define a default operator class for the data type.
SET enable_seqscan=off;
SELECT count(*) FROM int2tmp WHERE a < 237::int2;
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/btree_index.out /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg...
--- /Users/admin/pgsql/src/test/regress/expected/btree_index.out 2024-08-11 11:48:13
+++ /Users/admin/pgsql/build/testrun/pg_upgrade/002_pg_upgrade/data/results/btree_index.out 2024-08-11 11:50:35
@@ -626,506 +626,60471 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
- 4408 | 4488889
- 6320 | 5257716
- 1836 | 5593978
-(10 rows)
-
-DROP INDEX bt_i4_heap_random_idx;
-CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
-SELECT * FROM bt_i4_heap
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/btree_index.out /Users/admin/pgsql/build/testrun/recovery/027_stre...
--- /Users/admin/pgsql/src/test/regress/expected/btree_index.out 2024-08-11 11:48:13
+++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/btree_index.out 2024-08-11 11:51:36
@@ -626,506 +626,60471 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
- 4408 | 4488889
- 6320 | 5257716
- 1836 | 5593978
-(10 rows)
-
-DROP INDEX bt_i4_heap_random_idx;
-CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
-SELECT * FROM bt_i4_heap
... |
| regress |
diff -U3 /Users/admin/pgsql/src/test/regress/expected/btree_index.out /Users/admin/pgsql/build/testrun/regress/regress/r...
--- /Users/admin/pgsql/src/test/regress/expected/btree_index.out 2024-08-11 11:48:13
+++ /Users/admin/pgsql/build/testrun/regress/regress/results/btree_index.out 2024-08-11 11:50:31
@@ -626,506 +626,60471 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
- 4408 | 4488889
- 6320 | 5257716
- 1836 | 5593978
-(10 rows)
-
-DROP INDEX bt_i4_heap_random_idx;
-CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
-SELECT * FROM bt_i4_heap
... |
|
Windows - Server 2019, VS 2019 - Meson & ninja |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/contrib/btree_gist/expected/init.out C:/cirrus/build/testrun/btree_gist/regress/r...
--- C:/cirrus/contrib/btree_gist/expected/init.out 2024-08-11 11:48:14.954991600 +0000
+++ C:/cirrus/build/testrun/btree_gist/regress/results/init.out 2024-08-11 11:53:51.006001800 +0000
@@ -1,4 +1,5 @@
CREATE EXTENSION btree_gist;
+ERROR: extension "btree_gist" has no installation script nor update path for version "1.8"
-- Check whether any of our opclasses fail amvalidate
SELECT amname, opcname
FROM pg_opclass opc LEFT JOIN pg_am am ON am.oid = opcmethod
diff --strip-trailing-cr -U3 C:/cirrus/contrib/btree_gist/expected/int2.out C:/cirrus/build/testrun/btree_gist/regress/r...
--- C:/cirrus/contrib/btree_gist/expected/int2.out 2024-08-11 11:48:14.955970900 +0000
+++ C:/cirrus/build/testrun/btree_gist/regress/results/int2.out 2024-08-11 11:53:51.522598900 +0000
@@ -41,6 +41,8 @@
(3 rows)
CREATE INDEX int2idx ON int2tmp USING gist ( a );
+ERROR: data type smallint has no default operator class for access method "gist"
+HINT: You must specify an operator class for the index or define a default operator class for the data type.
SET enable_seqscan=off;
SELECT count(*) FROM int2tmp WHERE a < 237::int2;
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/btree_index.out C:/cirrus/build/testrun/pg_upgrade/002_...
--- C:/cirrus/src/test/regress/expected/btree_index.out 2024-08-11 11:48:19.584309800 +0000
+++ C:/cirrus/build/testrun/pg_upgrade/002_pg_upgrade/data/results/btree_index.out 2024-08-11 11:51:01.016340500 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/btree_index.out C:/cirrus/build/testrun/recovery/027_st...
--- C:/cirrus/src/test/regress/expected/btree_index.out 2024-08-11 11:48:19.584309800 +0000
+++ C:/cirrus/build/testrun/recovery/027_stream_regress/data/results/btree_index.out 2024-08-11 11:53:05.500604000 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |
| regress |
diff --strip-trailing-cr -U3 C:/cirrus/src/test/regress/expected/btree_index.out C:/cirrus/build/testrun/regress/regress...
--- C:/cirrus/src/test/regress/expected/btree_index.out 2024-08-11 11:48:19.584309800 +0000
+++ C:/cirrus/build/testrun/regress/regress/results/btree_index.out 2024-08-11 11:50:50.841791200 +0000
@@ -626,15 +626,10 @@
-------+---------
5380 | 3000193
6262 | 3013326
- 2126 | 2648497
- 2681 | 2321799
- 2893 | 1919087
- 6448 | 4157193
- 210 | 1809552
4408 | 4488889
6320 | 5257716
1836 | 5593978
-(10 rows)
+(5 rows)
DROP INDEX bt_i4_heap_random_idx;
CREATE INDEX bt_i4_heap_random_idx ON bt_i4_heap USING btree(random DESC, seqno);
... |