Re: Properly pathify the union planner - Mailing list pgsql-hackers

From Alexander Lakhin
Subject Re: Properly pathify the union planner
Date
Msg-id 242fc7c6-a8aa-2daf-ac4c-0a231e2619c1@gmail.com
Whole thread Raw
In response to Re: Properly pathify the union planner  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Properly pathify the union planner
List pgsql-hackers
Hello David,

25.03.2024 04:43, David Rowley wrote:
> I didn't see that as a reason not to push this patch as this occurs
> both with and without this change, so I've now pushed this patch.

Please look at a new assertion failure, that is triggered by the following
query:
SELECT count(*) FROM (
   WITH q1(x) AS (SELECT 1)
   SELECT FROM q1 UNION SELECT FROM q1
) qu;

TRAP: failed Assert("lg != NULL"), File: "planner.c", Line: 7941, PID: 1133017

Best regards,
Alexander



pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Slow GRANT ROLE on PostgreSQL 16 with thousands of ROLEs
Next
From: Tom Lane
Date:
Subject: Re: Propagate pathkeys from CTEs up to the outer query