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 1urxnb-00FJhu-16 for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Aug 2025 12:01:44 +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 1urxnY-009Lkj-JA for pgsql-bugs@arkaria.postgresql.org; Fri, 29 Aug 2025 12:01:41 +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 1urxSj-009H7w-Sa for pgsql-bugs@lists.postgresql.org; Fri, 29 Aug 2025 11:40:10 +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 1urxSh-002ME2-0o for pgsql-bugs@lists.postgresql.org; Fri, 29 Aug 2025 11:40:09 +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=Mwr0he+cSLWJb48C+La+f9AgojVsnoRMk2b0DQTAPjw=; b=NyXt2VjqtaD8cYOxPhXYTJHiqh Co88nT+co4UongUE7UNfXmpTxeuUjAr/8zWOwYGDuLNhJYhFMkvscUkc/3QHGyxeyd7npgGUwVh0F 31vusTkg2RYEAjjk7hYFffQhDx8UIHvlibuk/ltaH8Hm4oA4Y0izwmhBVfoQWW3H7t3ZjLKukeuVJ bVJ1La2/zZ18sJV6T6b1CuE/1Omr20AyA6sG02bU5dCQsryefJrl2vbQtYr6YzZz5DAo9JT+m8/pw ki+FvFx5xRENVoCb+zWTPW82gC8DIEuxEwGaFl2GEIwH3fPFsbtBQ2DU9RjDm4cjy3pGeRbAUH/M+ wXtZ1sIg==; 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 1urxSf-006SVk-BB for pgsql-bugs@lists.postgresql.org; Fri, 29 Aug 2025 11:40:07 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1urxSd-00DSCi-1Y for pgsql-bugs@lists.postgresql.org; Fri, 29 Aug 2025 11:40:03 +0000 Content-Type: multipart/mixed; boundary="===============8245548046280815156==" MIME-Version: 1.0 Subject: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: 798604270@qq.com Reply-To: 798604270@qq.com, pgsql-bugs@lists.postgresql.org Date: Fri, 29 Aug 2025 11:39:42 +0000 Message-ID: <19036-ef3954ff85feefe2@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 --===============8245548046280815156== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTAzNgpMb2dnZWQgYnk6ICAgICAgICAgIENoaSBaaGFuZwpFbWFpbCBh ZGRyZXNzOiAgICAgIDc5ODYwNDI3MEBxcS5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxNy41Ck9w ZXJhdGluZyBzeXN0ZW06ICAgdWJ1bnR1IDI0LjA0IHdpdGggZG9ja2VyCkRlc2NyaXB0aW9uOiAg ICAgICAgCgpIaSwKCkluIHRoZSBmb2xsb3dpbmcgdGVzdCBjYXNlLCB0aGUgYEVYRUNVVEVgIHN0 YXRlbWVudCB3aWxsIGZhaWwgd2l0aCBhbiBlcnJvcgpgcmVzdWx0IG9mIHJhbmdlIHVuaW9uIHdv dWxkIG5vdCBiZSBjb250aWd1b3VzYC4gVGhlIGZpbmFsIFNFTEVDVCBxdWVyeQpzaG91bGQgcmV0 dXJuIDEgcm93IGFzIHRoZXJlIGlzIG9ubHkgb25lIHZhbHVlIGAxYCBpbiAgdDEuYzAgYW5kIG9u bHkgb25lCnZhbHVlIGAxYCBpbiB0My5jMCwgaG93ZXZlciwgdGhlIHF1ZXJ5IHJldHVybnMgMCBy b3dzLgoKYGBgClNFVCBwbGFuX2NhY2hlX21vZGUgPSBmb3JjZV9nZW5lcmljX3BsYW47CkNSRUFU RSBUQUJMRSB0MShjMCBSRUFMKTsKQ1JFQVRFIFRBQkxFIHQzKGMwIGJpZ3NlcmlhbCwgYzEgaW50 NHJhbmdlKTsKUFJFUEFSRSBwcmVwYXJlX3F1ZXJ5IChpbnQ0cmFuZ2UsIGludDRyYW5nZSwgaW50 NHJhbmdlLCBpbnQ0cmFuZ2UsCmludDRyYW5nZSwgaW50NHJhbmdlLCBpbnQ0cmFuZ2UsIGludDRy YW5nZSwgaW50NHJhbmdlLCBpbnQ0cmFuZ2UsIGludDRyYW5nZSwKaW50NHJhbmdlLCBpbnQ0cmFu Z2UsIGludDRyYW5nZSwgaW50NHJhbmdlLCBpbnQ0cmFuZ2UsIGludDRyYW5nZSkgQVMgSU5TRVJU CklOVE8gdDMoYzEpIFZBTFVFUygoKHJhbmdlX21lcmdlKCgoKCgkMyktKCQ0KSkpKigkNSkpLAoo KCgoJDYpKygkNykpKS0oKCgkOCktKCQ5KSkpKSkpLSgoKCgoKCgkMTApLSgkMTEpKSktKCgoJDEy KSooJDEzKSkpKSkqKCgoKCgkMTQpKigkMTUpKSkrKCgoJDE2KS0oJDE3KSkpKSkpKSkpOwpFWEVD VVRFIHByZXBhcmVfcXVlcnkoJygtNTU2OTMxODIzLDEyNzY3Nzc4MTMpJzo6aW50NHJhbmdlLAon KC01NzEyMDI2NjIsMTM4MjI3NTI0OV0nOjppbnQ0cmFuZ2UsICdbNTA3MjQzNzcyLDE5NzkyMjY4 MDUpJzo6aW50NHJhbmdlLAonKC04ODY2NzM0NTgsLTg4NjY3MzQ1OF0nOjppbnQ0cmFuZ2UsICdb LTYwMjE5MDQ1MCwtNTcxMjAyNjYyXSc6OmludDRyYW5nZSwKJygtMTE3OTExNTE4MSwtOTk0ODE2 NDY3XSc6OmludDRyYW5nZSwKJ1stMTMyNDQ4MzYyNywtNjE3MTk1NjczXSc6OmludDRyYW5nZSwg JygtMTkyMDQ4ODc5NiwzNjIzNjczMTVdJzo6aW50NHJhbmdlLAonKC0xOTIwNDg4Nzk2LC05NzQx NTkxMTJdJzo6aW50NHJhbmdlLCAnKC0xNTExNjE2OTg2LDMwOTI2NjgzNiknOjppbnQ0cmFuZ2Us CidbMjY0MjkyMTYzLDIwMjk1MTI3MjRdJzo6aW50NHJhbmdlLCAnKC0xMjM1OTM0NDM1LC0yNzQ4 NTAxODZdJzo6aW50NHJhbmdlLAonWzUxMDMxNTY4NiwxMTIxMzIwNDY5KSc6OmludDRyYW5nZSwg Jyg1MjA3MjQyNSwxNTQzMTg1NjY0KSc6OmludDRyYW5nZSwKJ1sxMzEyMDgzOCwxOTYwNzIzNDU2 XSc6OmludDRyYW5nZSwgJ1stMTI0MDAxMzc4MiwtMzk1MDE2ODE2XSc6OmludDRyYW5nZSwKJygx MTUxNzY2MDg5LDIxMDY5MTg2NDcpJzo6aW50NHJhbmdlKTsKREVBTExPQ0FURSBwcmVwYXJlX3F1 ZXJ5OwpJTlNFUlQgSU5UTyB0MShjMCkgVkFMVUVTKENBU1QoQ0FTVCgxIEFTIElOVCkgQVMgSU5U KSk7CklOU0VSVCBJTlRPIHQzKGMxKSBWQUxVRVMoJ1stNzYxODE4NDAzLDc5MzczMTYxMV0nOjpp bnQ0cmFuZ2UpOwpTRUxFQ1QgdDEuYzAgRlJPTSB0MywgdDEgV0hFUkUgKENBU1QodDEuYzAgQVMg SU5UKSkgSU4gKHQzLmMwKTsKYGBgCgpJZiB5b3UgcmVtb3ZlIHRoZSBgU0VUIHBsYW5fY2FjaGVf bW9kZSA9IGZvcmNlX2dlbmVyaWNfcGxhbjtgIG9wdGlvbiBvciB0aGUKcHJlcGFyZWQgc3RhdGVt ZW50LCB0aGUgcXVlcnkgd2lsbCByZXR1cm4gY29ycmVjdCByZXN1bHQuCgo= --===============8245548046280815156==--