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 1v55p2-001F6O-AQ for pgsql-bugs@arkaria.postgresql.org; Sat, 04 Oct 2025 17:13:29 +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 1v55nz-000Xxr-Vs for pgsql-bugs@arkaria.postgresql.org; Sat, 04 Oct 2025 17:12:24 +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 1v55UP-000WWz-UH for pgsql-bugs@lists.postgresql.org; Sat, 04 Oct 2025 16:52:11 +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 1v55UN-000NqN-1z for pgsql-bugs@lists.postgresql.org; Sat, 04 Oct 2025 16:52:10 +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=PyHsJZN98ZSoEOxzdms4mzWttTK9oK2Askx0uJoK2LI=; b=vPnLJzgKnSfjOKXMFT9PVeo+CG RwBQD8e8Aa94T3sxLA5ZpKHD/QEnTs1c0j4eQnJEzPjKT4fxYAHJ4iBmJSf6Mx7S0sX1oLj0ktHJy gN6F8LWTIl7BCNJKajeFPv69hAHYO5R9p1LCH3ZlyTlipXiHnYpfmZYZwPIwa3Avi6ZQ0tr7FTbJt cct93P3H3FejRgOOJjcYkuYfZHxVGCeQ9vPIMQ3sj1J6k0vbfV3+NC8Y2Hkd5ss3Z1/7VHKFDekCN FsiE9UIlHVfWVi6ohr1al8FlogLlcXls8a42cMVklDapHd2aQJ1svChM0yxABVRhUsqaGv9Lge6JQ 6cYwfMow==; 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 1v55UL-0005uZ-Ih for pgsql-bugs@lists.postgresql.org; Sat, 04 Oct 2025 16:52:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1v55UJ-000HQp-0n for pgsql-bugs@lists.postgresql.org; Sat, 04 Oct 2025 16:52:03 +0000 Content-Type: multipart/mixed; boundary="===============1120571630075247840==" MIME-Version: 1.0 Subject: BUG #19072: New-style SQL language function referencing a temp table behaves oddly To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bernice.southey@gmail.com Reply-To: bernice.southey@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 04 Oct 2025 16:51:33 +0000 Message-ID: <19072-819bab455efebdd7@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 --===============1120571630075247840== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA3MgpMb2dnZWQgYnk6ICAgICAgICAgIEJlcm5pY2UgU291dGhleQpF bWFpbCBhZGRyZXNzOiAgICAgIGJlcm5pY2Uuc291dGhleUBnbWFpbC5jb20KUG9zdGdyZVNRTCB2 ZXJzaW9uOiAxOC4wCk9wZXJhdGluZyBzeXN0ZW06ICAgTGludXggTWludCAyMi4yCkRlc2NyaXB0 aW9uOiAgICAgICAgCgpXaGVuIGNyZWF0ZWQgaW4gcHNxbCwgYSBuZXctc3R5bGUgU1FMIGxhbmd1 YWdlIGZ1bmN0aW9uIHJlZmVyZW5jaW5nIGEgdGVtcAp0YWJsZSBkaXNhcHBlYXJzIHdpdGggdGhl IHNlc3Npb24sIGFzIGlmIGl0IHdlcmUgYSB0ZW1wb3JhcnkgZnVuY3Rpb24uCldoZW4gY3JlYXRl ZCBpbiBwZ0FkbWluLCB0aGUgZnVuY3Rpb24gc3Vydml2ZXMuIEl0IGFsd2F5cyBzdWNjZWVkcyBl dmVuIGlmCnRoZSB0ZW1wIHRhYmxlIGRvZXNuJ3QgZXhpc3QsIGFuZCBpZiBpdCBkb2VzLCBpdHMg cm93IGFyZSBpZ25vcmVkLgoKSXQgbWFrZXMgc2Vuc2UgdGhhdCBuZXctc3R5bGUgU1FMIGxhbmd1 YWdlIGZ1bmN0aW9ucyBkb24ndCBzdXBwb3J0IHRlbXAKdGFibGVzLCBidXQgdGhlIGN1cnJlbnQg bm9uLXN1cHBvcnQgaXMgc29tZXdoYXQgY29uZnVzaW5nLgpJIGNvdWxkbid0IGZpbmQgYW55IHJl ZmVyZW5jZXMgdG8gdGhpcywgbXkgYXBvbG9naWVzIGlmIGl0J3MgYWxyZWFkeSBrbm93bi4KClZF UlNJT05TOgpTZXJ2ZXI6ICBQb3N0Z3JlU1FMIDE4LjAgKFVidW50dSAxOC4wLTEucGdkZzI0LjA0 KzMpIG9uIHg4Nl82NC1wYy1saW51eC1nbnUsCmNvbXBpbGVkIGJ5IGdjYyAoVWJ1bnR1IDEzLjMu MC02dWJ1bnR1Mn4yNC4wNCkgMTMuMy4wLCA2NC1iaXQKcHNxbDogICAgMTguMCAoVWJ1bnR1IDE4 LjAtMS5wZ2RnMjQuMDQrMykKcGdBZG1pbjogOS44ClJlcHJvZHVjaWJsZSBvbiBhIFBvc3RncmVT UUwgMTcgc2VydmVyLgoKU1RFUFMgVE8gUkVQUk9EVUNFCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLQpTVEVQIDE6IEluIHBzcWwgY3JlYXRlIGEgdGVtcG9yYXJ5IHRhYmxlIGFuZCBh IG5ldy1zdHlsZSBTUUwgZnVuY3Rpb24KcmVmZXJlbmNpbmcgdGhlIHRhYmxlLgotLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KOn4kIHBzcWwgLWQgcG9zdGdyZXNxbDovL3Bvc3RncmVz OkBsb2NhbGhvc3QvdGVzdAoKdGVzdD0jIENSRUFURSBURU1QIFRBQkxFIHRlc3QoaSkgQVMgVkFM VUVTKDEpOyBDUkVBVEUgRlVOQ1RJT04gdmFuaXNoKCkKUkVUVVJOUyBJTlQgUkVUVVJOIChTRUxF Q1QgaSBGUk9NIHRlc3QpOyBTRUxFQ1QgdmFuaXNoKCk7ClNFTEVDVCAxCkNSRUFURSBGVU5DVElP TgogdmFuaXNoCi0tLS0tLS0tCiAgICAgIDEKKDEgcm93KQoKLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tClNURVAgMjogU3RhcnQgYSBuZXcgc2Vzc2lvbiBhbmQgc2VsZWN0IHRoZSBm dW5jdGlvbi4gVGhlIGZ1bmN0aW9uIGRvZXMgbm90CmV4aXN0LgotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0KdGVzdD0jIFxxCjp+JCBwc3FsIC1kIHBvc3RncmVzcWw6Ly9wb3N0Z3Jl czpAbG9jYWxob3N0L3Rlc3QKCnRlc3Q9IyBTRUxFQ1QgdmFuaXNoKCk7CkVSUk9SOiAgZnVuY3Rp b24gdmFuaXNoKCkgZG9lcyBub3QgZXhpc3QKTElORSAxOiBTRUxFQ1QgdmFuaXNoKCk7CiAgICAg ICAgICAgICAgIF4KSElOVDogIE5vIGZ1bmN0aW9uIG1hdGNoZXMgdGhlIGdpdmVuIG5hbWUgYW5k IGFyZ3VtZW50IHR5cGVzLiBZb3UgbWlnaHQgbmVlZAp0byBhZGQgZXhwbGljaXQgdHlwZSBjYXN0 cy4KCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQpTVEVQIDM6IEluIHBnQW1pbiBj cmVhdGUgYSB0ZW1wIHRhYmxlIGFuZCBhIG5ldy1zdHlsZSBTUUwgZnVuY3Rpb24KcmVmZXJlbmNp bmcgdGhlIHRhYmxlLiAoYXMgcGVyIHN0ZXAgMSkKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tCkNSRUFURSBURU1QIFRBQkxFIHRlc3QoaSkgQVMgVkFMVUVTKDEpOyBDUkVBVEUgRlVO Q1RJT04gdmFuaXNoKCkgUkVUVVJOUyBJTlQKUkVUVVJOIChTRUxFQ1QgaSBGUk9NIHRlc3QpOyBT RUxFQ1QgdmFuaXNoKCk7CgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KU1RFUCA0 OiBJbiBwc3FsIHNlbGVjdCB0aGUgZnVuY3Rpb24uIEl0IHNob3VsZCBlcnJvciBiZWNhdXNlIHRo ZSB0YWJsZQpkb2Vzbid0IGV4aXN0IGJ1dCBpdCByZXR1cm5zIG5vIHJvd3MuCi0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQp0ZXN0PSMgU0VMRUNUIHZhbmlzaCgpOwogdmFuaXNoCi0t LS0tLS0tCiAgICAgICAKKDEgcm93KQoKLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t ClNURVAgNTogQ3JlYXRlIHRoZSB0ZW1wIHRhYmxlIHdpdGggcm93cyBhbmQgY2FsbCB0aGUgZnVu Y3Rpb24uIEl0IHJldHVybnMgbm8Kcm93cy4KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tCnRlc3Q9IyBDUkVBVEUgVEVNUCBUQUJMRSB0ZXN0IEFTIFZBTFVFUygyKTsgU0VMRUNUIHZh bmlzaCgpOwpTRUxFQ1QgMQogdmFuaXNoCi0tLS0tLS0tCiAgICAgICAKKDEgcm93KQoKLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tClNURVAgNjogRm9yIGNvbXBsZXRlbmVzcyBjcmVh dGUgdGhlIHRlbXAgdGFibGUgYW5kIGZ1bmN0aW9uIHdpdGggcXVvdGVkIFNRTApsYW5ndWFnZSBz eW50YXguCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQp0ZXN0PSMgQ1JFQVRFIFRF TVAgVEFCTEUgdGVzdDIoaSkgQVMgVkFMVUVTKDMpOyBDUkVBVEUgRlVOQ1RJT04gdmFuaXNoMigp ClJFVFVSTlMgSU5UIExBTkdVQUdFIFNRTCBBUyAkJFNFTEVDVCBpIEZST00gdGVzdDIkJDsgU0VM RUNUIHZhbmlzaDIoKTsKU0VMRUNUIDEKQ1JFQVRFIEZVTkNUSU9OCiB2YW5pc2gyCi0tLS0tLS0t LQogICAgICAgMwooMSByb3cpCgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KU1RF UCA3OiBTdGFydCBhIG5ldyBzZXNzaW9uIGFuZCBzZWxlY3QgdGhlIGZ1bmN0aW9uLiBBcyBleHBl Y3RlZCB0aGUKZnVuY3Rpb24gZXhpc3RzIGFuZCB0aGUgdGFibGUgZG9lcyBub3QuCi0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQp0ZXN0PSMgXHEKOn4kIHBzcWwgLWQgcG9zdGdyZXNx bDovL3Bvc3RncmVzOkBsb2NhbGhvc3QvdGVzdAoKdGVzdD0jIFNFTEVDVCB2YW5pc2gyKCk7CkVS Uk9SOiAgcmVsYXRpb24gInRlc3QyIiBkb2VzIG5vdCBleGlzdApMSU5FIDE6IFNFTEVDVCBpIEZS T00gdGVzdDIKICAgICAgICAgICAgICAgICAgICAgIF4KUVVFUlk6ICBTRUxFQ1QgaSBGUk9NIHRl c3QyCkNPTlRFWFQ6ICBTUUwgZnVuY3Rpb24gInZhbmlzaDIiIGR1cmluZyBpbmxpbmluZwp0ZXN0 PSMKCg== --===============1120571630075247840==--