pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedsyntactically correct query gives ERROR: failed to assign all NestLoopParams to plan nodes
2+ messages / 2 participants
[nested] [flat]
* syntactically correct query gives ERROR: failed to assign all NestLoopParams to plan nodes
@ 2021-01-15 19:54 Stephan Springl <springl-psql@bfw-online.de>
0 siblings, 1 reply; 2+ messages in thread
From: Stephan Springl @ 2021-01-15 19:54 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Hi,
running
psql -f NestLoopParams.sql
gives
psql:NestLoopParams.sql:16: ERROR: failed to assign all NestLoopParams to plan nodes
psql:NestLoopParams.sql:24: ERROR: failed to assign all NestLoopParams to plan nodes
and does not process the seemingly correct query
select u.zielnummer, gnummer.v
from u
left join b on b.btext ~ '^verr\. R(\d+)$'
left join lateral (select regexp_replace (b.btext, 'verr\. R', '')::int v)
as gnummer on true
left join lateral (select * from r where buchnummer = gnummer.v)
as r on true;
No results are given, not even row count or headers, just the error
message given above.
Everything needed to reproduce is in the file NestLoopParams.sql. The
tables do not need to be populated with data. The problem was verified
with Postgresql version 13.1 on a fresh debian sid x86_64 installation as
well as a 13.1 compiled under 32 bit i386 (Debian/Linux). Master from the
posgresql git repository (as of today's commit
f9900df5f94936067e6fa24a9df609863eb08da2) shows the same behaviour if
compiled under 32 bit i386 Debian/Linux.
I will be happy to provide more information if needed or helpful.
Thank you for your work on such an extraordinary piece of software.
Regards
Stephan
Attachments:
NestLoopParams.sql (application/x-sql, 763B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: syntactically correct query gives ERROR: failed to assign all NestLoopParams to plan nodes
@ 2021-01-17 02:18 Tom Lane <tgl@sss.pgh.pa.us>
parent: Stephan Springl <springl-psql@bfw-online.de>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2021-01-17 02:18 UTC (permalink / raw)
To: Stephan Springl <springl-psql@bfw-online.de>; +Cc: pgsql-bugs@lists.postgresql.org
Stephan Springl <springl-psql@bfw-online.de> writes:
> running
> psql -f NestLoopParams.sql
> gives
> psql:NestLoopParams.sql:16: ERROR: failed to assign all NestLoopParams to plan nodes
> psql:NestLoopParams.sql:24: ERROR: failed to assign all NestLoopParams to plan nodes
Thanks for the report! This turns out to be not entirely trivial
to fix. I've started a discussion about it at [1]. One way or
another we should have a fix in place for February's releases.
regards, tom lane
[1] https://www.postgresql.org/message-id/171041.1610849523%40sss.pgh.pa.us
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-01-17 02:18 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-15 19:54 syntactically correct query gives ERROR: failed to assign all NestLoopParams to plan nodes Stephan Springl <springl-psql@bfw-online.de>
2021-01-17 02:18 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox