From: | Emmanuel OÑA <emmanuel(dot)ona(at)seetickets(dot)fr> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | mysql-fdw fail |
Date: | 2020-09-23 15:49:45 |
Message-ID: | 8f4276c7-9b6c-112b-ace0-0030ff62c4ae@seetickets.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2020-09-23 16:12:13 | Re: BUG #16630: TupleDesc reference leak: TupleDesc 0x7fad89c9c928 (16386,-1) still referenced |
Previous Message | Brian Kanaga | 2020-09-23 13:53:26 | RE: BUG #16627: union all with partioned table yields random aggregate results |