diff -U3 /Users/admin/pgsql/src/test/regress/expected/join_hash.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join_hash.out --- /Users/admin/pgsql/src/test/regress/expected/join_hash.out 2024-04-08 08:32:34 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/join_hash.out 2024-04-08 08:36:56 @@ -1138,18 +1138,21 @@ int8_tbl i8, lateral (select t1.fivethous, i4.f1 from tenk1 t1 join int4_tbl i4 on t1.fivethous = i4.f1+i8.q2 order by 1,2) ss; - QUERY PLAN ------------------------------------------------------------ + QUERY PLAN +----------------------------------------------------------------- Nested Loop -> Seq Scan on int8_tbl i8 - -> Sort - Sort Key: t1.fivethous, i4.f1 - -> Hash Join - Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) - -> Seq Scan on tenk1 t1 - -> Hash - -> Seq Scan on int4_tbl i4 -(9 rows) + -> Memoize + Cache Key: i8.q2 + Cache Mode: binary + -> Sort + Sort Key: t1.fivethous, i4.f1 + -> Hash Join + Hash Cond: (t1.fivethous = (i4.f1 + i8.q2)) + -> Seq Scan on tenk1 t1 + -> Hash + -> Seq Scan on int4_tbl i4 +(12 rows) select i8.q2, ss.* from int8_tbl i8, diff -U3 /Users/admin/pgsql/src/test/regress/expected/alter_table.out /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/alter_table.out --- /Users/admin/pgsql/src/test/regress/expected/alter_table.out 2024-04-08 08:32:34 +++ /Users/admin/pgsql/build/testrun/recovery/027_stream_regress/data/results/alter_table.out 2024-04-08 08:39:03 @@ -3476,9 +3476,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 +-------+------------+---------------+-------------+---------------------- + 37467 | | 0 | 37467 | pktable_pkey + 37464 | | 0 | 37464 | pktable + 37469 | | 0 | 37469 | fktable + 38201 | | 0 | 38208 | foo + 38212 | | 0 | 38212 | pg_toast_38201_index + 38211 | | 0 | 38211 | pg_toast_38201 + 38442 | | 0 | 38442 | pg_toast_38439 + 38443 | | 0 | 38443 | pg_toast_38439_index + 38439 | | 0 | 38439 | recur2 + 38422 | | 0 | 38422 | old_oids + 38434 | | 0 | 38434 | recur1 +(11 rows) -- Checks on creating and manipulation of user defined relations in -- pg_catalog.