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 1pznG9-00061G-Gj for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:42:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pznG8-0001i8-CQ for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:42:12 +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 1pznG8-0001hz-5E for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:12 +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 1pznG5-000Zbw-Fy for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:10 +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=iOTrh4qe14dCtWaONZNXPT7Yup4L2JoNNQlFiP+A1JQ=; b=nJfi5l1DFEsUvzEwXFXSchm4+P ok5ermryWromHXA+Bs6G1sqxsVeGhyt2OTfvzMjEUxiAk52LUlmpTBfT6xmvs/Bsqqm6t+tXXwfJ7 KBwVex/oAvFt9sFz5epOcPMhprvp8RWZynArPPb3HbfwHjfyIK3mzt4qKaBK4RanYJoOwlUOPbefu M8/5ADPmGzRmV3sZEDchewLg/uCyjq+s4CJBzOq0Fyqz7B4cbzKcuq9S/n7qPS7GH5mD6REI4T7Q+ Qe4emRKKF6EiipYdtrY5P47XZzZtzM9NHc7ZvKqrQuRfKbsLn2H/LNDfayGSW2vssqGPqgFKMEt1+ rP7cI/KA==; 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 1pznG5-0006tr-4W for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:09 +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 1pznG5-000ZxM-0a for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:42:08 +0000 Content-Type: multipart/mixed; boundary="===============5271915698413398427==" 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:08 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============5271915698413398427== 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 ZXJwcmlzZWRiLmNvbQoKQnJhbmNoCi0tLS0tLQpSRUxfMTJfU1RBQkxFCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi9kNzhhNjZkOTJjNzM5 ODQzZmYyOWUwNTZlM2JkZGY4YTlhZGM5OWQyCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpzcmMvYmFja2VuZC9hY2Nlc3MvYnJpbi9icmluLmMgICAgICAgICAgICAgICAgICAgICB8IDE0 NiArKysrKysrKysrKysrKysrKysrKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL2JyaW4vYnJpbl90dXBs ZS5jICAgICAgICAgICAgICAgfCAgMTQgKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL2JyaW5fdHVwbGUu aCAgICAgICAgICAgICAgICAgICAgfCAgIDYgKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlucHJv Z3Jlc3MtaW5zZXJ0aW9uLm91dCAgICAgfCAgIDggKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlu cHJvZ3Jlc3MtaW5zZXJ0aW9uLnNwZWMgICAgfCAgIDEgKwo1IGZpbGVzIGNoYW5nZWQsIDE2NyBp bnNlcnRpb25zKCspLCA4IGRlbGV0aW9ucygtKQoK --===============5271915698413398427==--