rangesel() bugs on basic comparison operators with an empty range - Mailing list pgsql-bugs

From Emre Hasegeli
Subject rangesel() bugs on basic comparison operators with an empty range
Date
Msg-id CAE2gYzw0Z6r2oBXxmXsUD3FA4pAhbky-nfuqSqdf1RFXDinPCg@mail.gmail.com
Whole thread Raw
Responses Re: rangesel() bugs on basic comparison operators with an empty range  (Emre Hasegeli <emre@hasegeli.com>)
List pgsql-bugs
I found a few bugs on the selectivity estimation function for
the range types, rangesel() for empty ranges.

# create table a (b int4range);
CREATE TABLE

# select * from a where b < 'empty';
ERROR:  unexpected operator 3884

# select * from a where b >= 'empty';
ERROR:  unexpected operator 3886

Patch attached.

Attachment

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #12694: crash if the number of result rows is lower than gin_fuzzy_search_limit
Next
From: Emre Hasegeli
Date:
Subject: Re: rangesel() bugs on basic comparison operators with an empty range