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.96) (envelope-from ) id 1vJWH1-009YvN-2w for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Nov 2025 12:17:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJWGz-001JrV-20 for pgsql-bugs@arkaria.postgresql.org; Thu, 13 Nov 2025 12:17:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJVbT-000oDf-0m for pgsql-bugs@lists.postgresql.org; Thu, 13 Nov 2025 11:35:03 +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.96) (envelope-from ) id 1vJUCV-007Vqd-1J for pgsql-bugs@lists.postgresql.org; Thu, 13 Nov 2025 10:05:13 +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=nBILbhly1bllT2YLdMT33mkthivNX1szdfGGvz2xK8o=; b=CMkH9plwyJS0O6mrBNDYuVbob9 +uIwW5QiV1DFARYowVFXki2PLeY0qVTVv/v/DtYOHdHn7k4qAJ5hLFwCVGDk2CqdZR9AvzoZO59sI h7paVrRwXQR/usZmZAP4j92U2Ul5kVvQPb5Srgfz5Lqgn70zUeLvL+y+PN4wBX2CQU6MMFFAz0SPV xZ8i5K6KvNXbh4wkMZgftJf0lcqL3xjPTHZSZCTC06iAQMI+hyGkL7VYOY+TjoGI1X3+nCpRl/EUe G69tdm6R3Ni/WgjVK6qEyQH9ClxjXZ7lvvHtOPkzza2Eu3O7UmBMAFqvbDjYGE/KKMrqxpQKpRQDe UWOGblqg==; 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 1vJUCO-00Duom-Hi for pgsql-bugs@lists.postgresql.org; Thu, 13 Nov 2025 10:05:09 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJUCM-00F3z8-2I for pgsql-bugs@lists.postgresql.org; Thu, 13 Nov 2025 10:05:03 +0000 Content-Type: multipart/mixed; boundary="===============8279942440825593536==" MIME-Version: 1.0 Subject: BUG #19111: Using EXPLAIN ANALYZE with MERGE causes failed assert To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: o.tselebrovskiy@postgrespro.ru Reply-To: o.tselebrovskiy@postgrespro.ru, pgsql-bugs@lists.postgresql.org Date: Thu, 13 Nov 2025 10:04:08 +0000 Message-ID: <19111-5b06624513d301b3@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 --===============8279942440825593536== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTExMQpMb2dnZWQgYnk6ICAgICAgICAgIE9sZWcgVHNlbGVicm92c2tp eQpFbWFpbCBhZGRyZXNzOiAgICAgIG8udHNlbGVicm92c2tpeUBwb3N0Z3Jlc3Byby5ydQpQb3N0 Z3JlU1FMIHZlcnNpb246IDE3LjYKT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjIuMDQKRGVz Y3JpcHRpb246ICAgICAgICAKCk9uIFBvc3RncmVTUUwgMTcrIGlmIHlvdSBkbyB0aGUgZm9sbG93 aW5nOgoKLS0gZmlyc3QgcHNxbAogIENSRUFURSBUQUJMRSB0YXJnZXQgKGtleSBpbnQgcHJpbWFy eSBrZXksIHZhbCB0ZXh0KTsKICBJTlNFUlQgSU5UTyB0YXJnZXQgVkFMVUVTICgxLCAnc2V0dXAx Jyk7CiAgQ1JFQVRFIFRBQkxFIHBhX3RhcmdldCAoa2V5IGludGVnZXIsIHZhbCB0ZXh0KQogICBQ QVJUSVRJT04gQlkgTElTVCAoa2V5KTsKICBDUkVBVEUgVEFCTEUgcGFydDEgKGtleSBpbnRlZ2Vy LCB2YWwgdGV4dCk7CiAgQ1JFQVRFIFRBQkxFIHBhcnQyICh2YWwgdGV4dCwga2V5IGludGVnZXIp OwogIENSRUFURSBUQUJMRSBwYXJ0MyAoa2V5IGludGVnZXIsIHZhbCB0ZXh0KTsKICBBTFRFUiBU QUJMRSBwYV90YXJnZXQgQVRUQUNIIFBBUlRJVElPTiBwYXJ0MSBGT1IgVkFMVUVTIElOICgxLDQp OwogIEFMVEVSIFRBQkxFIHBhX3RhcmdldCBBVFRBQ0ggUEFSVElUSU9OIHBhcnQyIEZPUiBWQUxV RVMgSU4gKDIsNSw2KTsKICBBTFRFUiBUQUJMRSBwYV90YXJnZXQgQVRUQUNIIFBBUlRJVElPTiBw YXJ0MyBERUZBVUxUOwogIElOU0VSVCBJTlRPIHBhX3RhcmdldCBWQUxVRVMgKDEsICdpbml0aWFs Jyk7CiAgSU5TRVJUIElOVE8gcGFfdGFyZ2V0IFZBTFVFUyAoMiwgJ2luaXRpYWwnKTsKICAKICBC RUdJTiBJU09MQVRJT04gTEVWRUwgUkVBRCBDT01NSVRURUQ7CiAgTUVSR0UgSU5UTyB0YXJnZXQg dAogIFVTSU5HIChTRUxFQ1QgMSBhcyBrZXksICdtZXJnZTEnIGFzIHZhbCkgcwogIE9OIHMua2V5 ID0gdC5rZXkKICBXSEVOIE5PVCBNQVRDSEVEIFRIRU4KICBJTlNFUlQgVkFMVUVTIChzLmtleSwg cy52YWwpCiAgV0hFTiBNQVRDSEVEIFRIRU4KICBVUERBVEUgc2V0IGtleSA9IHQua2V5ICsgMSwg dmFsID0gdC52YWwgfHwgJyB1cGRhdGVkIGJ5ICcgfHwgcy52YWw7CgotLSBzZWNvbmQgcHNxbAoK ICAgIEJFR0lOIElTT0xBVElPTiBMRVZFTCBSRUFEIENPTU1JVFRFRDsKICAgIEVYUExBSU4gQU5B TFlaRSBNRVJHRSBJTlRPIHRhcmdldCB0CiAgICBVU0lORyAoU0VMRUNUIDEgYXMga2V5LCAnbWVy Z2UyYScgYXMgdmFsKSBzCiAgICBPTiBzLmtleSA9IHQua2V5CiAgICBXSEVOIE5PVCBNQVRDSEVE IFRIRU4KICAgICAgICBJTlNFUlQgVkFMVUVTIChzLmtleSwgcy52YWwpCiAgICBXSEVOIE1BVENI RUQgVEhFTgogICAgICAgIFVQREFURSBzZXQga2V5ID0gdC5rZXkgKyAxLCB2YWwgPSB0LnZhbCB8 fCAnIHVwZGF0ZWQgYnkgJyB8fCBzLnZhbAogICAgV0hFTiBOT1QgTUFUQ0hFRCBCWSBTT1VSQ0Ug VEhFTgogICAgICAgIFVQREFURSBzZXQga2V5ID0gdC5rZXkgKyAxLCB2YWwgPSB0LnZhbCB8fCAn IHNvdXJjZSBub3QgbWF0Y2hlZCBieQptZXJnZTJhJwogICAgUkVUVVJOSU5HIG1lcmdlX2FjdGlv bigpLCB0Lio7CgotLSBmaXJzdCBwc3FsIGFnYWluCgogIENPTU1JVDsKClRoZW4gdGhlIGJhY2tl bmQgZm9yIHRoZSBzZWNvbmQgcHNxbCBjcmFzaGVzLiBXaXRoIGFzc2VydHMgdHVybmVkIG9uOgoK VFJBUDogZmFpbGVkIEFzc2VydCgic2tpcHBlZF9wYXRoID49IDAiKSwgRmlsZTogImV4cGxhaW4u YyIsIExpbmU6IDQ3MzIsClBJRDogNjY1NTcKcG9zdGdyZXM6IHBvc3RncmVzIHBvc3RncmVzIFts b2NhbF0KRVhQTEFJTihFeGNlcHRpb25hbENvbmRpdGlvbisweGJiKVsweDVjZDgwYzRlYTg4N10K cG9zdGdyZXM6IHBvc3RncmVzIHBvc3RncmVzIFtsb2NhbF0gRVhQTEFJTigrMHgzNGZlYjYpWzB4 NWNkODBiZjEzZWI2XQpwb3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgW2xvY2FsXSBFWFBMQUlO KCsweDM0OWNlYilbMHg1Y2Q4MGJmMGRjZWJdCnBvc3RncmVzOiBwb3N0Z3JlcyBwb3N0Z3JlcyBb bG9jYWxdCkVYUExBSU4oRXhwbGFpblByaW50UGxhbisweDFmNSlbMHg1Y2Q4MGJmMDk4MDRdCnBv c3RncmVzOiBwb3N0Z3JlcyBwb3N0Z3JlcyBbbG9jYWxdCkVYUExBSU4oRXhwbGFpbk9uZVBsYW4r MHg0M2YpWzB4NWNkODBiZjA5MDdkXQpwb3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgW2xvY2Fs XQpFWFBMQUlOKHN0YW5kYXJkX0V4cGxhaW5PbmVRdWVyeSsweDMwZilbMHg1Y2Q4MGJmMDg4NDVd CnBvc3RncmVzOiBwb3N0Z3JlcyBwb3N0Z3JlcyBbbG9jYWxdIEVYUExBSU4oKzB4MzQ0NTMwKVsw eDVjZDgwYmYwODUzMF0KcG9zdGdyZXM6IHBvc3RncmVzIHBvc3RncmVzIFtsb2NhbF0KRVhQTEFJ TihFeHBsYWluUXVlcnkrMHgxNWUpWzB4NWNkODBiZjA4MTk4XQpwb3N0Z3JlczogcG9zdGdyZXMg cG9zdGdyZXMgW2xvY2FsXQpFWFBMQUlOKHN0YW5kYXJkX1Byb2Nlc3NVdGlsaXR5KzB4YThhKVsw eDVjZDgwYzJlYzQ2Ml0KcG9zdGdyZXM6IHBvc3RncmVzIHBvc3RncmVzIFtsb2NhbF0KRVhQTEFJ TihQcm9jZXNzVXRpbGl0eSsweDEzYSlbMHg1Y2Q4MGMyZWI5ZDFdCnBvc3RncmVzOiBwb3N0Z3Jl cyBwb3N0Z3JlcyBbbG9jYWxdIEVYUExBSU4oKzB4NzI2MjhhKVsweDVjZDgwYzJlYTI4YV0KcG9z dGdyZXM6IHBvc3RncmVzIHBvc3RncmVzIFtsb2NhbF0gRVhQTEFJTigrMHg3MjVmYzcpWzB4NWNk ODBjMmU5ZmM3XQpwb3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgW2xvY2FsXSBFWFBMQUlOKFBv cnRhbFJ1bisweDI0OSlbMHg1Y2Q4MGMyZTk4OTBdCnBvc3RncmVzOiBwb3N0Z3JlcyBwb3N0Z3Jl cyBbbG9jYWxdIEVYUExBSU4oKzB4NzFlMDRjKVsweDVjZDgwYzJlMjA0Y10KcG9zdGdyZXM6IHBv c3RncmVzIHBvc3RncmVzIFtsb2NhbF0KRVhQTEFJTihQb3N0Z3Jlc01haW4rMHhiNDMpWzB4NWNk ODBjMmU3ODQzXQpwb3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgW2xvY2FsXSBFWFBMQUlOKCsw eDcxOTUyNSlbMHg1Y2Q4MGMyZGQ1MjVdCnBvc3RncmVzOiBwb3N0Z3JlcyBwb3N0Z3JlcyBbbG9j YWxdCkVYUExBSU4ocG9zdG1hc3Rlcl9jaGlsZF9sYXVuY2grMHgxNzQpWzB4NWNkODBjMWQ4Njc2 XQpwb3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgW2xvY2FsXSBFWFBMQUlOKCsweDYxYjFkNylb MHg1Y2Q4MGMxZGYxZDddCnBvc3RncmVzOiBwb3N0Z3JlcyBwb3N0Z3JlcyBbbG9jYWxdIEVYUExB SU4oKzB4NjE4NmNkKVsweDVjZDgwYzFkYzZjZF0KcG9zdGdyZXM6IHBvc3RncmVzIHBvc3RncmVz IFtsb2NhbF0KRVhQTEFJTihQb3N0bWFzdGVyTWFpbisweDE1OWUpWzB4NWNkODBjMWRiZjk3XQpw b3N0Z3JlczogcG9zdGdyZXMgcG9zdGdyZXMgW2xvY2FsXSBFWFBMQUlOKG1haW4rMHgzOGMpWzB4 NWNkODBjMDcyY2NhXQovbGliL3g4Nl82NC1saW51eC1nbnUvbGliYy5zby42KCsweDI5ZDkwKVsw eDc3YzI4NzgyOWQ5MF0KL2xpYi94ODZfNjQtbGludXgtZ251L2xpYmMuc28uNihfX2xpYmNfc3Rh cnRfbWFpbisweDgwKVsweDc3YzI4NzgyOWU0MF0KcG9zdGdyZXM6IHBvc3RncmVzIHBvc3RncmVz IFtsb2NhbF0gRVhQTEFJTihfc3RhcnQrMHgyNSlbMHg1Y2Q4MGJjYWEyYzVdCgo= --===============8279942440825593536==--