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 1qiDU5-005XPw-HD for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Sep 2023 12:36:13 +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 1qiDU3-000bBo-OW for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Sep 2023 12:36:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiCid-000JBB-HW for pgsql-bugs@lists.postgresql.org; Mon, 18 Sep 2023 11:47:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qiCiW-005F2q-Ek for pgsql-bugs@lists.postgresql.org; Mon, 18 Sep 2023 11:47: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=ngP+8Tv9ew/gbyTDj0fCYAB7u3CBs09Mv/KuTsYwp3U=; b=VMW1WPObJhQ6selVPTKA9hNdlT U7pv/Kg0wq6ZgRxNilJpjeKfo114uuKmlbhc8BQPKvqFJscPiKY3ZpSyZaI+NEOqqccO1cHfUW3Ll wTJ7GXLo2qmKImvC608kvDVIVz4DR9s8hpHjrfwUr9tFPouRBy/onVcGlXS/2kQZMWMlVFiT6xYrJ gYVvwn0IUIBBE52Bf/70AfPUcEW2LF3ISusbc3RmirC65EHKsCHt85j2S1MmUJ+1fMA9AL62qXBKV kAcaSt3NAbVqW06sdOp/AEQi1OcCmVHaVvFX72jT/fngTOBVN8UjP2U3PsqptfBROWywB918Tu2u5 zsHnICdw==; 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 1qiCiV-0000my-P3 for pgsql-bugs@lists.postgresql.org; Mon, 18 Sep 2023 11:47:04 +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 1qiCiU-0004KN-0l for pgsql-bugs@lists.postgresql.org; Mon, 18 Sep 2023 11:47:02 +0000 Content-Type: multipart/mixed; boundary="===============5800411620706726600==" MIME-Version: 1.0 Subject: BUG #18116: This is definitiv a BUG in INOUT parameter in stored procedures in Postgres 12.16 To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: wlaunhardt@web.de Reply-To: wlaunhardt@web.de, pgsql-bugs@lists.postgresql.org Date: Mon, 18 Sep 2023 11:46:22 +0000 Message-ID: <18116-0a17d1321c9d94ea@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 --===============5800411620706726600== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODExNgpMb2dnZWQgYnk6ICAgICAgICAgIFdvbGZnYW5nIExhdW5oYXJk dApFbWFpbCBhZGRyZXNzOiAgICAgIHdsYXVuaGFyZHRAd2ViLmRlClBvc3RncmVTUUwgdmVyc2lv bjogMTIuMTYKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCBNaW50IDIwLjMgQ2lubmFtb24KRGVz Y3JpcHRpb246ICAgICAgICAKClBsZWFzZSBkb24ndCBzZW5kIG1lIHRoYXQgYWdhaW4gLSBpdCBp cyBhIEJVRyAhIDoNCiINCkJVRyAjMTgxMDY6IFN0b3JlZCBQcm9jZWR1cmUgKFRleHQtKUFycmF5 IGFzIElOT1VUIHBhcmFtZXRlcg0KDQpoYXMgYmVlbiByZWplY3RlZCBieSBhIG1vZGVyYXRvciBh bmQgd2lsbCBub3QgYmUgcG9zdGVkLg0KVGhlIHJlYXNvbiBnaXZlbiBmb3IgcmVqZWN0aW9uIHdh czoNCg0KVGhpcyBkb2VzIG5vdCBhcHBlYXIgdG8gYmUgYSBidWcgcmVwb3J0LiINCg0KRE8gDQok JA0KREVDTEFSRSANCiAgdGVzdCB0ZXh0W107DQpCRUdJTg0KICB0ZXN0IDo9ICd7IngiLCJ5Iiwi eiJ9JzsNCiAgQ0FMTCBwdGVzdCggdGVzdCApOw0KICBSQUlTRSBOT1RJQ0UgJyUnLCB0ZXN0Ow0K RU5EDQokJDsNCg0KUFJPRFVDRVM6DQpFUlJPUjogdHlwZSB3aXRoIE9JRCAwIGRvZXMgbm90IGV4 aXN0DQpDT05URVhUOiBTUUwgc3RhdGVtZW50ICJDQUxMIHB0ZXN0KCB0ZXN0ICkiIFBML3BnU1FM IGZ1bmN0aW9uCmlubGluZV9jb2RlX2Jsb2NrIGxpbmUgNiBhdCBDQUxMDQoNCg0KSU4gQSBGVU5D VElPTiBJVCBXT1JLUzoNCmNyZWF0ZSBvciByZXBsYWNlIEZVTkNUSU9OIHB0ZXN0KElOT1VUIHRl eHRbXSApIHJldHVybnMgdGV4dFtdIGFzICdwdGVzdC5zbycKbGFuZ3VhZ2UgJ2MnOw0KDQpDLVNv dXJjZToNCg0KI2luY2x1ZGUgPHN0ZGlvLmg+DQojaW5jbHVkZSA8c3RkbGliLmg+DQojaW5jbHVk ZSA8c3RyaW5nLmg+DQojaW5jbHVkZSAicG9zdGdyZXMuaCINCiNpbmNsdWRlICJmbWdyLmgiDQoj aW5jbHVkZSAiZnVuY2FwaS5oIg0KI2luY2x1ZGUgImFycmF5LmgiDQoNClBHX01PRFVMRV9NQUdJ QzsNCg0KRGF0dW0gcHRlc3QoUEdfRlVOQ1RJT05fQVJHUyk7DQoNClBHX0ZVTkNUSU9OX0lORk9f VjEocHRlc3QpOw0KDQpEYXR1bQ0KcHRlc3QgKCBQR19GVU5DVElPTl9BUkdTICkNCnsgDQogICBB cnJheVR5cGUgICAgICAgKiBhcmdfYXJyOw0KDQogICBhcmdfYXJyID0gUEdfR0VUQVJHX0FSUkFZ VFlQRV9QKCAwICk7DQoNCiAgIFBHX1JFVFVSTl9BUlJBWVRZUEVfUCggYXJnX2FyciApOw0KDQog ICAvLyBURVhUT0lEID0gMjUgdGhlIGZvbGxvd2luZyBjb2RlIHByb2R1Y2VzIHRoZSBzYW1lIGVy cm9yOg0KICAgLy8gUEdfUkVUVVJOX0FSUkFZVFlQRV9QKCBjb25zdHJ1Y3RfZW1wdHlfYXJyYXko IDI1ICkpOw0KfQoK --===============5800411620706726600==--