From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Christoph Berg <myon(at)debian(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: mysql_fdw + PG10: unrecognized node type: 217 |
Date: | 2017-09-11 09:03:06 |
Message-ID: | 20170911090306.s7sj4uyr4t72wbam@alap3.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
On 2017-09-11 10:53:39 +0200, Christoph Berg wrote:
> Re: To Tom Lane 2017-09-11 <20170911083136(dot)stdnc4w52wk3o4se(at)msg(dot)df7cb(dot)de>
> > postgres=# select test_param_where();
> > FEHLER: XX000: unrecognized node type: 217
> > KONTEXT: SQL-Anweisung »select b from numbers where a=x«
> > PL/pgSQL-Funktion test_param_where() Zeile 6 bei SQL-Anweisung
> > ORT: ExecInitExprRec, execExpr.c:2031
>
> The problem happens on the 6th iteration of this loop:
>
> CREATE FOREIGN TABLE numbers(a int, b varchar(255)) SERVER mysql_svr OPTIONS (dbname 'testdb', table_name 'numbers');
>
> create or replace function test_param_where() returns void as $$
> DECLARE
> n varchar;
> BEGIN
> FOR x IN 1..9 LOOP
> select b into n from numbers where a=x;
> raise notice 'Found number %', n;
> end loop;
> return;
> END
> $$ LANGUAGE plpgsql;
>
> SELECT test_param_where();
>
> ***************
> *** 345,368 ****
> 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;
> ...
> --- 344,365 ----
> 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
> ! /*
Could you pprint() the expression that's being initialized?
Greetings,
Andres Freund
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-09-11 09:13:21 | Re: Setting pd_lower in GIN metapage |
Previous Message | Christoph Berg | 2017-09-11 08:53:39 | Re: mysql_fdw + PG10: unrecognized node type: 217 |