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 1pznJU-00069F-EL for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:45:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pznJT-0007k3-4z for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:45:39 +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 1pznGT-000420-C7 for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:33 +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 1pznGP-000cZk-VJ for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:32 +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=u1Ny3a6/bDuoejCxGIZGSiWjcQ0wKR3preGRpcRIY2g=; b=CrYqhzXvjHozlL4nJ6sD9z4dHD r0+qbTN5616SOsnZTPb1Rber6vzodHH2BZ9uvifwythNHCye237+oLI5RFFqfAFJYFvkXCexTykYM GwMFBRFKK+7p5j3kOjrZYFp6astfaoMD7iJ4WYagudr8zVwVfvYoAySsyMkgRcvYt7PhfWryYEtde STCfc67CMn+8PQ+Nn0f9erFs4+b58ZMibIorfpx9Bh/za80sSnNoYrbyJkuncWkVnSchRpWuXdHN6 oLTOSY9M6UIfxbCQe/F1ynpIl5IhY4LkMGQpjwMxKQjq2SVuthsQuOHRPpc+RyBuJXmayf1Nc8SNf zb9vPFrg==; 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 1pznGP-0006u7-Jh for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:29 +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 1pznGP-000Zy1-HM for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:29 +0000 Content-Type: multipart/mixed; boundary="===============6969806950455259526==" 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:42:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6969806950455259526== 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 ZXJwcmlzZWRiLmNvbQoKQnJhbmNoCi0tLS0tLQpSRUxfMTFfU1RBQkxFCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9mYzdkYzcyOGQxYTY4 ZGQ2N2FmYzk3OTVmZDY1YjhhOGQ0MTIyNDRkCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpzcmMvYmFja2VuZC9hY2Nlc3MvYnJpbi9icmluLmMgICAgICAgICAgICAgICAgICAgICB8IDE0 NiArKysrKysrKysrKysrKysrKysrKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL2JyaW4vYnJpbl90dXBs ZS5jICAgICAgICAgICAgICAgfCAgMTQgKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL2JyaW5fdHVwbGUu aCAgICAgICAgICAgICAgICAgICAgfCAgIDYgKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlucHJv Z3Jlc3MtaW5zZXJ0aW9uLm91dCAgICAgfCAgIDggKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlu cHJvZ3Jlc3MtaW5zZXJ0aW9uLnNwZWMgICAgfCAgIDEgKwo1IGZpbGVzIGNoYW5nZWQsIDE2NyBp bnNlcnRpb25zKCspLCA4IGRlbGV0aW9ucygtKQoK --===============6969806950455259526==--