Re: BUG #14709: inconsistent answers with foreign data wrappers to mysql

From: Rushabh Lathia <rushabh(dot)lathia(at)gmail(dot)com>
To: mark(dot)manley(at)tapad(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org, Ahsan Hadi <ahsan(dot)hadi(at)enterprisedb(dot)com>
Subject: Re: BUG #14709: inconsistent answers with foreign data wrappers to mysql
Date: 2017-06-19 07:57:57
Message-ID: CAGPqQf1SxdFW8yTG8yVPnbC9_E4BC-fsRU=0wuxQEPd4XPZ6Sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)tao11(dot)riddles(dot)org(dot)uk>
wrote:

> >>>>> "mark" == mark manley <mark(dot)manley(at)tapad(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

--
Rushabh Lathia
www.EnterpriseDB.com

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Mark Manley 2017-06-19 10:57:13 Re: BUG #14709: inconsistent answers with foreign data wrappers to mysql
Previous Message aprasad 2017-06-19 07:09:20 BUG #14712: postgres how to handle boolean datatype to use 0 and 1 using hibernate