ERROR: negative bitmapset member not allowed in SELECT

From: Manuel Rigger <rigger(dot)manuel(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: ERROR: negative bitmapset member not allowed in SELECT
Date: 2019-07-10 15:39:22
Message-ID: CA+u7OA65+jEFb_TyV5g+Kq+onyJ2skMOPzgTgFH+qgLwszRqvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Juan José Santamaría Flecha 2019-07-10 15:43:53 Re: BUG #15889: PostgreSQL failed to build due to error MSB8020 with MSVC on windows
Previous Message Magnus Hagander 2019-07-10 15:24:44 Re: BUG #15888: Bogus "idle in transaction" state for logical decoding client after creating a slot