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 27542.1568864239@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16013: Unexpected results from bit field query  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16013: Unexpected results from bit field query
List pgsql-bugs
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 ...

            regards, tom lane



pgsql-bugs by date:

Previous
From: Morris de Oryx
Date:
Subject: Fwd: citext LIKE search bug
Next
From: Tom Lane
Date:
Subject: Re: citext LIKE search bug