diff -U3 /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out /Users/admin/pgsql/build/testrun/postgres_fdw/regress/results/postgres_fdw.out --- /Users/admin/pgsql/contrib/postgres_fdw/expected/postgres_fdw.out 2024-08-28 10:38:55 +++ /Users/admin/pgsql/build/testrun/postgres_fdw/regress/results/postgres_fdw.out 2024-08-28 10:43:57 @@ -10155,7 +10155,9 @@ -> Foreign Scan Relations: (ftprt1_p1 t1_1) INNER JOIN (ftprt2_p1 t2_1) -> Result + Disabled Nodes: 1 -> Sort + Disabled Nodes: 1 Sort Key: t2_1.a -> Nested Loop -> Foreign Scan on ftprt1_p1 t1_1 @@ -10163,12 +10165,14 @@ -> Foreign Scan Relations: (ftprt1_p2 t1_2) INNER JOIN (ftprt2_p2 t2_2) -> Result + Disabled Nodes: 1 -> Sort + Disabled Nodes: 1 Sort Key: t2_2.a -> Nested Loop -> Foreign Scan on ftprt1_p2 t1_2 -> Foreign Scan on ftprt2_p2 t2_2 -(19 rows) +(23 rows) SELECT t1.a, t2.b FROM fprt1 t1 INNER JOIN fprt2 t2 ON (t1.a = t2.b) WHERE t1.a % 25 = 0 ORDER BY t2.a FOR UPDATE OF t1; a | b