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 1pznFn-00060W-NG for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:41:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pznFm-0001Cl-Ku for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:41:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pznFm-0001CZ-DU for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:50 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pznFj-000Zbj-9K for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:49 +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=bIErR0A61l7/EuahrvjluJnS/41SWLr5+Ob2YSHBzgg=; b=FktcYwcqA+g4bx8sxU3Nw3gkHN PBFWQ8e85nBTSdjZixrogb3/uNtJB6JsYG3bAzNd//EiY3je1gD14AqF2aIWxdHL5iPjVPIOCuyvW j/1UJu68aDkZfcm/NR86OXigTwbEL0Z08KjtbS7eVDvaK6U9Cx/lfJ3JVf9OPZIVYOCoNHxc9NMEa MczW72kVsYI0wyMJQ3WbcZmTPHscD3BaLxOK4unHVouzik5tR9dcmuHl697hW8u9o9UaXGTxog3+7 dXoh7ts2BHXyBL1FQCPUVvgYBo1WhXAKgYzZGLLgJVnuk57C6j1VoDv9rxaS90FCIutrEo8tzKOYI OF54aGRQ==; 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 1pznFj-0006tM-1S for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:47 +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 1pznFi-000ZwU-VL for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:46 +0000 Content-Type: multipart/mixed; boundary="===============4486663693185268034==" 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:46 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4486663693185268034== 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 ZXJwcmlzZWRiLmNvbQoKQnJhbmNoCi0tLS0tLQpSRUxfMTNfU1RBQkxFCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi82YzUxMmZjNmU5MGQ3 ZjBiZTk5MDkwZmEwODRjMDE0MThkZmU4MGIzCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpzcmMvYmFja2VuZC9hY2Nlc3MvYnJpbi9icmluLmMgICAgICAgICAgICAgICAgICAgICB8IDE0 NiArKysrKysrKysrKysrKysrKysrKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL2JyaW4vYnJpbl90dXBs ZS5jICAgICAgICAgICAgICAgfCAgMTQgKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL2JyaW5fdHVwbGUu aCAgICAgICAgICAgICAgICAgICAgfCAgIDYgKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlucHJv Z3Jlc3MtaW5zZXJ0aW9uLm91dCAgICAgfCAgIDggKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlu cHJvZ3Jlc3MtaW5zZXJ0aW9uLnNwZWMgICAgfCAgIDEgKwo1IGZpbGVzIGNoYW5nZWQsIDE2NyBp bnNlcnRpb25zKCspLCA4IGRlbGV0aW9ucygtKQoK --===============4486663693185268034==--