Horton

Re: BUG #16013: Unexpected results from bit field query

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: daryl.waycott@edgeintelligence.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2019-09-19T03:37:19Z
Lists: 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

Commits

  1. Fix failure to zero-pad the result of bitshiftright().