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 1pznFC-0005yn-Qs for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:41:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pznFB-0007h6-L9 for pgsql-committers@arkaria.postgresql.org; Thu, 18 May 2023 23:41:13 +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 1pznFB-0007gx-CT for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:13 +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 1pznF3-000ZbQ-56 for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:12 +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=tBi0XXz6LZQRmBMP11kC+RqEDGd0vtl5iSDapQiRKvU=; b=RVojjz/xcCi0C/Ioc5wAHimNOe 3bABu3Cfyxn2BGDd0g5+fbBfB/vo90cwJuaXtQQKn5l2PKxzzxgr+M8tZI6SeTjNGwVzXPg0072ZW vXdkkRwG/zlbBmsIXd+9kO44pzQOIaeD3r+qtlXQy99CBTndIZVGg+6r8M8ApBiY8cWi3486RINdn MIFrjfHkxPkSO/DiG4U5z0mtXvs4vtKcUBR1g3A4lI/wFA10zneW/ioG0SgRQBWkxu33EsP74IxDY cpVyvOQ+MlKECSxZKmmsb+RgdEKSm64SikEcK82U4N6z/DXgBuAcTa77QgpxGJEyFmvvdIJkiyusP 8mCcr8EQ==; 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 1pznF2-0006sX-LL for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:04 +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 1pznF2-000ZuP-8x for pgsql-committers@lists.postgresql.org; Thu, 18 May 2023 23:41:03 +0000 Content-Type: multipart/mixed; boundary="===============4772189869905256995==" 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:03 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4772189869905256995== 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 ZXJwcmlzZWRiLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRw czovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzM1ODFjYmRjZDY0ZjVhY2ViNDQ1 ZjYwZGYyMzE0MWQwOGVkNTA2MTcKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9i YWNrZW5kL2FjY2Vzcy9icmluL2JyaW4uYyAgICAgICAgICAgICAgICAgICAgIHwgMTEzICsrKysr KysrKysrKysrKysrKysrLQpzcmMvYmFja2VuZC9hY2Nlc3MvYnJpbi9icmluX3R1cGxlLmMgICAg ICAgICAgICAgICB8ICAxNCArKy0Kc3JjL2luY2x1ZGUvYWNjZXNzL2JyaW5fdHVwbGUuaCAgICAg ICAgICAgICAgICAgICAgfCAgIDYgKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlucHJvZ3Jlc3Mt aW5zZXJ0aW9uLm91dCAgICAgfCAgIDggKy0KLi4uL3N1bW1hcml6YXRpb24tYW5kLWlucHJvZ3Jl c3MtaW5zZXJ0aW9uLnNwZWMgICAgfCAgIDEgKwo1IGZpbGVzIGNoYW5nZWQsIDEzNCBpbnNlcnRp b25zKCspLCA4IGRlbGV0aW9ucygtKQoK --===============4772189869905256995==--