Re: ERROR: found unexpected null value in index - Mailing list pgsql-bugs

From Tom Lane
Subject Re: ERROR: found unexpected null value in index
Date
Msg-id 20825.1562723034@sss.pgh.pa.us
Whole thread Raw
In response to Re: ERROR: found unexpected null value in index  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: ERROR: found unexpected null value in index
List pgsql-bugs
Peter Geoghegan <pg@bowt.ie> writes:
> On Tue, Jul 9, 2019 at 6:08 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The error is coming from the planner's get_actual_variable_range:
>> and I think it's entirely within its rights to complain, because it
>> set up the scan key to reject nulls.  In short, somebody seems to
>> have broken btrees' processing of SK_ISNULL | SK_SEARCHNOTNULL scankeys,
>> and they broke it in v11, because prior versions don't show this failure.

> It's not obvious to me why that might be. I'll run a "git bisect" to
> track down the offending commit.

I just finished doing that, and indeed it fingers 3ca930fc3 as the
first bad commit.  Seems like it must have exposed a pre-existing
problem though?  Too tired to look further tonight.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: ERROR: found unexpected null value in index
Next
From: Peter Geoghegan
Date:
Subject: Re: ERROR: found unexpected null value in index