mysql_fdw + PG10: unrecognized node type: 217

From: Christoph Berg <myon(at)debian(dot)org>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: mysql_fdw + PG10: unrecognized node type: 217
Date: 2017-09-10 20:51:35
Message-ID: 20170910205134.al4lnf3i2wvre33c@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

I'm not sure if this is a bug in mysql_fdw, or in PG10:

============== running regression test queries ==============
test mysql_fdw ... FAILED

*** 345,359 ****
NOTICE: Found number Three
NOTICE: Found number Four
NOTICE: Found number Five
! NOTICE: Found number Six
! NOTICE: Found number Seven
! NOTICE: Found number Eight
! NOTICE: Found number Nine
! test_param_where
! ------------------
!
! (1 row)
!
DELETE FROM employee;
DELETE FROM department;
DELETE FROM empdata;
--- 344,352 ----
NOTICE: Found number Three
NOTICE: Found number Four
NOTICE: Found number Five
! ERROR: unrecognized node type: 217
! CONTEXT: SQL statement "select b from numbers where a=x"
! PL/pgSQL function test_param_where() line 6 at SQL statement
DELETE FROM employee;
DELETE FROM department;
DELETE FROM empdata;

mysql_fdw master at 7d084c59, PG10 at 6913d066.

The testsuite was running against this mysql schema:

CREATE DATABASE testdb;
USE testdb;

CREATE USER 'foo'@'127.0.0.1' IDENTIFIED BY 'bar';
GRANT ALL PRIVILEGES ON testdb.* TO 'foo'@'127.0.0.1';

CREATE TABLE department(department_id int, department_name text, PRIMARY KEY (department_id));
CREATE TABLE employee(emp_id int, emp_name text, emp_dept_id int, PRIMARY KEY (emp_id));
CREATE TABLE empdata (emp_id int, emp_dat blob, PRIMARY KEY (emp_id));
CREATE TABLE numbers(a int PRIMARY KEY, b varchar(255));

Christoph

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2017-09-10 20:56:55 Re: mysql_fdw + PG10: unrecognized node type: 217
Previous Message Tom Lane 2017-09-10 18:39:40 relation mapping file checksum failure