ERROR: negative bitmapset member not allowed in SELECT - Mailing list pgsql-bugs

From Manuel Rigger
Subject ERROR: negative bitmapset member not allowed in SELECT
Date
Msg-id CA+u7OA65+jEFb_TyV5g+Kq+onyJ2skMOPzgTgFH+qgLwszRqvw@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: negative bitmapset member not allowed in SELECT  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Hi everyone,

the following statements results in an error "ERROR:  negative
bitmapset member not allowed", which is unexpected:

CREATE TABLE t0(c0 serial, c1 boolean);
CREATE STATISTICS s1 ON c0, c1 FROM t0;
INSERT INTO t0(c1) VALUES(TRUE);
ANALYZE;
CREATE INDEX i0 ON t0(c0, (t0.c1 AND t0.c1));
SELECT * FROM (SELECT t0.c0 FROM t0 WHERE (((t0.c1) AND (t0.c1)) OR
FALSE) IS TRUE) as result WHERE result.c0 IS NULL; -- unexpected:
ERROR:  negative bitmapset member not allowed

When replacing serial by integer, I instead get "ERROR:  type with OID
21938 does not exist".

I'm using the following Postgres version: 12beta2 (Debian 12~beta2-1.pgdg90+1).

Best,
Manuel



pgsql-bugs by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: BUG #15888: Bogus "idle in transaction" state for logicaldecoding client after creating a slot
Next
From: Juan José Santamaría Flecha
Date:
Subject: Re: BUG #15889: PostgreSQL failed to build due to error MSB8020 withMSVC on windows