Re: BUG #16013: Unexpected results from bit field query - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16013: Unexpected results from bit field query
Date
Msg-id 16290.1569188869@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #16013: Unexpected results from bit field query  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
I wrote:
> PG Bug reporting form <noreply@postgresql.org> writes:
>> A query using a right bit shift and an equality on a bit field seems to
>> return incorrect results.

> Ugh.  bit_cmp expects that any unused bits in the last byte
> are guaranteed zero, but bitshiftright isn't ensuring that.
> Didn't look to see if the same bug exists anywhere else ...

After digging around, it seems that no other bit functions have
this issue.  I've pushed a fix --- thanks for the report!

            regards, tom lane



pgsql-bugs by date:

Previous
From: Andrew Gierth
Date:
Subject: Re: BUG #16017: Postgres does not respond non-local connections
Next
From: Morris de Oryx
Date:
Subject: Re: citext LIKE search bug