[postgresql 10 beta3] unrecognized node type: 90

From: "Adam, Etienne (Nokia-TECH/Issy Les Moulineaux)" <etienne(dot)adam(at)nokia(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: "Duquesne, Pierre (Nokia-TECH/Issy Les Moulineaux)" <pierre(dot)duquesne(at)nokia(dot)com>
Subject: [postgresql 10 beta3] unrecognized node type: 90
Date: 2017-08-11 15:33:22
Message-ID: CAL7LBcYM-32B=n_-h_wPHWiML26UvqP3b_WxD7MgXgOwmxvTFw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

Hi,

While testing the beta3 of PostgreSQL 10 (Ubuntu/10~beta3-1.pgdg16.04+1) on
a database restored from production data, executing the following query
(field and table names have been changed):

SELECT id_c
FROM c
LEFT OUTER JOIN (
SELECT h_c AS h_c_sub, count(*) AS num
FROM r, c
WHERE id_a_r = 1308 AND id_c = id_c_r
GROUP BY h_c
) AS sent ON h_c = h_c_sub
WHERE ((date_trunc('days', age('2017-08-10', to_timestamp(d1_c))) > '11
days') AND ((h->'x') IS NULL) AND ((h->'x') IS NULL) AND ((d2_c IS NOT NULL
AND date_trunc('days', age('2017-08-10', to_timestamp(d2_c))) <= '10
days')))
AND NOT bool1 AND string1 IS NOT NULL AND (bool2 IS NULL OR bool2 = true)
AND coalesce(num, 0) < 1 AND coalesce(bool3, TRUE) IS TRUE;

We encountered the following error (the query executes fine on a 9.2
server):

ERROR: XX000: unrecognized node type: 90
LOCATION: ExecReScan, execAmi.c:284

If we modify it just a little bit (removing a WHERE clause), it works:

SELECT id_c
FROM c
LEFT OUTER JOIN (
SELECT h_c AS h_c_sub, count(*) AS num
FROM r, c
WHERE id_a_r = 1308 AND id_c = id_c_r
GROUP BY h_c
) AS sent ON h_c = h_c_sub
WHERE ((date_trunc('days', age('2017-08-10', to_timestamp(d1_c))) > '11
days') AND ((h->'x') IS NULL) AND ((h->'x') IS NULL))
AND NOT bool1 AND string1 IS NOT NULL AND (bool2 IS NULL OR bool2 = true)
AND coalesce(num, 0) < 1 AND coalesce(bool3, TRUE) IS TRUE;

We know it is a beta version but we wanted to report it in case it was not
a known bug. Please let us know if you need anything more,

Best,
Adam Etienne

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-08-11 15:59:14 Re: [postgresql 10 beta3] unrecognized node type: 90
Previous Message Michael Meskes 2017-08-11 13:38:37 Re: BUG #14754: ecpg SQL parsing error

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2017-08-11 15:38:27 Re: scan on inheritance parent with no children in current session
Previous Message Tom Lane 2017-08-11 15:24:37 Patches I'm thinking of pushing shortly