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
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 |