BUG #16633: Foreign data wrapper mysql-fdw issue - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16633: Foreign data wrapper mysql-fdw issue
Date
Msg-id 16633-3ec02076d6cb6dc8@postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16633
Logged by:          Emmanuel O
Email address:      emmanuel.ona@seetickets.fr
PostgreSQL version: 11.9
Operating system:   Debian GNU/Linux 10 (buster)
Description:

Hi

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

the select is still requesting on the MariaCS server until the PG session is
closed

i'm in trouble to see that this select runs well with this environment:
PG11/debian Stretch

but not with:
PG11/debian Buster
PG12/debian Buster

A Mysql client on the PG server requests with no issues in all cases

Thanks a lot

Emmanuel


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16632: Not a bug, just a typo
Next
From: PG Bug reporting form
Date:
Subject: BUG #16634: Conflicting names of indexes for partitioned tables