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 1mSfZL-0003EC-I0 for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Sep 2021 13:12:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mSfZK-00009M-Gc for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Sep 2021 13:12:18 +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 1mSfGm-0001P8-PM for pgsql-bugs@lists.postgresql.org; Tue, 21 Sep 2021 12:53:08 +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 1mSfGk-0004yO-4r for pgsql-bugs@lists.postgresql.org; Tue, 21 Sep 2021 12:53: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=4phJVNOWjFh6qxmTGsZrAUZ76PadNrK2EWey+MuJHyE=; b=M9NSuxE5mike4eONRi2LZGoWaZ JB9Tfd0WGbOA8dNyomqnzi4740Ky7vDqHpnKzAPAYPe1PIb73yhjuRc8e3KtvJmHhy9NO7ICx3DCg y4L4bVJeqPA43vQiwydyri94a6Wj1s5PH0AY/FoMCInykD42u1bu7EBfIoxG1+zZkgIgLfMxweU+l a8cxHmNvJIXPyTUtvV68WnzJ9MKolO6CBwXP8pYGyh+j6mnR5n+ZKr4iXUDkmJ47M0ZaxwzrdmCor Qf57C+tGCBLqIg/8vyFl0kZYysWE+M3KW4j7WUK5Ig5+yRSXPN3yAUiEBnsj8n2nm92PcCk8fQh4T aoARYXiw==; 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 1mSfGi-0001zG-On for pgsql-bugs@lists.postgresql.org; Tue, 21 Sep 2021 12:53:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mSfGg-0003WP-P8 for pgsql-bugs@lists.postgresql.org; Tue, 21 Sep 2021 12:53:02 +0000 Content-Type: multipart/mixed; boundary="===============2833748525935726513==" MIME-Version: 1.0 Subject: BUG #17199: Calling stored procedure with stable function as argument results in wrong result To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: notegihu@confused.at Reply-To: notegihu@confused.at, pgsql-bugs@lists.postgresql.org Date: Tue, 21 Sep 2021 12:52:14 +0000 Message-ID: <17199-1ab2561f0d94af92@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 --===============2833748525935726513== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzE5OQpMb2dnZWQgYnk6ICAgICAgICAgIEFsZXhhbmRlciBOYXdyYXRp bApFbWFpbCBhZGRyZXNzOiAgICAgIG5vdGVnaWh1QGNvbmZ1c2VkLmF0ClBvc3RncmVTUUwgdmVy c2lvbjogMTMuNApPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4CkRlc2NyaXB0aW9uOiAgICAgICAg CgpIZWxsbywNCg0Kd2UgYXJlIGZhY2luZyBzb21lIGluY29uc2lzdGVuY2llcyBpbiBvbmUgb2Yg b3VyIHVuaXQgdGVzdHMgc2luY2UgdGhlIGxhc3QKdXBncmFkZSBvZiBQb3N0Z3JlU1FMIHRvIDEx LjEzIGFuZCAxMy40Lg0KV2hlbiBhIGZ1bmN0aW9uIHRoYXQgcmV0dXJucyBqdXN0IGEgcm93IGNv dW50IG9mIGEgdGFibGUgaXMgbWFya2VkIGFzIFNUQUJMRQphbmQgaXMgY2FsbGVkIGZyb20gYSBz dG9yZWQgcHJvY2VkdXJlIGFzIGFyZ3VtZW50LCB0aGUgcmVzdWx0IG9mIHRoZQpmdW5jdGlvbiBp cyBkaWZmZXJlbnQgdGhhbiB3aGVuIHRoZSBmdW5jdGlvbiBpcyBjYWxsZWQgYmVmb3JlaGFuZCBh bmQgc3RvcmVkCnRvIGEgbG9jYWwgdmFyaWFibGUuDQpJdCdzIHdvcmtpbmcgZmluZSB3aGVuIHRo ZSBmdW5jdGlvbiBpcyBtYXJrZWQgYXMgVk9MQVRJTEUsIG9yIG9uIFBvc3RncmVTUUwKMTEuMTIg LyAxMy4zLg0KDQpTdGVwcyB0byByZXByb2R1Y2U6DQoNCjEuIENyZWF0ZSBhbiBlbXB0eSB0YWJs ZQ0KMi4gQ3JlYXRlIGEgZnVuY3Rpb24gdGhhdCBpcyBtYXJrZWQgYXMgU1RBQkxFIGFuZCByZXR1 cm5zIHRoZSByb3cgY291bnQgb2YKdGhlIHRhYmxlIChSRVRVUk4gU0VMRUNUIENPVU5UKCopIEZS T00gdGFibGUpDQozLiBDcmVhdGUgYSBwcm9jZWR1cmUgdGhhdCB0YWtlcyBhbiBpbnRlZ2VyIHBh cmFtZXRlciBhbmQgc2ltcGx5IG91dHB1dHMgaXQsCmUuZy4gUkFJU0UgTk9USUNFDQo0LiBJbiBh IHNpbmdsZSBETyBibG9jazogSU5TRVJUIGEgcm93IGludG8gdGhlIHRhYmxlLCB0aGVuIENBTEwK cHJvYyhmdW5jKCkpOyAvKiAtLT4gb3V0cHV0OiAwLCBpbnN0ZWFkIG9mIDEgKi8NCjUuIFN0b3Jp bmcgdGhlIHJlc3VsdCBvZiBmdW5jKCkgdG8gYSB2YXJpYWJsZSB4LCB0aGVuIENBTEwgcHJvYyh4 KTsgLyogLS0+Cm91dHB1dDogMSwgYXMgZXhwZWN0ZWQgKi8NCg0KRXhhbXBsZSBTUUw6DQoNCkNS RUFURSBUQUJMRSB0YmwgKGNvbCBJTlQ0KTsNCg0KQ1JFQVRFIE9SIFJFUExBQ0UgRlVOQ1RJT04g c3RhYmxlX2Z1bmMoKQ0KICAgIFJFVFVSTlMgSU5UNA0KICAgIFNUQUJMRSBBUw0KJGNvZGUkDQpC RUdJTg0KICAgIFJFVFVSTiAoU0VMRUNUIENPVU5UKDEpIEZST00gdGJsKTsNCkVORA0KJGNvZGUk IExBTkdVQUdFIHBscGdzcWw7DQoNCkNSRUFURSBPUiBSRVBMQUNFIEZVTkNUSU9OIHZvbGF0aWxl X2Z1bmMoKQ0KICAgIFJFVFVSTlMgSU5UNA0KICAgIFZPTEFUSUxFIEFTDQokY29kZSQNCkJFR0lO DQogICAgUkVUVVJOIChTRUxFQ1QgQ09VTlQoMSkgRlJPTSB0YmwpOw0KRU5EDQokY29kZSQgTEFO R1VBR0UgcGxwZ3NxbDsNCg0KDQpDUkVBVEUgT1IgUkVQTEFDRSBQUk9DRURVUkUgY2FsbF9wcm9j KHQgVEVYVCwgY250IElOVDQpDQpBUw0KJGNvZGUkDQpCRUdJTg0KICAgIFJBSVNFIE5PVElDRSAn JScsICh0IHx8ICcgLS0gY291bnQ6ICcgfHwgY250OjpURVhUKTsNCkVORA0KJGNvZGUkIExBTkdV QUdFIHBscGdzcWw7DQoNCkRPDQokJA0KREVDTEFSRQ0KICAgIHggSU5UNDsNCkJFR0lODQogICAg UkFJU0UgTk9USUNFICclJywgKFZFUlNJT04oKSk7DQogICAgSU5TRVJUIElOVE8gdGJsKGNvbCkg VkFMVUVTICgxKTsNCg0KICAgIHggOj0gdm9sYXRpbGVfZnVuYygpOw0KICAgIENBTEwgY2FsbF9w cm9jKCdmcm9tX3Zhcl92b2xhdGlsZV9mdW5jJywgeCk7DQogICAgQ0FMTCBjYWxsX3Byb2MoJ2lu bGluZV92b2xhdGlsZV9mdW5jJywgdm9sYXRpbGVfZnVuYygpKTsNCg0KICAgIHggOj0gc3RhYmxl X2Z1bmMoKTsNCiAgICBDQUxMIGNhbGxfcHJvYygnZnJvbV92YXJfc3RhYmxlX2Z1bmMnLCB4KTsN CiAgICBDQUxMIGNhbGxfcHJvYygnaW5saW5lX3N0YWJsZV9mdW5jJywgc3RhYmxlX2Z1bmMoKSk7 DQpFTkQNCiQkOw0KDQpJIHdvdWxkIGV4cGVjdCB0aGF0IGFsbCBjYWxscyBvdXRwdXQgdGhlIHNh bWUgcm93IGNvdW50IG9mIDEuIEhvd2V2ZXIsIHRoZQphY3R1YWwgdmFsdWUgZGlmZmVycyBmb3Ig dGhlIGxhc3QgY2FsbCBzaW5jZSB0aGUgdXBncmFkZS4NCg0KT3V0cHV0IG9uIFBvc3RncmVzIDEz LjM6DQpQb3N0Z3JlU1FMIDEzLjMgKERlYmlhbiAxMy4zLTEucGdkZzEwMCsxKSBvbiB4ODZfNjQt cGMtbGludXgtZ251LCBjb21waWxlZApieSBnY2MgKERlYmlhbiA4LjMuMC02KSA4LjMuMCwgNjQt Yml0DQpmcm9tX3Zhcl92b2xhdGlsZV9mdW5jIC0tIGNvdW50OiAxDQppbmxpbmVfdm9sYXRpbGVf ZnVuYyAtLSBjb3VudDogMQ0KZnJvbV92YXJfc3RhYmxlX2Z1bmMgLS0gY291bnQ6IDENCmlubGlu ZV9zdGFibGVfZnVuYyAtLSBjb3VudDogMQ0KDQpPdXRwdXQgb24gUG9zdGdyZXMgMTMuNDoNClBv c3RncmVTUUwgMTMuNCAoRGViaWFuIDEzLjQtMS5wZ2RnMTAwKzEpIG9uIHg4Nl82NC1wYy1saW51 eC1nbnUsIGNvbXBpbGVkCmJ5IGdjYyAoRGViaWFuIDguMy4wLTYpIDguMy4wLCA2NC1iaXQNCmZy b21fdmFyX3ZvbGF0aWxlX2Z1bmMgLS0gY291bnQ6IDENCmlubGluZV92b2xhdGlsZV9mdW5jIC0t IGNvdW50OiAxDQpmcm9tX3Zhcl9zdGFibGVfZnVuYyAtLSBjb3VudDogMQ0KaW5saW5lX3N0YWJs ZV9mdW5jIC0tIGNvdW50OiAwDQoNClRoZSBzYW1lIGNoYW5nZSBpbiBiZWhhdmlvciBzZWVtcyB0 byBiZSBpbnRyb2R1Y2VkIGluIDEyLjgsIG5vdCBiZWluZwpwcmVzZW50IGluIDEyLjcuIEkgcmFu IHRoZSBjb2RlIGFib3ZlIHVzaW5nIG9mZmljaWFsIERvY2tlciBIdWIgaW1hZ2VzLg0KDQpCZXN0 IHJlZ2FyZHMsDQpBbGV4YW5kZXIgTmF3cmF0aWwKCg== --===============2833748525935726513==--