Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tn5EQ-001sPP-Nj for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Feb 2025 00:24:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tn5EO-00BVml-Fe for pgsql-bugs@arkaria.postgresql.org; Wed, 26 Feb 2025 00:24:56 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tn3MS-009rIq-6w for pgsql-bugs@lists.postgresql.org; Tue, 25 Feb 2025 22:25:08 +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.96) (envelope-from ) id 1tn3MN-0004gY-1k for pgsql-bugs@lists.postgresql.org; Tue, 25 Feb 2025 22:25:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=1KgUD1xKV/MbKSn0robGTcb5L5baiLHzLmOUxLfbDGc=; b=oJkJo+G10H04vWgyzBI0ftPmbD Ju5yd95LNUkWZxPXwXKdMMappHBz5GvpbMFaMXzsu/siWSVGZOZ4q7PBgTNlThaQfDV7ajJiVZNKP 8CHOHIvQoTLJjb2N48atk6r2G6p5ssKzlw98ZlTcbefXX2z5deyXjFOZ45M/+H2l33DVWoEZlN6wd 6EBVMxEf2YszXhS0Fsqnf4OhQ/gvfUw9P2tsCpA4B/Mjsr7kpNYa+xjuLSSUuN2OBMldrrMbB1HCN hoPP3yxP8t8MY9Yb984m7lv/gchmLjn/BY7wh94pLu2MO+T1fJCZ2swZsQ/wHkDGoIzeOEWE9y9tz xRmYOTOg==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tn3MN-000AuP-Lv for pgsql-bugs@lists.postgresql.org; Tue, 25 Feb 2025 22:25:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tn3MM-008iAq-Av for pgsql-bugs@lists.postgresql.org; Tue, 25 Feb 2025 22:25:02 +0000 Content-Type: multipart/mixed; boundary="===============0443139579328421275==" MIME-Version: 1.0 Subject: BUG #18825: Row value equality predicates do not use indices To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: nico@cryptonector.com Reply-To: nico@cryptonector.com, pgsql-bugs@lists.postgresql.org Date: Tue, 25 Feb 2025 22:24:36 +0000 Message-ID: <18825-5c25a6ba19fa6549@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0443139579328421275== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODgyNQpMb2dnZWQgYnk6ICAgICAgICAgIE5pY29sYXMgV2lsbGlhbXMK RW1haWwgYWRkcmVzczogICAgICBuaWNvQGNyeXB0b25lY3Rvci5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMy4xMQpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAg CgpERUxFVEUgRlJPTSBmb28gVVNJTkcgKFNFTEVDVCBkZWxzIEZST00gZGVscykgQVMgZGVscw0K V0hFUkUgZm9vID0gZGVsczsgLS0gPC0tLSBkb2VzIG5vdCB1c2UgaW5kaWNlcyBvbiBlaXRoZXIg dGFibGUNCg0KREVMRVRFIEZST00gZm9vIFVTSU5HIChTRUxFQ1QgZGVscyBGUk9NIGRlbHMpIEFT IGRlbHMNCldIRVJFIGZvby5hID0gKGRlbHMpLmEgQU5EIGZvby5iID0gKGRlbHMpLmI7IC0tIEFO RCBzbyBvbjsgdGhpcyBkb2VzIHVzZQppbmRpY2VzDQoNCkkgY2FuIGNyZWF0ZSBpbmRpY2VzIG9u IHJvdyB2YWx1ZXMsIGJ1dCB0aGV5IGRvbid0IGdldCB1c2VkOg0KDQpDUkVBVEUgSU5ERVggZm9v X2lkeCBPTiBmb28gKChmb28pKTsgLS0gbG9va3MgbGlrZSBhbiBpbmRleCBvbiB0aGUgZnVsbCBy b3cKdmFsdWVzLg0KDQooSW5jaWRlbnRhbGx5LCB0aGVyZSBhcmUgbm8gTlVMTHMgaW4gdGhlc2Ug dGFibGVzLikNCg0KQmFzaWNhbGx5IEknZCBleHBlY3QgdGhhdCBzaW5jZSBJIGNhbiB3cml0ZSBx dWVyaWVzIHRoYXQgdGFrZSBhZHZhbnRhZ2Ugb2YKcm93IHZhbHVlcyB0byBiZSBzaW1wbGVyLCBz aG9ydGVyLCBlYXNpZXIgdG8gcmVhZCwgYW5kIHRvIGdlbmVyYXRlLCBsaWtlOg0KDQpTRUxFQ1Qg bGZ0LCByZ2h0DQpGUk9NIGZvbw0KTkFUVVJBTCBGVUxMIE9VVEVSIEpPSU4gYmFyDQpXSEVSRSAo bGZ0IElTIERJU1RJTkNUIEZST00gTlVMTCBBTkQgcmdodCBJUyBOT1QgRElTVElOQ1QgRlJPTSBO VUxMKSBPUg0KICAgICAobGZ0IElTIE5PVCBESVNUSU5DVCBGUk9NIE5VTEwgQU5EIHJnaHQgSVMg RElTVElOQ1QgRlJPTSBOVUxMKTsNCg0Kd2hpY2ggZG9lcyB1c2UgaW5kaWNlcywgYnV0IHRoYXQn cyBiZWNhdXNlIHRoZSBOQVRVUkFMIEpPSU4gaXNuJ3QgbG9va2luZyBhdApyb3cgdmFsdWVzIGV4 YWN0bHkgYnV0IHJhdGhlciBpdCBleHBhbmRzIHRvIGJlIHRoZSBlcXVpdmFsZW50IG9mDQoNClNF TEVDVCBsZnQsIHJnaHQNCkZST00gZm9vDQpGVUxMIE9VVEVSIEpPSU4gYmFyIFVTSU5HIChhLCBi LCAuLiwgeikNCldIRVJFIChsZnQgSVMgRElTVElOQ1QgRlJPTSBOVUxMIEFORCByZ2h0IElTIE5P VCBESVNUSU5DVCBGUk9NIE5VTEwpIE9SDQogICAgIChsZnQgSVMgTk9UIERJU1RJTkNUIEZST00g TlVMTCBBTkQgcmdodCBJUyBESVNUSU5DVCBGUk9NIE5VTEwpOw0KDQpTbyBpdCBzZWVtcyBsaWtl IHRoZXJlIGlzIGEgbWlzc2luZyBmZWF0dXJlIHdoZXJlIHJvdyBlcXVhbGl0eSBwcmVkaWNhdGVz CmNvdWxkIGJlIGRlc3VnYXJlZCBpbnRvIGEgY29uanVuY3Rpb24gb2YgY29sdW1uIGVxdWFsaXR5 IHByZWRpY2F0ZXMgb24gdGhvc2UKdmFsdWVzLCBub3QgdW5saWtlIE5BVFVSQUwgSk9JTiBkZXN1 Z2FyaW5nIGludG8gSk9JTiAuLiBVU0lORyAoPGNvbW1vbgpjb2x1bW4gbGlzdD4pLCBhbmQgSk9J TiAuLiBVU0lORyAoPGNvbW1vbiBjb2x1bW4gbGlzdD4pIGRlc3VnYXJpbmcgaW50byBKT0lOCk9O IDxjb25qdW5jdGlvbiBvZiBjb2x1bW4gZXF1YWxpdHkgcHJlZGljYXRlcyBmb3IgYWxsIGNvbHVt bnMgaW4gY29tbW9uPiwKdGhlbiByb3cgZXF1YWxpdHkgcHJlZGljYXRlcyB3b3VsZCBuYXR1cmFs bHkgYmUgYWJsZSB0byB1c2UgaW5kaWNlcy4gCkFsdGVybmF0aXZlbHksIGlmIHJvdyBlcXVhbGl0 eSBwcmVkaWNhdGVzIGNvdWxkIHVzZSBpbmRpY2VzIG9uIHJvdyB2YWx1ZQpleHByZXNzaW9ucywg dGhhdCB3b3VsZCBhbHNvIGhlbHAsIHRob3VnaCB0aGlzIHNlZW1zIGEgYml0IHNpbGx5IHNpbmNl IHRoZQpjb21iaW5hdGlvbiBvZiBhbiBpbmRleCBhbmQgdGhlIHRhYmxlIGl0IGluZGV4ZXMgc2hv dWxkIGZ1bmN0aW9uIGFzICJyb3cKaW5kZXgiLCBhbmQgd2FzdGluZyBtb3JlIHNwYWNlIGFuZCB0 aW1lIHVwZGF0aW5nIG1vcmUgaW5kaWNlcyB0aGF0IHNob3VsZG4ndApyZWFsbHkgYmUgbmVjZXNz YXJ5IHNlZW1zIGNvdW50ZXItcHJvZHVjdGl2ZSAodGhvdWdoIG9uIHRoZSBwbHVzIHNpZGUgdGhl cmUKc2hvdWxkIGJlIG9ubHkgb25lIGluZGV4IHBlciB0YWJsZSBzb3VyY2UgaW4gcm93IHZhbHVl IGVxdWFsaXR5IHByZWRpY2F0ZXMKd2l0aCB0aGlzIGFwcHJvYWNoLCB3aGljaCBpcyBlYXNpZXIg b24gdGhlIHBsYW5uZXIhKS4KCg== --===============0443139579328421275==--