From: Tomas Vondra <tomas.vondra@2ndquadrant.com>
To: tuomas.leikola@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16111: Unexpected query compilation error “negative bitmapset member not allowed”
Date: Sat, 16 Nov 2019 02:36:42 +0100
Message-ID: <20191116013642.t45tcb5r2av5nhn5@development> (raw)
In-Reply-To: <20191113134114.rxcli5c6zjmryvf6@development>
References: <16111-687799584c3a7e73@postgresql.org>
<20191113134114.rxcli5c6zjmryvf6@development>
On Wed, Nov 13, 2019 at 02:41:14PM +0100, Tomas Vondra wrote:
>On Wed, Nov 13, 2019 at 10:42:32AM +0000, PG Bug reporting form wrote:
>>The following bug has been logged on the website:
>>
>>Bug reference: 16111
>>Logged by: Tuomas Leikola
>>Email address: tuomas.leikola@gmail.com
>>PostgreSQL version: 12.0
>>Operating system: windows, linux
>>Description:
>>
>>I’ve been trying to cook up some kind of online reorganizer, which requires
>>looking at rows’ physical locations and rearranging those that are
>>suboptimal. In this endeavor, I stumbled on what appears to be a compiler
>>bug introduced with multivariate statistics.
>>
>
>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+.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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: 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: <20191116013642.t45tcb5r2av5nhn5@development>
* 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