From: | Zu-Ming Jiang <zuming(dot)jiang(at)inf(dot)ethz(dot)ch> |
---|---|
To: | <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
Subject: | Re: BUG #18260: Unexpected error: "negative bitmapset member not allowed" triggered by multiple JOIN |
Date: | 2023-12-27 10:31:21 |
Message-ID: | f257504a-07e2-408e-b007-c249c1657459@inf.ethz.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
When I removed "window w0 as (partition by ref_33.c_3 order by
ref_33.c_4 desc)" in the test case query, the query did not trigger
errors any more.
Specifically, this query did not trigger errors:
with cte_1 as (select
ref_1.c_0 as c_2,
ref_1.c_4 as c_3,
case when (nullif(ref_1.c_2, ref_1.c_0) <> (
select
ref_53.c_2 as c_0
from
(t1 as ref_52 left outer join t3 as ref_53 on true)
where (ref_53.c_6) ~~ (ref_53.c_6)
order by c_0 limit 1)
) then null else null end
as c_4
from
t3 as ref_1)
select 1
from
cte_1 as ref_33
where (ref_33.c_2 > (
select
ref_200.c_2 as c_0
from
t3 as ref_200
order by c_0 limit 1));
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2023-12-27 10:47:36 | BUG #18261: Inconsistent results of SELECT affected by joined subqueries |
Previous Message | PG Bug reporting form | 2023-12-27 09:33:34 | BUG #18260: Unexpected error: "negative bitmapset member not allowed" triggered by multiple JOIN |