Date: Wed, 4 Dec 2019 18:38:23 -0600
From: Justin Pryzby <pryzby@telsasoft.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: tuomas.leikola@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16111: Unexpected =?utf-8?Q?query?=
 =?utf-8?Q?_compilation_error_=E2=80=9Cnegative_bitmapset_member_not_allow?=
 =?utf-8?B?ZWTigJ0=?=
Message-ID: <20191205003823.GB2082@telsasoft.com>
References: <16111-687799584c3a7e73@postgresql.org>
 <20191113134114.rxcli5c6zjmryvf6@development>
 <20191116013642.t45tcb5r2av5nhn5@development>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20191116013642.t45tcb5r2av5nhn5@development>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk

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