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 1uNyeE-00D6P4-LN for pgsql-bugs@arkaria.postgresql.org; Sat, 07 Jun 2025 18:52:07 +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 1uNyeC-00EgiS-Q9 for pgsql-bugs@arkaria.postgresql.org; Sat, 07 Jun 2025 18:52:05 +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 1uNw6W-00Dze5-08 for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 16:09:08 +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 1uNw6U-000jaw-1v for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 16:09:08 +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=s9hKeOYTXYTDeXkdndSlSFRPnJ5hOFU/VOnNyMCE7QU=; b=13ivwgWLOzfkE4X1vQLz03GWsW cB1W+sS3rV+kiyLeK2rNWzJlXz+9oL7OlPvABNtXx13cwFJV6JMt3rX5AT/tbzzhHKe75Tb40RxNS elfKexFRYSp/+elb455mkYkVM469PuTJdBqekLIraJVbXimfzLXmZWZYPGqTXt7jD1QisoTPpdFNE MU1RGeYjVFUhVX+6DhEWp3Zxp6/mb457/+xC9ZfRPoPx87sbZacm4ll6OaB5VsQ7gRCjCfWjt+jDy YwQ9U7EwJGHShfRaR2Ad0F3KSCyYf9IRLvkHK2vhjirr//bAZTSbtLSoyHRbuosFPXe7WQ37RyJ37 26PvPUAw==; 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 1uNw6S-002dBk-Bj for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 16:09:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uNw6R-00Ap8A-0u for pgsql-bugs@lists.postgresql.org; Sat, 07 Jun 2025 16:09:02 +0000 Content-Type: multipart/mixed; boundary="===============2501587806478090402==" MIME-Version: 1.0 Subject: BUG #18950: pgsql function that worked in Postgresql 16 does not return in Postgresql 17 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: lowell.hought@gmail.com Reply-To: lowell.hought@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 07 Jun 2025 16:08:44 +0000 Message-ID: <18950-010424f049268487@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 --===============2501587806478090402== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODk1MApMb2dnZWQgYnk6ICAgICAgICAgIExvd2VsbCBIb3VnaHQKRW1h aWwgYWRkcmVzczogICAgICBsb3dlbGwuaG91Z2h0QGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNp b246IDE3LjUKT3BlcmF0aW5nIHN5c3RlbTogICBSZWQgSGF0IEVudGVycHJpc2UgTGludXggcmVs ZWFzZSA4LjEwIChPb3RwYSkKRGVzY3JpcHRpb246ICAgICAgICAKCkEgcGdzcWwgZnVuY3Rpb24g dGhhdCByZXR1cm5zIFRhYmxlIGlzIHJlbGF0aXZlbHkgc2ltcGxlLiAgSXQgYWNjZXB0cyB0d28K YXJndW1lbnRzOyBhIGRhdGUgYW5kIGFuIGludGVydmFsLiAgSXQgdXNlcyB0aGVzZSB0byBhcmd1 bWVudHMgaW4gYSBxdWVyeQp0aGF0IHJldHVybnMgYSByZXN1bHQgc2V0LiAgVGhpcyBmdW5jdGlv biB3b3JrZWQgaW4gUG9zdGdyZXNxbCAxNi4xIGFuZApQb3N0Z3Jlc3FsIDE2LjkuICBIb3dldmVy LCBpdCBkb2VzIG5vdCB3b3JrIGluIHZlcnNpb25zIDE3LjAgbm9yIGluIDE3LjUKSGVyZSBpcyBt eSBidWlsZCBzZXF1ZW5jZSBmb3IgdmVyc2lvbiAxNy41LCB0aGUgbGFzdCB2ZXJzaW9uIEkgdGVz dGVkLgouL2NvbmZpZ3VyZSAtLXByZWZpeD0vdXNyL2xvY2FsL3Bnc3FsLzE3LyAtLXdpdGgtb3Bl bnNzbCAtLXdpdGgtbGRhcAotLXdpdGgtc3lzdGVtZCAtLXdpdGgtbGlieG1sIC0td2l0aC1saWJ4 c2x0CmdtYWtlIHdvcmxkCmdtYWtlIGNoZWNrIDogIyBBbGwgMjIyIHRlc3RzIHBhc3NlZC4Kc3Vk byBnbWFrZSBpbnN0YWxsLXdvcmxkCnN1IHJvb3QKbWtkaXIgL3Vzci9sb2NhbC9wZ3NxbC8xNy9k YXRhCmNob3duIHBvc3RncmVzIC91c3IvbG9jYWwvcGdzcWwvMTcvZGF0YQpzdSBwb3N0Z3Jlcwov dXNyL2xvY2FsL3Bnc3FsLzE3L2Jpbi9pbml0ZGIgLUQgL3Vzci9sb2NhbC9wZ3NxbC8xNy9kYXRh ClN1Y2Nlc3MuIFlvdSBjYW4gbm93IHN0YXJ0IHRoZSBkYXRhYmFzZSBzZXJ2ZXIgdXNpbmc6CiAg ICAvdXNyL2xvY2FsL3Bnc3FsLzE3L2Jpbi9wZ19jdGwgLUQgL3Vzci9sb2NhbC9wZ3NxbC8xNy9k YXRhIC1sIGxvZ2ZpbGUKc3RhcnQKL3Vzci9sb2NhbC9wZ3NxbC8xNy9iaW4vcGdfY3RsIC1EIC91 c3IvbG9jYWwvcGdzcWwvMTcvZGF0YSAtbAovdXNyL2xvY2FsL3Bnc3FsLzE3L2RhdGEvbG9nZmls ZSBzdGFydAovdXNyL2xvY2FsL3Bnc3FsLzE3L2Jpbi9jcmVhdGVkYiB0ZXN0Ci91c3IvbG9jYWwv cGdzcWwvMTcvYmluL3BzcWwgdGVzdApwc3FsICgxNy41KQpUeXBlICJoZWxwIiBmb3IgaGVscC4K UmVzdG9yZSBmcm9tIGJhY2t1cDoKL3Vzci9sb2NhbC9wZ3NxbC8xNy9iaW4vcHNxbCAgLWQgdGVz dCAtVXBvc3RncmVzIC1mIC9iYWsvZGIvZGJfYmFja3VwLnNxbApUaGVuIEkgcnVuIHBzcWwgYW5k IGV4ZWN1dGUgdGhpcyBjb21tYW5kOgpTRUxFQ1QgKiBGUk9NIHJlcG9ydC5HZXRSZXBvcnRQb29s VHJhaW5lZXMoQ1VSUkVOVF9EQVRFLCAnMSB5ZWFyJyk7ClRoZSByZXN1bHQgaXMgdGhhdCBldmVu IGFmdGVyIDEyIGhvdXJzIHRoZSBmdW5jdGlvbiBkb2VzIG5vdCByZXR1cm4uICBUaGVyZQppcyBu byByZXNwb25zZSB3aGF0c29ldmVyLiAgSSB0ZXN0ZWQgdGhpcyBib3RoIG9uIFJlZGhhdCA4LjEw IGFuZCBvbiBSZWQgSGF0CkVudGVycHJpc2UgTGludXggcmVsZWFzZSA4LjEwIChPb3RwYSkgYW5k IG9uIFJvY2t5IExpbnV4IHJlbGVhc2UgOC43IChHcmVlbgpPYnNpZGlhbikgd2l0aCBpZGVudGlj YWwgcmVzdWx0cy4gIE9uIGJvdGggc3lzdGVtcyB0aGUgZnVuY3Rpb24gY2FsbCB3b3JrcwphcyBl eHBlY3RlZCBpbiB2ZXJzaW9uIDE2LCBidXQgaW4gdmVyc2lvbiAxNyBpdCBuZXZlciByZXR1cm5z LgpBbm90aGVyIGludGVyZXN0aW5nIGZhY3Q6IEkgcnVuIHRoZSBxdWVyeSBjb250YWluZWQgaW4g d2l0aGluIHRoZSBmdW5jdGlvbiwKaXQgZXhlY3V0ZXMgYXMgZXhwZWN0ZWQgYW5kIHJldHVybnMg dGhlIGV4cGVjdGVkIHJlc3VsdHMuICBJdCBpcyBvbmx5IHdoZW4KY2FsbGVkIHZpYSB0aGUgZnVu Y3Rpb24gdGhhdCBpdCBmYWlscy4KSGVyZSBpcyB0aGUgZnVuY3Rpb24gZGVmaW5pdGlvbjoKQ1JF QVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04gcmVwb3J0LkdldFJlcG9ydFBvb2xUcmFpbmVlcygKdmVu ZGRhdGUgREFURSwgdnRpbWVzcGFuIElOVEVSVkFMCikgUkVUVVJOUyBUQUJMRSAoCiAgICAgICAg ZmFjaWxpdHlfa2V5IElOVCwgICAgICAgICAgICAgICAgICAgICAgIGZhY2lsaXR5X2NvZGUgVEVY VCwKdHJhaW5lZWlkIElOVCwKICAgICAgICBuZGNfZW1wX2lkIElOVCwgICAgICAgICAgICAgICAg ICAgICAgICAgZmFjaWxpdHlfZW9kIERBVEUsCmhpcmVfc3RhdHVzIFRFWFQsCiAgICAgICAgdHJh aW5lZV9zdGFydF9kYXRlIERBVEUsICAgICAgICBkZXZzdGF0dXNfZGF0ZSBEQVRFLCAgICBzdGF0 dXMgVEVYVCwKICAgICAgICBzdGF0dXNfZGF5cyBJTlQKKUFTICQkCkRFQ0xBUkUKcGxlbmRkYXRl IERBVEU7CnBsaW50ZXJ2YWwgSU5URVJWQUw7CkJFR0lOCiAgICAgICAgSUYgdmVuZGRhdGUgSVMg TlVMTCBUSEVOCiAgICAgICAgICAgICAgICBwbGVuZGRhdGUgPSBDVVJSRU5UX0RBVEU7CiAgICAg ICAgRUxTRQogICAgICAgICAgICAgICAgcGxlbmRkYXRlID0gdmVuZGRhdGU7CiAgICAgICAgRU5E IElGOwogICAgICAgIElGIHZ0aW1lc3BhbiBJUyBOVUxMIFRIRU4KICAgICAgICAgICAgICAgIFNF TEVDVCB2YWx1ZTo6SU5URVJWQUwgSU5UTyBwbGludGVydmFsIEZST00KbnRkLnNpdGVfc2V0dGlu Z3MgV0hFUkUgdmFyaWFibGUgPSAnUFBUX0RBVEFfWUVBUlMnOwogICAgICAgICAgICAgICAgSUYg Tk9UIEZPVU5EIFRIRU4KICAgICAgICAgICAgICAgICAgICAgICAgcGxpbnRlcnZhbCA9ICcxMCB5 ZWFycyc7CiAgICAgICAgICAgICAgICBFTkQgSUY7CiAgICAgICAgRUxTRQogICAgICAgICAgICAg ICAgcGxpbnRlcnZhbCA9IHZ0aW1lc3BhbjsKICAgICAgICBFTkQgSUY7CiAgICAgICAgUkVUVVJO IFFVRVJZCiAgICAgICAgV0lUSCB0IEFTICgKICAgICAgICAgICAgICAgIFNFTEVDVCBESVNUSU5D VCB0ZC5mYWNpbGl0eV9rZXksIHRkLnRyYWluZWVpZCwKdGQubmRjX2VtcF9pZCwgdGQuZmFjaWxp dHlfZW9kLAogICAgICAgICAgICAgICAgICAgICAgICB0ZC50aWFfY29kZSBBUyBoaXJlX3N0YXR1 cywgdGQudHJhaW5lZV9zdGFydF9kYXRlLAp0ZC5kZXZzdGF0dXNfZGF0ZSwgdGQuc3RhdHVzLCB0 ZC5zdGF0dXNfZGF5cwogICAgICAgICAgICAgICAgICBGUk9NIHJlcG9ydC52d190cmFpbmluZ19k ZXRhaWxzIHRkCiAgICAgICAgKSwKICAgICAgICBmIEFTICgKICAgICAgICAgICAgICAgIFNFTEVD VCAqCiAgICAgICAgICAgICAgICAgIEZST00gbnRkLmZhY2lsaXR5X2RpbSBmZAogICAgICAgICAg ICAgICAgICBKT0lOICgKICAgICAgICAgICAgICAgICAgICAgICAgU0VMRUNUIGhmdC5mYWNpbGl0 eV9rZXksCk1BWChmYWNpbGl0eV90eXBlX3N0YXJ0X2RhdGUpIEFTIGZhY2lsaXR5X3R5cGVfc3Rh cnRfZGF0ZQogICAgICAgICAgICAgICAgICAgICAgICAgIEZST00gbnRkLmhpc3RvcnlfZmFjaWxp dHlfdHlwZSBoZnQKICAgICAgICAgICAgICAgICAgICAgICAgICBHUk9VUCBCWSBoZnQuZmFjaWxp dHlfa2V5CiAgICAgICAgICAgICAgICAgICAgICAgIClEVDEgVVNJTkcoZmFjaWxpdHlfa2V5KQog ICAgICAgICkKICAgICAgICBTRUxFQ1QgRFQxLmZhY2lsaXR5X2tleSwgRFQxLmZhY2lsaXR5X2Nv ZGUsIHQudHJhaW5lZWlkLAp0Lm5kY19lbXBfaWQsCiAgICAgICAgICAgICAgICB0LmZhY2lsaXR5 X2VvZCwgdC5oaXJlX3N0YXR1cywgdC50cmFpbmVlX3N0YXJ0X2RhdGUsCnQuZGV2c3RhdHVzX2Rh dGUsIHQuc3RhdHVzLCB0LnN0YXR1c19kYXlzCiAgICAgICAgICBGUk9NIHQKICAgICAgICAgIEpP SU4gKFNFTEVDVCBsLmZhY2lsaXR5X2tleSwgbC5mYWNpbGl0eV9jb2RlLAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIENBU0UKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICBXSEVOIGZhY2lsaXR5X3R5cGVfc3RhcnRfZGF0ZSBJUyBOT1QgTlVMTApBTkQgZmFjaWxp dHlfdHlwZV9zdGFydF9kYXRlID4gbC5sYXN0X2RldnN0YXR1c19kYXRlIC0gcGxpbnRlcnZhbAog ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBUSEVOCmZhY2ls aXR5X3R5cGVfc3RhcnRfZGF0ZQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEVM U0UgbC5sYXN0X2RldnN0YXR1c19kYXRlIC0gcGxpbnRlcnZhbAogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgIEVORCBBUyBsYXN0X2RldnN0YXR1c19kYXRlCiAgICAgICAgICAgICAg ICAgICAgICAgICAgRlJPTSAoU0VMRUNUIHQuZmFjaWxpdHlfa2V5LCBmLmZhY2lsaXR5X2NvZGUs Ck1BWCh0LmRldnN0YXR1c19kYXRlKSBBUyBsYXN0X2RldnN0YXR1c19kYXRlCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIEZST00gdAogICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICBMRUZUIEpPSU4gZiBVU0lORyhmYWNpbGl0eV9rZXkpCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgV0hFUkUgKHQuc3RhdHVzID0g J0NvbXBsZXRlZCcgT1IKdC5zdGF0dXMgPSAnRGlkIE5vdCBDb21wbGV0ZScpCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBBTkQgdC5kZXZzdGF0dXNfZGF0ZSA8PSBw bGVuZGRhdGUKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBHUk9VUCBC WSB0LmZhY2lsaXR5X2tleSwKZi5mYWNpbGl0eV9jb2RlCiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgKWwKICAgICAgICAgICAgICAgICAgICAgICAgICBMRUZUIEpPSU4gKFNFTEVDVCBw ZWYuZmFjaWxpdHlfa2V5LApNQVgoZmFjaWxpdHlfdHlwZV9zdGFydF9kYXRlKSBBUyBmYWNpbGl0 eV90eXBlX3N0YXJ0X2RhdGUKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgRlJPTQpudGQucHB0X2V4Y2VwdGlvbl9mYWNpbGl0aWVzIHBlZgogICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFdIRVJFCmZhY2lsaXR5 X3R5cGVfc3RhcnRfZGF0ZSA8IENVUlJFTlRfREFURQogICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgIEdST1VQIEJZIHBlZi5mYWNpbGl0eV9rZXkKICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICApIGUgVVNJTkcoZmFjaWxpdHlfa2V5KQogICAgICAg ICAgICAgICAgKURUMSBVU0lORyhmYWNpbGl0eV9rZXkpCiAgICAgICAgIFdIRVJFIHQuZGV2c3Rh dHVzX2RhdGUgPD0gcGxlbmRkYXRlCiAgICAgICAgICAgQU5EIHQuZGV2c3RhdHVzX2RhdGUgPj0g RFQxLmxhc3RfZGV2c3RhdHVzX2RhdGUKICAgICAgICA7CkVORDsKJCQgTEFOR1VBR0UgcGxwZ3Nx bDsKVGhpcyBpcyB0aGUgZmlyc3QgdGltZSBJIGhhdmUgZXZlciBlbmNvdW50ZXJlZCBhIGJ1ZyBh bmQgc28gSSBoYXZlIG5vCmV4cGVyaWVuY2Ugd2l0aCByZXBvcnRpbmcgaXQuICBJIHVuZGVyc3Rh bmQgSSBuZWVkIHRvIHNlbmQgdGhlIHVuZGVybHlpbmcKdGFibGUgc3RydWN0dXJlcyBidXQgbm90 IHN1cmUgaWYgSSBkbyBpdCBoZXJlIG9yIHNvbWUgb3RoZXIgd2F5LiAgSSBkbyBub3QKc2VlIGFu IG9wdGlvbiB0byBhdHRhY2ggZmlsZXMuCkkgbG92ZSBQb3N0Z3JlcyEgIEl0IGlzIGEgdGVycmlm aWMgZGF0YWJhc2UgYW5kIGhhcyBzZXJ2ZWQgbWUgd2VsbCBmb3IgYWJvdXQKMjAgeWVhcnMuCgo= --===============2501587806478090402==--