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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers