Re: [BUGS] BUG #14709: inconsistent answers with foreign datawrappers to mysql - Mailing list pgsql-bugs

From Rushabh Lathia
Subject Re: [BUGS] BUG #14709: inconsistent answers with foreign datawrappers to mysql
Date
Msg-id CAGPqQf1SxdFW8yTG8yVPnbC9_E4BC-fsRU=0wuxQEPd4XPZ6Sg@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] BUG #14709: inconsistent answers with foreign data wrappers to mysql  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: [BUGS] BUG #14709: inconsistent answers with foreign datawrappers to mysql  (Mark Manley <mark.manley@tapad.com>)
List pgsql-bugs
Hi,

I informed the maintainer of mysql_fdw and they will start looking into this issue.

Thanks,


On Mon, Jun 19, 2017 at 4:13 AM, Andrew Gierth <andrew@tao11.riddles.org.uk> wrote:
>>>>> "mark" == mark manley <mark.manley@tapad.com> writes:

 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:

https://github.com/EnterpriseDB/mysql_fdw/blob/master/mysql_fdw.c#L734

https://github.com/EnterpriseDB/mysql_fdw/issues/73

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)


--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs



--
Rushabh Lathia

pgsql-bugs by date:

Previous
From: aprasad@flexerasoftware.com
Date:
Subject: [BUGS] BUG #14712: postgres how to handle boolean datatype to use 0 and 1using hibernate
Next
From: Mark Manley
Date:
Subject: Re: [BUGS] BUG #14709: inconsistent answers with foreign datawrappers to mysql