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
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 |