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 1v8XHv-002Orf-L9 for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Oct 2025 05:09:31 +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 1v8XHt-00AOFu-EK for pgsql-bugs@arkaria.postgresql.org; Tue, 14 Oct 2025 05:09:30 +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.94.2) (envelope-from ) id 1v8WCw-00A6bK-FD for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 04:00:19 +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 1v8WCp-00236I-0X for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 04:00:19 +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=taLP9tqPWHoc18fHXMaKdgSLah6PFCdxUBdvMrOmeMo=; b=QTAH57LXO1nxaL7og+NrcXDw05 I3G2HnIuZk6Lg8AK7YGiMcUNEx1Sr5h5DuQo8kz7eNd/EwQXiEd5cenUaGsoGxXgZ1b0ZL7NaDerG QodU8NPhdxKdvAdUiIO9vbEmG77QKhS8TFdI6/A10ST5eZMsWlbFc1GFh6yf27pV2MozE7lgbfuKK gOEti4mxsTEUqDPqaMX9bignFuVUtfavxzTEm0RaNxSsaq+i0Z6aO2DVNlDL6+m2gLpVw1Np+P8ae afiQSmflI9M2+JIVDG+JqoBdEmta8owPU6Eo0CXQ7UsrjTjReG+JrN4K/LE8m+aQYgQrQOubHqVng 5w0gsJuQ==; 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 1v8WCk-004WxJ-TT for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 04:00: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 1v8WCi-00Glrc-1q for pgsql-bugs@lists.postgresql.org; Tue, 14 Oct 2025 04:00:04 +0000 Content-Type: multipart/mixed; boundary="===============5951890625479167270==" MIME-Version: 1.0 Subject: BUG #19085: Using EXECUTE to run a multi-statement SQL string causes an assertion failure To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: wangsiyan2@huawei.com Reply-To: wangsiyan2@huawei.com, pgsql-bugs@lists.postgresql.org Date: Tue, 14 Oct 2025 03:59:49 +0000 Message-ID: <19085-3e215c0d39d3f674@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 --===============5951890625479167270== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA4NQpMb2dnZWQgYnk6ICAgICAgICAgIHNpeWFuIHdhbmcKRW1haWwg YWRkcmVzczogICAgICB3YW5nc2l5YW4yQGh1YXdlaS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAx OC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgY2VudG9zIDcuNQpEZXNjcmlwdGlvbjogICAgICAgIAoK VGhlIGlzc3VlIGlzIHRyaWdnZXJlZCBieSBhIFBML3BnU1FMIHByb2NlZHVyZSB0aGF0IGR5bmFt aWNhbGx5IGV4ZWN1dGVzIGEKbXVsdGktc3RhdGVtZW50IFNRTCBzdHJpbmcgdmlhIEVYRUNVVEUs IGNvbWJpbmluZyBERUNMQVJFIENVUlNPUiBhbmQgRkVUQ0gKKGUuZy4sICJERUNMQVJFIHRlc3Rf Y3Vyc29yXzFfMSBDVVJTT1IgRk9SIFNFTEVDVCAqIEZST00gdGVzdF90YWJsZV8xOyBGRVRDSAoy MDAgRlJPTSB0ZXN0X2N1cnNvcl8xXzEiKS4gVGhpcyBmYWlscyB3aXRoCkFzc2VydChBY3RpdmVT bmFwc2hvdC0+YXNfc25hcC0+cmVnZF9jb3VudCA9PSAwKSBpbiBzbmFwbWdyLmM6NzU0IGJlY2F1 c2UKdGhlIHNuYXBzaG90J3MgcmVnaXN0cmF0aW9uIGNvdW50IChyZWdkX2NvdW50KSByZWFjaGVz IDIgZHVyaW5nIFNQSSdzCm11bHRpLXN0YXRlbWVudCBwcm9jZXNzaW5nIGxvb3AuCgpSZXByb2R1 Y3Rpb24gU3RlcHMKMS4gQ3JlYXRlIGEgc2VxdWVuY2UgKHRlc3RfY3Vyc29yX3NlcSkgYW5kIHRh Ymxlcy4KQ1JFQVRFIE9SIFJFUExBQ0UgUFJPQ0VEVVJFIGNyZWF0ZV9tYXNzX3RhYmxlcyhudW1f dGFibGVzIElOVCkKTEFOR1VBR0UgcGxwZ3NxbApBUyAkJApERUNMQVJFCiAgICB0YWJsZV9uYW1l IHRleHQ7CiAgICBzZXFfbnVtIGludDsKQkVHSU4KICAgIElGIG51bV90YWJsZXMgPD0gMCBUSEVO CiAgICAgICAgUkFJU0UgRVhDRVBUSU9OICdOdW1iZXIgb2YgdGFibGVzIG11c3QgYmUgYSBwb3Np dGl2ZSBpbnRlZ2VyJzsKICAgIEVORCBJRjsKCiAgICBEUk9QIFNFUVVFTkNFIElGIEVYSVNUUyB0 ZXN0X3RhYmxlX3NlcTsKICAgIENSRUFURSBTRVFVRU5DRSB0ZXN0X3RhYmxlX3NlcSBTVEFSVCAx OwoKICAgIEZPUiBpIElOIDEuLm51bV90YWJsZXMgTE9PUAogICAgICAgIHNlcV9udW0gOj0gbmV4 dHZhbCgndGVzdF90YWJsZV9zZXEnKTsKICAgICAgICB0YWJsZV9uYW1lIDo9IGZvcm1hdCgndGVz dF90YWJsZV8lcycsIHNlcV9udW0pOwoKICAgICAgICBFWEVDVVRFIGZvcm1hdCgnCiAgICAgICAg ICAgIENSRUFURSBUQUJMRSBJRiBOT1QgRVhJU1RTICVJICgKICAgICAgICAgICAgICAgIGlkIGlu dCwKICAgICAgICAgICAgICAgIGRhdGEgVEVYVAogICAgICAgICAgICApOyBJTlNFUlQgSU5UTyAl SQpWQUxVRVMoZ2VuZXJhdGVfc2VyaWVzKDEsMzIwMCksJydhU2Rld3FFMTJkU2hhaktkYURzQWQz X3dyJycpOycsIHRhYmxlX25hbWUsCnRhYmxlX25hbWUpOwoKICAgICAgICBJRiBpICUgMTAwMCA9 IDAgVEhFTgogICAgICAgICAgICBSQUlTRSBOT1RJQ0UgJ1Byb2dyZXNzOiBDcmVhdGVkICUvJSB0 YWJsZXMnLCBpLCBudW1fdGFibGVzOwogICAgICAgIEVORCBJRjsKICAgIEVORCBMT09QOwoKICAg IFJBSVNFIE5PVElDRSAnQ29tcGxldGVkOiAlIHRhYmxlcyBjcmVhdGVkJywgbnVtX3RhYmxlczsK RU5EOwokJDsKMi4gRGVmaW5lIHRoZSBwcm9jZWR1cmUgb3Blbl9tdWx0aWN1cnNvcnMgKGFzIHNo b3duIGluIHVzZXIgaW5wdXQpLCB3aGljaAp1c2VzIEVYRUNVVEUgdG8gcnVuIGEgbXVsdGktc3Rh dGVtZW50IGN1cnNvciBjcmVhdGlvbiBhbmQgZmV0Y2guCkNSRUFURSBTRVFVRU5DRSB0ZXN0X2N1 cnNvcl9zZXEgU1RBUlQgMTsKCkNSRUFURSBPUiBSRVBMQUNFIFBST0NFRFVSRSBvcGVuX211bHRp Y3Vyc29ycyhjdXJzb3JfbnVtIGludGVnZXIpCkxBTkdVQUdFIHBscGdzcWwKQVMgJCQKREVDTEFS RQogICAgc2VxX251bSBpbnQ7CiAgICBjdXJzb3JfbmFtZSB0ZXh0OwogICAgdGFyZ2V0X3RhYmxl IHRleHQ7CiAgICBpIGludGVnZXI7CiAgICBvIGludGVnZXI7CkJFR0lOCgogICAgRk9SIGkgSU4g MS4uY3Vyc29yX251bSBMT09QCiAgICAgICAgc2VxX251bSA6PSBuZXh0dmFsKCd0ZXN0X2N1cnNv cl9zZXEnKTsKICAgICAgICB0YXJnZXRfdGFibGUgOj0gJ3Rlc3RfdGFibGVfJyB8fCBzZXFfbnVt OwogICAgICAgIGN1cnNvcl9uYW1lIDo9ICd0ZXN0X2N1cnNvcl8nIHx8IHNlcV9udW0gfHwgJ18x JzsKICAgICAgICBFWEVDVVRFIGZvcm1hdCgnREVDTEFSRSAlSSBDVVJTT1IgRk9SIFNFTEVDVCAq IEZST00gJUknLApjdXJzb3JfbmFtZSwgdGFyZ2V0X3RhYmxlKTsKICAgICAgICAgICAgICAgIEVY RUNVVEUgZm9ybWF0KCdGRVRDSCAyMDAgRlJPTSAlSScsIGN1cnNvcl9uYW1lKTsKICAgIEVORCBM T09QOwoKICAgIFBFUkZPUk0gcGdfc2xlZXAoMTgwMDAwKTsKCkVYQ0VQVElPTgogICAgV0hFTiBv dGhlcnMgVEhFTgogICAgICAgIFJPTExCQUNLOwogICAgICAgIFJBSVNFOwpFTkQ7CiQkOwozLiBF eGVjdXRlICdDQUxMIGNyZWF0ZV9tYXNzX3RhYmxlcygxMCk7Jwo0LiBFeGVjdXRlICdDQUxMIG9w ZW5fbXVsdGljdXJzb3JzKDEpOycKNS4gT2JzZXJ2ZSB0aGUgYXNzZXJ0aW9uIGZhaWx1cmU6IFRS QVA6IGZhaWxlZApBc3NlcnQoIkFjdGl2ZVNuYXBzaG90LT5hc19zbmFwLT5yZWdkX2NvdW50ID09 IDAiKSwgd2l0aCBzZXJ2ZXIgYWJvcnQKKHNpZ25hbCA2KS4KCkdEQiBPYnNlcnZhdGlvbnMKMS4g Rmlyc3QgVXBkYXRlQWN0aXZlU25hcHNob3RDb21tYW5kSWQoZm9yIENBTEwgY3JlYXRlX21hc3Nf dGFibGVzKSBoYXMKcmVnZF9jb3VudD0wLgoyLiBTZWNvbmQgVXBkYXRlQWN0aXZlU25hcHNob3RD b21tYW5kSWQoZm9yIENBTEwgb3Blbl9tdWx0aWN1cnNvcnMpIGhhcwpyZWdkX2NvdW50PTIsIHRy aWdnZXJpbmcgdGhlIGZhaWx1cmUgaW4gVXBkYXRlQWN0aXZlU25hcHNob3RDb21tYW5kSWQuCgpJ IGd1ZXNzIHRoaXMgcHJvYmxlbSBpcyBiZWNhdXNlIFNQSSBwcm9jZXNzZXMgbXVsdGktc3RhdGVt ZW50IEVYRUNVVEUgYXMgYQpzaW5nbGUgcGxhbiwgbG9vcGluZyBvdmVyIHN1Yi1zdGF0ZW1lbnRz LiBERUNMQVJFIENVUlNPUiByZWdpc3RlcnMgYQpzbmFwc2hvdCBmb3IgY3Vyc29yIHN0YWJpbGl0 eSwgYW5kIEZFVENIIG1heSBpbmNyZW1lbnQgcmVnZF9jb3VudCBhZ2Fpbi4gVGhlCnN1YnNlcXVl bnQgQ0lEIHVwZGF0ZSBmYWlscyB0aGUgYXNzZXJ0aW9uLCBhcyByZWdpc3RlcmVkIHNuYXBzaG90 cyBzaG91bGQgYmUKaW1tdXRhYmxlLgpCZWNhc3VlIHdoZW4gSSBjaGFuZ2VkIG9wZW5fbXVsdGlj dXJzb3JzIGFzIGZvbGxvd2luZywgdGhlIGVycm9yIGlzCmRpc2FwcGVhcmVkLgpDUkVBVEUgT1Ig UkVQTEFDRSBQUk9DRURVUkUgb3Blbl9tdWx0aWN1cnNvcnMoY3Vyc29yX251bSBpbnRlZ2VyKQpM QU5HVUFHRSBwbHBnc3FsCkFTICQkCkRFQ0xBUkUKICAgIHNlcV9udW0gaW50OwogICAgY3Vyc29y X25hbWUgdGV4dDsKICAgIHRhcmdldF90YWJsZSB0ZXh0OwogICAgaSBpbnRlZ2VyOwogICAgbyBp bnRlZ2VyOwpCRUdJTgoKICAgIEZPUiBpIElOIDEuLmN1cnNvcl9udW0gTE9PUAogICAgICAgIHNl cV9udW0gOj0gbmV4dHZhbCgndGVzdF9jdXJzb3Jfc2VxJyk7CiAgICAgICAgdGFyZ2V0X3RhYmxl IDo9ICd0ZXN0X3RhYmxlXycgfHwgc2VxX251bTsKICAgICAgICBjdXJzb3JfbmFtZSA6PSAndGVz dF9jdXJzb3JfJyB8fCBzZXFfbnVtIHx8ICdfMSc7CiAgICAgICAgRVhFQ1VURSBmb3JtYXQoJ0RF Q0xBUkUgJUkgQ1VSU09SIEZPUiBTRUxFQ1QgKiBGUk9NICVJJywKY3Vyc29yX25hbWUsIHRhcmdl dF90YWJsZSk7CiAgICAgICAgICAgICAgICBFWEVDVVRFIGZvcm1hdCgnRkVUQ0ggMjAwIEZST00g JUknLCBjdXJzb3JfbmFtZSk7CiAgICBFTkQgTE9PUDsKCiAgICBQRVJGT1JNIHBnX3NsZWVwKDE4 MDAwMCk7CgpFWENFUFRJT04KICAgIFdIRU4gb3RoZXJzIFRIRU4KICAgICAgICBST0xMQkFDSzsK ICAgICAgICBSQUlTRTsKRU5EOwokJDsKCk15IHF1ZXN0aW9uIGlzOgoxLiBJZiBhc3NlcnRpb25z IGFyZSBkaXNhYmxlZCAocHJvZHVjdGlvbiksIG1vZGlmeWluZyBhIHJlZ2lzdGVyZWQKc25hcHNo b3QncyAgQ0lEIGNvdWxkIGNhdXNlIHZpc2liaWxpdHkgaXNzdWVzLCB3aWxsIGl0IHZpb2xhdGlu ZwpyZWFkLWNvbW1pdHRlZCBpc29sYXRpb24/CjIuIFR5cGljYWxseSwgRVhFQ1VURSBkb2VzIG5v dCBleGVjdXRlIG11bHRpcGxlIHN0YXRlbWVudHMuIFNob3VsZCB3ZQpwcm9oaWJpdCBleGVjdXRp bmcgbXVsdGlwbGUgU1FMIHN0YXRlbWVudHMgd2l0aGluIEVYRUNVVEUsIG9yIHNob3VsZCB3ZQpt b2RpZnkgdGhlIGFzc2VydD8KClRoaXMgYnVnLCByZXByb2R1Y2libGUgaW4gUG9zdGdyZVNRTCAx OC4wIGFuZCBlYXJsaWVyLgoK --===============5951890625479167270==--