Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZJjCS-00072W-S8 for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jul 2015 14:16:16 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZJjCS-0008PK-E1 for pgsql-hackers@arkaria.postgresql.org; Mon, 27 Jul 2015 14:16:16 +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_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZJjCR-0008P2-OP for pgsql-hackers@postgresql.org; Mon, 27 Jul 2015 14:16:15 +0000 Received: from smtp-auth.no-ip.com ([8.23.224.61] helo=out.smtp-auth.no-ip.com) by magus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1ZJjCL-0002Ml-Ei for pgsql-hackers@postgresql.org; Mon, 27 Jul 2015 14:16:15 +0000 X-No-IP: alvh.no-ip.org@noip-smtp X-Report-Spam-To: abuse@no-ip.com Received: from alvin.alvh.no-ip.org (unknown [181.42.250.3]) (Authenticated sender: alvh.no-ip.org@noip-smtp) by smtp-auth.no-ip.com (Postfix) with ESMTPA id 64882400A28; Mon, 27 Jul 2015 07:16:05 -0700 (PDT) Received: by alvin.alvh.no-ip.org (Postfix, from userid 1000) id 732F81123; Mon, 27 Jul 2015 16:15:58 +0200 (CEST) Date: Mon, 27 Jul 2015 11:15:58 -0300 From: Alvaro Herrera To: Tom Lane Cc: Andreas Seltenreich , pgsql-hackers@postgresql.org Subject: Re: Failing assertions in indxpath.c, placeholder.c and brin_minmax.c Message-ID: <20150727141558.GF5596@postgresql.org> References: <871tfv3wor.fsf@ex.ansel.ydns.eu> <20646.1437919632@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20646.1437919632@sss.pgh.pa.us> User-Agent: Mutt/1.5.23 (2014-03-12) X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Tom Lane wrote: > Bottom line is that somebody failed to consider the possibility of a > null comparison value reaching the BRIN index lookup machinery. > The code stanza that's failing supposes that only IS NULL or IS NOT NULL > tests could have SK_ISNULL set, but that's just wrong. Hm, okay, will look into that. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers