Re: pg_plan_advice
| От | Alexander Lakhin |
|---|---|
| Тема | Re: pg_plan_advice |
| Дата | |
| Msg-id | c0c63979-43c2-4424-8fe8-56949934c9d8@gmail.com обсуждение |
| Ответ на | Re: pg_plan_advice (Robert Haas <robertmhaas@gmail.com>) |
| Ответы |
Re: pg_plan_advice
|
| Список | pgsql-hackers |
13.04.2026 19:01, Robert Haas wrote:
Sounds like we have a consensus. I have committed the three bug-fix patches (unrelated to the retry-loop stuff) ...
Thanks again for committing these fixes, Robert! With all the fixes in
place, I and SQLsmith have reached another error:
CREATE TABLE t1(a int);
CREATE TABLE t2(b int);
SELECT 1 FROM t1 WHERE EXISTS
(SELECT 1 FROM
(SELECT 1 FROM
(SELECT 1) LEFT JOIN t2 ON true),
t2 WHERE a = b);
ERROR: XX000: unique semijoin found for relids (b 3 5 7) but not observed during planning
LOCATION: pgpa_plan_walker, pgpa_walker.c:153
Could you please have a look?
Best regards,
Alexander
В списке pgsql-hackers по дате отправления: