diff -U3 /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out --- /tmp/cirrus-ci-build/contrib/postgres_fdw/expected/postgres_fdw.out 2024-09-18 12:07:12.496128519 +0000 +++ /tmp/cirrus-ci-build/contrib/postgres_fdw/results/postgres_fdw.out 2024-09-18 12:11:29.852892644 +0000 @@ -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