Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1peyJR-0008D0-MP for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Mar 2023 13:15:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1peyJQ-0006E2-I6 for pgsql-bugs@arkaria.postgresql.org; Wed, 22 Mar 2023 13:15:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pext4-0003EF-7L for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 12:48:18 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pexsu-0004Gm-7W for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 12:48:17 +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=0RN2zIQwkk2CGkdgOUO/Vije5lBMEPLqMvtY8O/0qYE=; b=kxw8489IRHtJMJuuzDcIaAJwk/ HPeMWdi8wN5bPnHF6j9KuxRvqIbhqWgkdVs3jhzXC7nXDSPqf/b1qXJ3u3hROBMAK8sJt9rbsnce9 QuAUtsJ9czcBk2yd7g8IPUT0WlWlm08dEnCnrFWKahhNoCRz6rYyykBHLc3MaLOGoKj5RaswUvjab cM41t/5b1+/el/dnCd5RVjCYxc/q7GcLaotcO0lOpw8IbIW/Pi8utok+cau7UZLHFngvBF8HXVq/J irmQvONqpsVKaYu0t2RQPTri03+n40Wkk1Wo66C9GUKP77UOV3skhptbq8X+dOPDrkxCEeqzNyR+J ruAcxmFg==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pexsq-0003S6-Tm for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 12:48:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pexsn-00Gn4y-EB for pgsql-bugs@lists.postgresql.org; Wed, 22 Mar 2023 12:48:02 +0000 Content-Type: multipart/mixed; boundary="===============7520541471534911044==" MIME-Version: 1.0 Subject: BUG #17860: Possible Bugs in PL/pgSQL Functions' Return Values To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: jiangshan.liu@tju.edu.cn Reply-To: jiangshan.liu@tju.edu.cn, pgsql-bugs@lists.postgresql.org Date: Wed, 22 Mar 2023 12:47:05 +0000 Message-ID: <17860-3e3a34519be852ad@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 --===============7520541471534911044== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg2MApMb2dnZWQgYnk6ICAgICAgICAgIEppYW5nc2hhbiBMaXUKRW1h aWwgYWRkcmVzczogICAgICBqaWFuZ3NoYW4ubGl1QHRqdS5lZHUuY24KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNS4yCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE4LjA0LjYgTFRTCkRlc2NyaXB0 aW9uOiAgICAgICAgCgpJIGFtIHdyaXRpbmcgdG8gcmVwb3J0IGEgcG9zc2libGUgYnVnIHRoYXQg SSBoYXZlIGVuY291bnRlcmVkIHdpdGggdGhlCmV4ZWN1dGlvbiBvZiB0d28gUEwvcGdTUUwgZnVu Y3Rpb25zLiBUaGUgcmVzdWx0cyB0aGF0IHRoZXkgcHJvZHVjZSBoYXZlIGxlZnQKbWUgY29uZnVz ZWQgYW5kIEkgd291bGQgYXBwcmVjaWF0ZSB5b3VyIGluc2lnaHRzIGFuZCBhc3Npc3RhbmNlIHdp dGggdGhpcwptYXR0ZXIuDQoNClRoZSBmaXJzdCBmdW5jdGlvbiBpczoNCkNSRUFURSBPUiBSRVBM QUNFIEZVTkNUSU9OIHRlc3QxKCkgUkVUVVJOUyBTRVRPRiBCT09MRUFOIEFTICQkDQpCRUdJTg0K ICAgIFJFVFVSTjsNCkVORDsNCiQkIExBTkdVQUdFIHBscGdzcWw7DQoNCnNlbGVjdCBjb3VudCgq KSBmcm9tIHRlc3QxKCk7DQoNClRoZSByZXN1bHQgb2YgZXhlY3V0aW5nIHRoaXMgZnVuY3Rpb24g aXM6DQogY291bnQgDQotLS0tLS0tDQogICAgIDANCigxIHJvdykNCg0KVGhlIHNlY29uZCBmdW5j dGlvbiBpczoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHRlc3QyKCkgUkVUVVJOUyBWT0lE IEFTICQkDQpCRUdJTg0KICAgIFJFVFVSTjsNCkVORDsNCiQkIExBTkdVQUdFIHBscGdzcWw7DQoN CnNlbGVjdCBjb3VudCgqKSBmcm9tIHRlc3QyKCk7DQoNClRoZSByZXN1bHQgb2YgZXhlY3V0aW5n IHRoaXMgZnVuY3Rpb24gaXM6DQogY291bnQgDQotLS0tLS0tDQogICAgIDENCigxIHJvdykNCg0K QXQgdGhlIHNhbWUgdGltZSwgSSBkaXNjb3ZlcmVkIHRoYXQgdGhlIHJldHVybmVkIDEgcm93IGRh dGEgcmVzdWx0IGlzIG9mCnR5cGUgInZvaWQiOg0Kc2VsZWN0IHBnX3R5cGVvZih0ZXN0MigpKTsN CiBwZ190eXBlb2YgDQotLS0tLS0tLS0tLQ0KIHZvaWQNCigxIHJvdykNCg0KSSBiZWxpZXZlIHRo YXQgdGhlcmUgaXMgYSBjb25mdXNpbmcgYnVnIHByZXNlbnQgaGVyZS4gRm9yIHRoZSBmdW5jdGlv bgp0ZXN0MSgpLCBhY2NvcmRpbmcgdG8gdGhlIGRvY3VtZW50YXRpb24sDQoiVGhlIGluZGl2aWR1 YWwgaXRlbXMgdG8gcmV0dXJuIGFyZSBzcGVjaWZpZWQgYnkgYSBzZXF1ZW5jZSBvZiBSRVRVUk4g TkVYVApvciBSRVRVUk4gUVVFUlkgY29tbWFuZHMsIGFuZCB0aGVuIGEgZmluYWwgUkVUVVJOIGNv bW1hbmQgd2l0aCBubyBhcmd1bWVudAppcyB1c2VkIHRvIGluZGljYXRlIHRoYXQgdGhlIGZ1bmN0 aW9uIGhhcyBmaW5pc2hlZCBleGVjdXRpbmdbMV0uIg0KDQpTaW5jZSB0aGVyZSBhcmUgbm8gYWN0 dWFsIFJFVFVSTiBORVhUIG9yIFJFVFVSTiBRVUVSWSBleGVjdXRlZCwgdGhlIGJlaGF2aW9yCnNo b3VsZCBiZSBlcXVpdmFsZW50IHRvIGEgUkVUVVJOIGNvbW1hbmQgd2l0aCBubyBhcmd1bWVudCwg c2ltaWxhciB0byB0aGUKZnVuY3Rpb24gdGVzdDIoKS4NCkhvd2V2ZXIsIHRoZSByZXN1bHRzIG9m IHRlc3QxKCkgYW5kIHRlc3QyKCkgYXJlIGRpZmZlcmVudC4gSSBhbSB1bnN1cmUgaWYKdGhlIGVt cHR5IHRhYmxlIHJldHVybmVkIGJ5IHRlc3QxKCkgaXMgYSBkZWxpYmVyYXRlIGRlc2lnbiBvciBu b3QsIGJ1dCBpdApkb2VzIG5vdCBzZWVtIHRvIGFsaWduIHdpdGggdGhlIGludGVudGlvbiBvZiBT RVRPRiByZXR1cm4gdmFsdWVzLg0KDQpUaGUgZG9jdW1lbnRhdGlvbiBhbHNvIG1lbnRpb25zIHRo YXQNCiJUaGUgU0VUT0YgbW9kaWZpZXIgaW5kaWNhdGVzIHRoYXQgdGhlIGZ1bmN0aW9uIHdpbGwg cmV0dXJuIGEgc2V0IG9mIGl0ZW1zLApyYXRoZXIgdGhhbiBhIHNpbmdsZSBpdGVtWzJdLiINCg0K UmVnYXJkbGVzcyBvZiB3aGV0aGVyIHRoZSBsZW5ndGggb2YgdGhlIHJldHVybmVkIHNldCBpcyB6 ZXJvIG9yIG5vbi16ZXJvLCB3ZQpleHBlY3QgdG8gcmVjZWl2ZSBhIHNpbmdsZSBlbnRpdHkgYXMg YSByZXR1cm4gdmFsdWUsIHJhdGhlciB0aGFuIGFuIGVtcHR5CnRhYmxlLiBKdXN0IGxpa2UgaW4g b3RoZXIgcHJvZ3JhbW1pbmcgbGFuZ3VhZ2VzLCBzdWNoIGFzIEphdmEsIHdoZW4gd2UKZXhwZWN0 IGFuIGFycmF5IG9mIGxlbmd0aCB6ZXJvLCB3ZSBzdGlsbCBuZWVkIHRvIGNyZWF0ZSB0aGF0IGFy cmF5IHRvIG1ha2UKaXQgYW4gZW50aXR5LCBvdGhlcndpc2UgaXQgd2lsbCBiZSBhIG51bGwgdmFs dWUuDQoNCk1vcmVvdmVyLCByZWdhcmRpbmcgZnVuY3Rpb24gdGVzdDIoKSwgdGhlIHJlc3VsdCBp cyBhbHNvIHBlcnBsZXhpbmcuCkFjY29yZGluZyB0byB0aGUgZG9jdW1lbnRhdGlvbiwNCiJEYXRh IHR5cGUgdm9pZCBJbmRpY2F0ZXMgdGhhdCBhIGZ1bmN0aW9uIHJldHVybnMgbm8gdmFsdWUuIg0K DQpUaGVyZWZvcmUsIGl0IGlzIHJlYXNvbmFibGUgdG8gZXhwZWN0IHRoYXQgdGhlIHJldHVybmVk IHZhbHVlIHNob3VsZCBiZSBhbgplbXB0eSB0YWJsZSwgYXMgaXQgc2hvdWxkIG5vdCBiZSByZXR1 cm5pbmcgYW55IHZhbHVlLiBIb3dldmVyLCBpbiByZWFsaXR5LAppdCByZXR1cm5zIGEgdGFibGUg d2l0aCBvbmUgcm93Lg0KDQpJIHdvdWxkIGdyZWF0bHkgYXBwcmVjaWF0ZSB5b3VyIHRob3VnaHRz IGFuZCBmZWVkYmFjayBvbiB0aGlzIGlzc3VlLiBUaGFuawp5b3UgZm9yIHlvdXIgYXR0ZW50aW9u IGFuZCBhc3Npc3RhbmNlLg0KDQpTaW5jZXJlbHksIEppYW5nc2hhbiBMaXUNCg0KDQpbMV0KaHR0 cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8xNS9wbHBnc3FsLWNvbnRyb2wtc3RydWN0dXJl cy5odG1sIzp+OnRleHQ9YW5kJTIwdGhlbiUyMGElMjBmaW5hbCUyMFJFVFVSTiUyMGNvbW1hbmQl MjB3aXRoJTIwbm8lMjBhcmd1bWVudCUyMGlzJTIwdXNlZCUyMHRvJTIwaW5kaWNhdGUlMjB0aGF0 JTIwdGhlJTIwZnVuY3Rpb24lMjBoYXMlMjBmaW5pc2hlZCUyMGV4ZWN1dGluZw0KWzJdCmh0dHBz Oi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTUvc3FsLWNyZWF0ZWZ1bmN0aW9uLmh0bWwjOn46 dGV4dD1UaGUlMjBTRVRPRiUyMG1vZGlmaWVyJTIwaW5kaWNhdGVzJTIwdGhhdCUyMHRoZSUyMGZ1 bmN0aW9uJTIwd2lsbCUyMHJldHVybiUyMGElMjBzZXQlMjBvZiUyMGl0ZW1zJTJDJTIwcmF0aGVy JTIwdGhhbiUyMGElMjBzaW5nbGUlMjBpdGVtLg0KWzNdCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwu b3JnL2RvY3MvMTUvZGF0YXR5cGUtcHNldWRvLmh0bWwjOn46dGV4dD1JbmRpY2F0ZXMlMjB0aGF0 JTIwYSUyMGZ1bmN0aW9uJTIwcmV0dXJucyUyMG5vJTIwdmFsdWUuCgo= --===============7520541471534911044==--