]> granicus.if.org Git - postgresql/commit
postgres_fdw: Fix test that didn't test what it claimed.
authorRobert Haas <rhaas@postgresql.org>
Fri, 1 Dec 2017 18:47:00 +0000 (13:47 -0500)
committerRobert Haas <rhaas@postgresql.org>
Fri, 1 Dec 2017 18:49:11 +0000 (13:49 -0500)
commit950222780535e6d2ea560cd8b3db5308652ddd42
treefd161d778af38928df57b3cc6bc6aac114e095ca
parent87c37e3291cb75273ccdf4645b9472dd805c4493
postgres_fdw: Fix test that didn't test what it claimed.

Antonin Houska reported that the planner does consider pushing
postgres_fdw_abs() to the remote side, which happens because we make
it shippable earlier in the test case file.

Jeevan Chalke provided this patch, which changes the join
condition to use random(), which is not shippable, instead.
Antonin reviewed the patch.

Discussion: http://postgr.es/m/15265.1511985971@localhost
contrib/postgres_fdw/expected/postgres_fdw.out
contrib/postgres_fdw/sql/postgres_fdw.sql