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 1pgRd2-0001UU-Ne for pgsql-bugs@arkaria.postgresql.org; Sun, 26 Mar 2023 14:45:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pgRd1-00024l-F8 for pgsql-bugs@arkaria.postgresql.org; Sun, 26 Mar 2023 14:45:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgQK8-0007R2-Oe for pgsql-bugs@lists.postgresql.org; Sun, 26 Mar 2023 13:22:16 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgQK0-00037M-G0 for pgsql-bugs@lists.postgresql.org; Sun, 26 Mar 2023 13:22:15 +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=2oxrZYC5BnoKVzzoLRrBMnjTmKic/LJrpSSKkRy4MBY=; b=CfuMjCv0g3bCrRXT6RI89F2yoI PAErP0po2uykt+kT9deF/kgZHlRT4yaz38H7r6MqHDw3FOdELEFodaDkDvFfzikS3ni4rX2SkzWdr 2V5Q7q6fSYlROU++yKY4qqH3stcr43wthO4YtbFptrbrVe4wMvPfZTh5LyfWendIIzX4Tf8tKckhn 91T9tBKOgSGJjBJKvZfYxc1my9kYphZ2m99Bs9sf1W/F6CjiOXlCB5dxi2RYqjC35PjTJtDVclA1X y05RBVqPRnWyALjinsSB7T06BsbJskLR6QNEyHwRd8KfhFMBmzkak4UbbWx64IH3L6Jw4bjzDv7Gq rktN8SGQ==; 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 1pgQJx-00021y-8d for pgsql-bugs@lists.postgresql.org; Sun, 26 Mar 2023 13:22:07 +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 1pgQJt-001TBo-8p for pgsql-bugs@lists.postgresql.org; Sun, 26 Mar 2023 13:22:02 +0000 Content-Type: multipart/mixed; boundary="===============7015417935958528846==" MIME-Version: 1.0 Subject: BUG #17869: Inconsistency between PL/pgSQL Function Parameter Handling and SQL Query Results 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: Sun, 26 Mar 2023 13:21:37 +0000 Message-ID: <17869-f049fe97d6a4491b@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 --===============7015417935958528846== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg2OQpMb2dnZWQgYnk6ICAgICAgICAgIEppYW5nc2hhbiBMaXUKRW1h aWwgYWRkcmVzczogICAgICBqaWFuZ3NoYW4ubGl1QHRqdS5lZHUuY24KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxNS4yCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE4LjA0CkRlc2NyaXB0aW9uOiAg ICAgICAgCgpEZWFyIFBvc3RncmVTUUwgZGV2ZWxvcGVycywNCkkgd291bGQgbGlrZSB0byByZXBv cnQgYSBwb3RlbnRpYWwgYnVnIGluIHRoZSBoYW5kbGluZyBvZiBmaXhlZC1sZW5ndGgKY2hhcmFj dGVyIHR5cGVzIGluIFBML3BnU1FMIGZ1bmN0aW9ucy4gQXMgcGVyIHRoZSBkb2N1bWVudGF0aW9u LCBDSEFSQUNURVIKd2l0aG91dCBhIGxlbmd0aCBzcGVjaWZpZXIgYXJlIGVxdWl2YWxlbnQgdG8g Q0hBUkFDVEVSKDEpIFsxXS4gVGhpcyBpcwpjb25maXJtZWQgd2hlbiB1c2luZyB0aGVtIGluIFNR TCBxdWVyaWVzLg0KDQpTRUxFQ1QgJ2FiYyc6OkNIQVI7DQogYnBjaGFyDQotLS0tLS0tLQ0KIGEN CigxIHJvdykNCg0KSG93ZXZlciwgd2hlbiBwYXNzaW5nIGZpeGVkLWxlbmd0aCBjaGFyYWN0ZXIg dHlwZXMgYXMgcGFyYW1ldGVycyBpbiBQTC9wZ1NRTApmdW5jdGlvbnMsIHRoZSBiZWhhdmlvciBz ZWVtcyB0byBiZSBkaWZmZXJlbnQuIFRoZSBkb2N1bWVudGF0aW9uIHN0YXRlcyB0aGF0CnBhcmVu dGhlc2l6ZWQgdHlwZSBtb2RpZmllcnMgYXJlIGRpc2NhcmRlZCBieSBDUkVBVEUgRlVOQ1RJT04s IG1lYW5pbmcgdGhhdApDUkVBVEUgRlVOQ1RJT04gZm9vICh2YXJjaGFyKDEwKSkgaXMgdGhlIHNh bWUgYXMgQ1JFQVRFIEZVTkNUSU9OIGZvbwoodmFyY2hhcikgWzJdLg0KDQpDUkVBVEUgT1IgUkVQ TEFDRSBGVU5DVElPTiB0ZXN0KHBhcmFtIENIQVIpIFJFVFVSTlMgVEVYVCBBUyAkJA0KICBCRUdJ Tg0KICAgIFJBSVNFIE5PVElDRSAnJScsIHBhcmFtOw0KICAgIFJFVFVSTiBwYXJhbTsNCiAgRU5E OyANCiQkIExBTkdVQUdFIHBscGdzcWw7DQoNClNFTEVDVCAqIEZST00gdGVzdCgnYWJjJyk7DQoN CiB0ZXN0DQotLS0tLS0NCiBhYmMNCigxIHJvdykNCg0KVGhpcyBpbmRpY2F0ZXMgdGhhdCB0aGUg cHJvY2Vzc2luZyBsb2dpYyBkZXNpZ25lZCBmb3IgQ0hBUkFDVEVSIHdpdGhvdXQKbGVuZ3RoIHNw ZWNpZmllciBkb2VzIG5vdCB3b3JrIGluIFBML3BnU1FMIHBhcmFtZXRlciBsaXN0cy4gSXMgdGhp cyBhIGJ1ZyBpbgp0aGUgcHJvY2Vzc2luZyBvZiBQTC9wZ1NRTCBwYXJhbWV0ZXIgbGlzdHM/DQoN CkJ5IHRoZSB3YXksIEknbSBjdXJyZW50bHkgd29ya2luZyBvbiBob3cgdG8gY29ycmVzcG9uZCBQ TC9wZ1NRTCBmdW5jdGlvbgpiZWhhdmlvciB0byBwbGFpbiBTUUwsIGFuZCBJJ20gY29uY2VybmVk IGFib3V0IHVzYWdlcyB0aGF0IHNob3VsZCBiZWhhdmUKY29uc2lzdGVudGx5IGluIFBML3BnU1FM IGZ1bmN0aW9ucyBhbmQgcGxhaW4gU1FMLCBhbmQgdGhpcyBpc3N1ZSB3YXMKZGlzY292ZXJlZCBp biB0aGlzIHdvcmsuDQoNCkluIHRoZSBkb2N1bWVudGF0aW9uIGl0IGlzIG1lbnRpb25lZCB0aGF0 DQpGdW5jdGlvbnMgd3JpdHRlbiBpbiBQTC9wZ1NRTCBjYW4gYWNjZXB0IGFzIGFyZ3VtZW50cyBh bnkgc2NhbGFyIG9yIGFycmF5CmRhdGEgdHlwZSBzdXBwb3J0ZWQgYnkgdGhlIHNlcnZlciBbM10u DQoNClRoaXMgc3VnZ2VzdHMgdGhhdCBpbiB0ZXJtcyBvZiBkYXRhIHR5cGVzLCB0aGVyZSBzaG91 bGQgYmUgbm8gZGlmZmVyZW5jZQpiZXR3ZWVuIFBML3BnU1FMIGZ1bmN0aW9ucyBhbmQgcGxhaW4g U1FMIGZvciB0aGUgc2FtZSB1c2FnZS4gQnV0IHRoaXMgZGVzaWduCmluIHRoZSBwYXJhbWV0ZXIg bGlzdCBzZWVtcyB0byBjb250cmFkaWN0IHRoaXMgaW5pdGlhbCBpbnRlbnRpb24uIEFyZSB0aGVy ZQphbnkgZGVzaWduIGNvbmNlcm5zIGhlcmU/DQoNCldoeSBub3QgaGFuZGxlIGZpeGVkLWxlbmd0 aCBDSEFSQUNURVIgYXMgd2VsbCBhcyBvbWl0dGluZyBsZW5ndGggc3BlY2lmaWVyCnZhcmlhYmxl LWxlbmd0aCBDSEFSQUNURVIgVkFSWUlORywgaW4gd2hpY2ggY2FzZSBldmVyeXRoaW5nIG1pZ2h0 IG1ha2Ugc2Vuc2UKWzRdLg0KDQpbMV0KaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvZG9jcy8x NS9kYXRhdHlwZS1jaGFyYWN0ZXIuaHRtbCM6fjp0ZXh0PWNoYXJhY3RlciUyMHdpdGhvdXQlMjBs ZW5ndGglMjBzcGVjaWZpZXIlMjBpcyUyMGVxdWl2YWxlbnQlMjB0byUyMGNoYXJhY3RlcigxKQ0K WzJdCmh0dHBzOi8vd3d3LnBvc3RncmVzcWwub3JnL2RvY3MvMTUvc3FsLWNyZWF0ZWZ1bmN0aW9u Lmh0bWwjOn46dGV4dD1wYXJlbnRoZXNpemVkJTIwdHlwZSUyMG1vZGlmaWVycyUyMChlLmcuJTJD JTIwdGhlJTIwcHJlY2lzaW9uJTIwZmllbGQlMjBmb3IlMjB0eXBlJTIwbnVtZXJpYyklMjBhcmUl MjBkaXNjYXJkZWQlMjBieSUyMENSRUFURSUyMEZVTkNUSU9ODQpbM10KaHR0cHM6Ly93d3cucG9z dGdyZXNxbC5vcmcvZG9jcy8xNS9wbHBnc3FsLW92ZXJ2aWV3Lmh0bWwjUExQR1NRTC1BUkdTLVJF U1VMVFM6fjp0ZXh0PUZ1bmN0aW9ucyUyMHdyaXR0ZW4lMjBpbiUyMFBML3BnU1FMJTIwY2FuJTIw YWNjZXB0JTIwYXMlMjBhcmd1bWVudHMlMjBhbnklMjBzY2FsYXIlMjBvciUyMGFycmF5JTIwZGF0 YSUyMHR5cGUlMjBzdXBwb3J0ZWQlMjBieSUyMHRoZSUyMHNlcnZlcg0KWzRdCmh0dHBzOi8vd3d3 LnBvc3RncmVzcWwub3JnL2RvY3MvMTUvZGF0YXR5cGUtY2hhcmFjdGVyLmh0bWwjOn46dGV4dD1J ZiUyMGNoYXJhY3RlciUyMHZhcnlpbmclMjBpcyUyMHVzZWQlMjB3aXRob3V0JTIwbGVuZ3RoJTIw c3BlY2lmaWVyJTJDJTIwdGhlJTIwdHlwZSUyMGFjY2VwdHMlMjBzdHJpbmdzJTIwb2YlMjBhbnkl MjBzaXplCgo= --===============7015417935958528846==--