Thread: rangesel() bugs on basic comparison operators with an empty range

rangesel() bugs on basic comparison operators with an empty range

From
Emre Hasegeli
Date:
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

Re: rangesel() bugs on basic comparison operators with an empty range

From
Emre Hasegeli
Date:
> Patch attached.

I found one more place, new version attached.

Re: rangesel() bugs on basic comparison operators with an empty range

From
Tom Lane
Date:
Emre Hasegeli <emre@hasegeli.com> writes:
> I found one more place, new version attached.

I see no patch here ...

            regards, tom lane

Re: rangesel() bugs on basic comparison operators with an empty range

From
Emre Hasegeli
Date:
> I see no patch here ...

I am sorry.  Now attached.

Attachment

Re: rangesel() bugs on basic comparison operators with an empty range

From
Tom Lane
Date:
Emre Hasegeli <emre@hasegeli.com> writes:
>> I see no patch here ...

> I am sorry.  Now attached.

Applied with some additional cleanup.

            regards, tom lane