Re: mysql-fdw fail

From: Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>
To: Emmanuel OÑA <emmanuel(dot)ona(at)seetickets(dot)fr>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: mysql-fdw fail
Date: 2020-09-24 10:35:08
Message-ID: CAPmGK16PkkHOyZHty2h5=K26WRiXODAOmDGEZ=MsDO87HC6V-w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Thu, Sep 24, 2020 at 12:49 AM Emmanuel OÑA
<emmanuel(dot)ona(at)seetickets(dot)fr> wrote:
> i'm facing an issue with PG11 using the mysql_fdw with a remote Mariadb
> Column Store database (10.2.10-MariaDB-log Columnstore 1.1.2-1)
> Requesting a simple select on a foreign table the error message is
>
> postgres=# select * from mysql_foreign_table1 limit 5;
> ERROR: failed to execute the MySQL query:
> Commands out of sync; you can't run this command now

I’m not a mysql_fdw expert, but I think the error would have been
thrown by mysql_fdw, not by the PostgreSQL core. I recommend you to
report this to the development team of mysql_fdw.

Best regards,
Etsuro Fujita

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-09-24 14:08:54 Re: BUG #16634: Conflicting names of indexes for partitioned tables
Previous Message David Rowley 2020-09-24 09:43:54 Re: BUG #16627: union all with partioned table yields random aggregate results