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

From: Emre Hasegeli <emre(at)hasegeli(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: rangesel() bugs on basic comparison operators with an empty range
Date: 2015-01-30 14:31:52
Message-ID: CAE2gYzw0Z6r2oBXxmXsUD3FA4pAhbky-nfuqSqdf1RFXDinPCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
rangesel-empty-fix.patch application/octet-stream 6.7 KB

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Emre Hasegeli 2015-01-30 14:39:36 Re: rangesel() bugs on basic comparison operators with an empty range
Previous Message satson.csc17 2015-01-30 10:50:11 BUG #12717: Slow Query