Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1iAnH4-0001IU-D3
	for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Sep 2019 03:38:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1iAnG4-0008Hc-6I
	for pgsql-bugs@arkaria.postgresql.org; Thu, 19 Sep 2019 03:37:28 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1iAnG3-0008HO-UK
	for pgsql-bugs@lists.postgresql.org; Thu, 19 Sep 2019 03:37:27 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1iAnG0-0003cE-T1
	for pgsql-bugs@lists.postgresql.org; Thu, 19 Sep 2019 03:37:27 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x8J3bJjX027543;
	Wed, 18 Sep 2019 23:37:20 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: daryl.waycott@edgeintelligence.com
cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16013: Unexpected results from bit field query
In-reply-to: <16013-c2765b6996aacae9@postgresql.org>
References: <16013-c2765b6996aacae9@postgresql.org>
Comments: In-reply-to PG Bug reporting form <noreply@postgresql.org>
	message dated "Wed, 18 Sep 2019 16:49:43 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <27541.1568864239.1@sss.pgh.pa.us>
Date: Wed, 18 Sep 2019 23:37:19 -0400
Message-ID: <27542.1568864239@sss.pgh.pa.us>
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Precedence: bulk

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