Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pznFT-0005zW-1j for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:41:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pznFR-0008O0-Vi for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:41:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pznFR-0008Nr-Oj for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:29 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pznFO-000cZ1-9D for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=EqBFjwv2EH/ky7Q9XoKYdnJhk1u2+y7QNkCRJufTIik=; b=Pz3KIAbqMH0D6ErXU0fSWuG+A5 a8oOaGS0DVAkyh8zTcObG6Mg0iSGHU3Hcgw51r5WYNG6xqt08B63aSfDzYO9XeM1zcGN40iDhTx/0 XHsYiYCGjElaRH27snJtBIg5FfQSYAgRamblWYIabxGosKvh5qnFUHL94iIVF4aPiZM7Yp17dOomS HbAaV3Mvm55Ny2ukEtVNXIKmCJGRid0nbCl2tkuGxIXCr+7x3UZc6GCeimkTdob9qyg+PlKTyrXW4 1tn8QaRfUT6QuIJ8I38iktDSxTMn2IY0ilW1GCiKFWghdonc2bK10g+90M3VeTd8/7sOi9RfYSye8 7htbLM8g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pznFO-0006sq-01 for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:26 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pznFN-000ZvF-TK for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:25 +0000 Content-Type: multipart/mixed; boundary="===============8983240024042176395==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix handling of empty ranges and NULLs in BRIN X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 18 May 2023 23:41:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8983240024042176395== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGhhbmRsaW5nIG9mIGVtcHR5IHJhbmdlcyBhbmQgTlVMTHMgaW4gQlJJTgoKQlJJTiBpbmRl eGVzIGRpZCBub3QgcHJvcGVybHkgZGlzdGluZ3Vpc2ggYmV0d2VlbiBzdW1tYXJpZXMgZm9yIGVt cHR5CihubyByb3dzKSBhbmQgYWxsLU5VTEwgcmFuZ2VzLCB0cmVhdGluZyB0aGVtIGFzIGVzc2Vu dGlhbGx5IHRoZSBzYW1lCnRoaW5nLiBTdW1tYXJpZXMgd2VyZSBpbml0aWFsaXplZCB3aXRoIGFs bG51bGxzPXRydWUsIGFuZCBvcGNsYXNzZXMKc2ltcGx5IHJlc2V0IGFsbG51bGxzIHRvIGZhbHNl IHdoZW4gcHJvY2Vzc2luZyB0aGUgZmlyc3Qgbm9uLU5VTEwgdmFsdWUuClRoaXMgaG93ZXZlciBw cm9kdWNlcyBpbmNvcnJlY3QgcmVzdWx0cyBpZiB0aGUgcmFuZ2Ugc3RhcnRzIHdpdGggYSBOVUxM CnZhbHVlIChvciBhIHNlcXVlbmNlIG9mIE5VTEwgdmFsdWVzKSwgaW4gd2hpY2ggY2FzZSB3ZSBm b3JnZXQgdGhlIHJhbmdlCmNvbnRhaW5zIE5VTEwgdmFsdWVzIHdoZW4gYWRkaW5nIHRoZSBmaXJz dCBub24tTlVMTCB2YWx1ZS4KClRoaXMgaGFwcGVucyBiZWNhdXNlIHRoZSBhbGxudWxscyBmbGFn IGlzIHVzZWQgZm9yIHR3byBzZXBhcmF0ZQpwdXJwb3NlcyAtIHRvIG1hcmsgZW1wdHkgcmFuZ2Vz IChub3QgcmVwcmVzZW50aW5nIGFueSByb3dzIHlldCkgYW5kCnJhbmdlcyBjb250YWluaW5nIG9u bHkgTlVMTCB2YWx1ZXMuCgpPcGNsYXNzZXMgZG9uJ3Qga25vdyB3aGljaCBvZiB0aGVzZSBjYXNl cyBpdCBpcywgYW5kIHNvIGRvbid0IGtub3cKd2hldGhlciB0byBzZXQgaGFzbnVsbHM9dHJ1ZS4g U2V0dGluZyB0aGUgZmxhZyBpbiBib3RoIGNhc2VzIHdvdWxkIG1ha2UKaXQgY29ycmVjdCwgYnV0 IGl0IHdvdWxkIGFsc28gbWFrZSBCUklOIGluZGV4ZXMgdXNlbGVzcyBmb3IgcXVlcmllcyB3aXRo CklTIE5VTEwgY2xhdXNlcy4gQWxsIHJhbmdlcyBzdGFydCBlbXB0eSAoYW5kIHRodXMgYWxsbnVs bHM9dHJ1ZSksIHNvIGFsbApyYW5nZXMgd291bGQgZW5kIHVwIHdpdGggZWl0aGVyIGFsbG51bGxz PXRydWUgb3IgaGFzbnVsbHM9dHJ1ZS4KClRoZSBzZXZlcml0eSBvZiB0aGUgaXNzdWUgaXMgc29t ZXdoYXQgcmVkdWNlZCBieSB0aGUgZmFjdCB0aGF0IGl0IG9ubHkKaGFwcGVucyB3aGVuIGFkZGlu ZyB2YWx1ZXMgdG8gYW4gZXhpc3Rpbmcgc3VtbWFyeSB3aXRoIGFsbG51bGxzPXRydWUuClRoaXMg Y2FuIGhhcHBlbiBlLmcuIGZvciBzbWFsbCB0YWJsZXMgKGJlY2F1c2UgYSBzdW1tYXJ5IGZvciB0 aGUgZmlyc3QKcmFuZ2UgZXhpc3RzIGZvciBhbGwgQlJJTiBpbmRleGVzKSwgb3IgZm9yIHRhYmxl cyB3aXRoIGxhcmdlIGZyYWN0aW9uIG9mCk5VTEwgdmFsdWVzIGluIHRoZSBpbmRleGVkIGNvbHVt bnMuCgpCdWxrIHN1bW1hcml6YXRpb24gKGUuZy4gZHVyaW5nIENSRUFURSBJTkRFWCBvciBhdXRv bWF0aWMgc3VtbWFyaXphdGlvbikKdGhhdCBwcm9jZXNzZXMgYWxsIHZhbHVlcyBhdCBvbmNlIGlz IG5vdCBhZmZlY3RlZCBieSB0aGlzIGlzc3VlLiBJbiB0aGlzCmNhc2UgdGhlIGZsYWdzIHdlcmUg dXBkYXRlZCBpbiBhIHNsaWdodGx5IGRpZmZlcmVudCB3YXksIG5vdCBmb3JnZXR0aW5nCnRoZSBO VUxMIHZhbHVlcy4KClRvIGlkZW50aWZ5IGVtcHR5IHJhbmdlcyB3ZSB1c2UgYSBuZXcgZmxhZywg c3RvcmVkIGluIGFuIHVudXNlZCBiaXQgaW4KdGhlIEJSSU4gdHVwbGUgaGVhZGVyIHNvIHRoZSBv bi1kaXNrIGZvcm1hdCByZW1haW5zIHRoZSBzYW1lLiBBIG1hdGNoaW5nCmZsYWcgaXMgYWRkZWQg dG8gQnJpbk1lbVR1cGxlLCBpbnRvIGEgM0IgZ2FwIGFmdGVyIGJ0X3BsYWNlaG9sZGVyLgpUaGF0 IG1lYW5zIHRoZXJlJ3Mgbm8gcmlzayBvZiBBQkkgYnJlYWthZ2UsIGFsdGhvdWdoIHdlIGRvbid0 IGFjdHVhbGx5CnBhc3MgdGhlIEJyaW5NZW1UdXBsZSB0byBhbnkgcHVibGljIEFQSS4KCldlIGNv dWxkIGFsc28gc2tpcCBzdG9yaW5nIGluZGV4IHR1cGxlcyBmb3IgZW1wdHkgc3VtbWFyaWVzLCBi dXQgdGhlbgp3ZSdkIGhhdmUgdG8gYWx3YXlzIHByb2Nlc3Mgc3VjaCByYW5nZXMgLSBldmVuIGlm IHRoZXJlIGFyZSBubyByb3dzIGluCmxhcmdlIHBhcnRzIG9mIHRoZSB0YWJsZSAoZS5nLiBhZnRl ciBhIGJ1bGsgREVMRVRFKSwgaXQgd291bGQgc3RpbGwKcmVxdWlyZSByZWFkaW5nIHRoZSBwYWdl cyBldGMuIFNvIHdlIHN0b3JlIHRoZW0sIGJ1dCBpZ25vcmUgdGhlbSB3aGVuCmJ1aWxkaW5nIHRo ZSBiaXRtYXAuCgpCYWNrcGF0Y2ggdG8gMTEuIFRoZSBpc3N1ZSBleGlzdHMgc2luY2UgQlJJTiBp bmRleGVzIHdlcmUgaW50cm9kdWNlZCBpbgo5LjUsIGJ1dCBvbGRlciByZWxlYXNlcyBhcmUgYWxy ZWFkeSBFT0wuCgpCYWNrcGF0Y2gtdGhyb3VnaDogMTEKUmV2aWV3ZWQtYnk6IEp1c3RpbiBQcnl6 YnksIE1hdHRoaWFzIHZhbiBkZSBNZWVudCwgQWx2YXJvIEhlcnJlcmEKRGlzY3Vzc2lvbjogaHR0 cHM6Ly9wb3N0Z3IuZXMvbS80MDI0MzBlNC03ZDlkLTZjZjEtMDllZi00NjRkODBhZmZmM2JAZW50 ZXJwcmlzZWRiLmNvbQoKQnJhbmNoCi0tLS0tLQpSRUxfMTVfU1RBQkxFCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9lMTg3NjkzMjM5YWQ5 OWZjZmEzNjg4MTFmNTFmY2Y4YWY3NDI4MDgyCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpzcmMvYmFja2VuZC9hY2Nlc3MvYnJpbi9icmluLmMgICAgICAgICAgICAgICAgICAgICB8IDEx MyArKysrKysrKysrKysrKysrKysrKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL2JyaW4vYnJpbl90dXBs ZS5jICAgICAgICAgICAgICAgfCAgMTQgKystCnNyYy9pbmNsdWRlL2FjY2Vzcy9icmluX3R1cGxl LmggICAgICAgICAgICAgICAgICAgIHwgICA2ICstCi4uLi9zdW1tYXJpemF0aW9uLWFuZC1pbnBy b2dyZXNzLWluc2VydGlvbi5vdXQgICAgIHwgICA4ICstCi4uLi9zdW1tYXJpemF0aW9uLWFuZC1p bnByb2dyZXNzLWluc2VydGlvbi5zcGVjICAgIHwgICAxICsKNSBmaWxlcyBjaGFuZ2VkLCAxMzQg aW5zZXJ0aW9ucygrKSwgOCBkZWxldGlvbnMoLSkKCg== --===============8983240024042176395==--