From: Justin Pryzby <pryzby@telsasoft.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: tuomas.leikola@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16111: Unexpected query compilation error “negative bitmapset member not allowed”
Date: Wed, 4 Dec 2019 18:38:23 -0600
Message-ID: <20191205003823.GB2082@telsasoft.com> (raw)
In-Reply-To: <20191116013642.t45tcb5r2av5nhn5@development>
References: <16111-687799584c3a7e73@postgresql.org>
<20191113134114.rxcli5c6zjmryvf6@development>
<20191116013642.t45tcb5r2av5nhn5@development>
On Sat, Nov 16, 2019 at 02:36:42AM +0100, Tomas Vondra wrote:
> >Yeah, this is a bug in estimate_multivariate_ndistinct, which fails to
> >ignore system attributes :-(
> >
> >The attached patch fixes it, but unfortunatly we've missed this round of
> >minor releases :-( I'll get it pushed in a couple of days.
> >
> >Thanks for the report and the reproducer, very helpful!
>
> I've pushed the fix, after a minor improvement (it wasn't quite right,
> because the bitmap was updated again a bit later). Backpatched to 10+.
I thought you'd be interested to know I just ran into this myself, so I
would've reported it now, if it hadn't already been fixed - thanks.
-- Note, that's actually a table named after a view..
ts=# explain SELECT tableoid::regclass FROM daily_enodeb_baseband_view GROUP BY 1;
ERROR: negative bitmapset member not allowed
--
Justin Pryzby
System Administrator
Telsasoft
+1-952-707-8581
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: pryzby@telsasoft.com, tomas.vondra@2ndquadrant.com, tuomas.leikola@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16111: Unexpected query compilation error “negative bitmapset member not allowed”
In-Reply-To: <20191205003823.GB2082@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox