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.96) (envelope-from ) id 1woA4K-000rnW-1l for pgsql-committers@arkaria.postgresql.org; Mon, 27 Jul 2026 01:23:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1woA3J-00AABb-22 for pgsql-committers@arkaria.postgresql.org; Mon, 27 Jul 2026 01:22:45 +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.96) (envelope-from ) id 1woA3J-00AAAG-19 for pgsql-committers@lists.postgresql.org; Mon, 27 Jul 2026 01:22:45 +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.98.2) (envelope-from ) id 1woA3H-00000000VXa-1nDM for pgsql-committers@lists.postgresql.org; Mon, 27 Jul 2026 01:22:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=peAGiZG5F6i8XN3xuwfIkHi+7Oro80Kq+tsRSrMy9EI=; b=tbv0Ylz0jBwisHtJy2vUM1U05B 4K2GzRdJkhSKRzP9WiPuPWrgo/2WAljsgeulG5SNRMLkzLClHaVGYYX0HuSLozy46KSUFT/+Q4wKz bsG1ex2k4q1/TFdmK9dsQiEJCwj26cQUUa7HEMMEieK5PO7rNiNy5WE1TDCX8/DQLDW0yUi78UYBM hRi4/WBSUqA0tIhkhBpnoaDpZYKu3E2pUU4ZDj3wrtvU227uSwAs8Uu95K2UT+sXDl+5DilTcg9Jy 2rQ09TuPaN5/05o6QQYOYrQ0bGZ8pjfCCSUscE7rWtr6oDBLIY3YDeW7VQlaaYRXh8TfB+GnmXWRH HBFpBtsA==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1woA3H-001eW8-0Z for pgsql-committers@lists.postgresql.org; Mon, 27 Jul 2026 01:22:43 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1woA3G-00000000SKO-3tBg for pgsql-committers@lists.postgresql.org; Mon, 27 Jul 2026 01:22:42 +0000 Content-Type: multipart/mixed; boundary="===============1940953429361544268==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix deparsing of JSON_ARRAY(subquery) with a FORMAT clause X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 27 Jul 2026 01:22:42 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1940953429361544268== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGRlcGFyc2luZyBvZiBKU09OX0FSUkFZKHN1YnF1ZXJ5KSB3aXRoIGEgRk9STUFUIGNsYXVz ZQoKQ29tbWl0IDhkODI5ZjVhMCBpbnRyb2R1Y2VkIHRoZSBKU0NUT1JfSlNPTl9BUlJBWV9RVUVS WSBjb25zdHJ1Y3Rvcgp0eXBlIHNvIHRoYXQgcnVsZXV0aWxzLmMgY291bGQgZGVwYXJzZSBKU09O X0FSUkFZKHN1YnF1ZXJ5KSB1c2luZyBpdHMKb3JpZ2luYWwgc3ludGF4LCBzdG9yaW5nIHRoZSB0 cmFuc2Zvcm1lZCBzdWJxdWVyeSBpbiBhIG5ldyBvcmlnX3F1ZXJ5CmZpZWxkLiAgSG93ZXZlciwg dGhlIGlucHV0IEZPUk1BVCBjbGF1c2Ugb2YgSlNPTl9BUlJBWShzdWJxdWVyeSBGT1JNQVQKLi4u KSB3YXMgbm90IHByZXNlcnZlZCBmb3IgZGVwYXJzaW5nLiAgVGhlIGZvcm1hdCB3YXMgcmVjb3Jk ZWQgb25seSBpbgp0aGUgZXhlY3V0YWJsZSBleHByZXNzaW9uIGtlcHQgaW4gdGhlIGZ1bmMgZmll bGQsIHdoaWNoIHJ1bGV1dGlscy5jCmRvZXMgbm90IGluc3BlY3QsIHNvIGl0IGlzIHNpbGVudGx5 IGRyb3BwZWQuCgpUaGlzIGlzIG1vcmUgdGhhbiBjb3NtZXRpYywgYmVjYXVzZSBGT1JNQVQgSlNP TiBjaGFuZ2VzIHRoZSByZXN1bHQ6CndpdGhvdXQgaXQgYSB0ZXh0IHZhbHVlIGlzIHRyZWF0ZWQg YXMgYSBzdHJpbmcgdG8gYmUgcXVvdGVkLCB3aGlsZQp3aXRoIGl0IHRoZSB2YWx1ZSBpcyB0cmVh dGVkIGFzIGFscmVhZHktZm9ybWF0dGVkIEpTT04uCgpUbyBmaXgsIHJlY29yZCB0aGUgaW5wdXQg Rk9STUFUIGluIGEgbmV3IGRlcGFyc2Utb25seSBmaWVsZCBvZgpKc29uQ29uc3RydWN0b3JFeHBy LCBhbG9uZ3NpZGUgb3JpZ19xdWVyeSwgYW5kIGVtaXQgaXQgaW4gcnVsZXV0aWxzLmMuCgpCdW1w IGNhdGFsb2cgdmVyc2lvbi4KCkF1dGhvcjogQ2hhbyBMaSA8bGkuZXZhbi5jaGFvQGdtYWlsLmNv bT4KUmV2aWV3ZWQtYnk6IEV3YW4gWW91bmcgPGtkYmFzZS5oYWNrQGdtYWlsLmNvbT4KUmV2aWV3 ZWQtYnk6IFJpY2hhcmQgR3VvIDxndW9mZW5nbGludXhAZ21haWwuY29tPgpEaXNjdXNzaW9uOiBo dHRwczovL3Bvc3Rnci5lcy9tLzRDODlCMTkzLTdENTQtNDcwNS05Q0Y5LUYwRDQ4NEI5RTA5OUBn bWFpbC5jb20KQmFja3BhdGNoLXRocm91Z2g6IDE5CgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0 YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZjRj ODUwZDExYWZjNjBhNGZjNGJjNzgyZmM0MGQ3Yjc1MmJmOGQ3ZgoKTW9kaWZpZWQgRmlsZXMKLS0t LS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvcGFyc2VyL3BhcnNlX2V4cHIuYyAgICAgICB8IDMgKysr CnNyYy9iYWNrZW5kL3V0aWxzL2FkdC9ydWxldXRpbHMuYyAgICAgfCAxICsKc3JjL2luY2x1ZGUv Y2F0YWxvZy9jYXR2ZXJzaW9uLmggICAgICB8IDIgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5v ZGVzLmggICAgICAgICB8IDUgKysrKysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zcWxqc29u Lm91dCB8IDcgKysrKysrKwpzcmMvdGVzdC9yZWdyZXNzL3NxbC9zcWxqc29uLnNxbCAgICAgIHwg OCArKysrKysrKwo2IGZpbGVzIGNoYW5nZWQsIDI1IGluc2VydGlvbnMoKyksIDEgZGVsZXRpb24o LSkKCg== --===============1940953429361544268==--