mark> When using a foreign data wrapper from our 9.6.2 database to a mark> MySQL 5.7 database, we get inconsistent results. We're joining mark> two tables from another server:
mysql_fdw is (and has _always_ been) broken for anything beyond the most trivial queries:
Since mysql_fdw is not part of postgresql you should take this up with the maintainers. However, the linked issue has been outstanding for 18 months, so probably best not hold your breath. -- Andrew (irc:RhodiumToad)