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 1wIbyO-008H3j-2P for pgsql-committers@arkaria.postgresql.org; Fri, 01 May 2026 00:43:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIbyM-009O8e-1p for pgsql-committers@arkaria.postgresql.org; Fri, 01 May 2026 00:43:14 +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 1wIbyM-009O8W-15 for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 00:43:14 +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 1wIbyJ-00000003bal-24zZ for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 00:43:13 +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=3Uv7dJzOwFpemdwQmyNBR38AN5Sdnp54b8NfR/dByDw=; b=RmpWQ1idwkq6yNOnQvKWHOFxNQ e0mdUxD57ObPKbRYJ4cBNMacrupReOygraxhFuK5cxFrOhvCFHN+Jb0e/vv/klcJuBeCKNKN7vqhX mBhm1IhwCQO2lxIioWhH162imTaYmQaHxN+rRJaXnB9EL4Frs9loogS+tBTJyn/L7qazZchjlhw5y Z3hgVS5ex74uJpSu672Wq+067RSyfZvep+eLwYU3v1Bc0bgcgJ6xJo0ZsPLiGs8CirG24ZVfVJFN1 KcLVZMCdP5yyzGrU4yz2r+73h9c87PlClLy1ps1crMfkx9tmbalD9y/Cxjpz+3mepwcs8RnPepDnm Qs60hdpQ==; 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 1wIbyI-00AwBz-2n for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 00:43:11 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wIbyH-003WgC-27 for pgsql-committers@lists.postgresql.org; Fri, 01 May 2026 00:43:10 +0000 Content-Type: multipart/mixed; boundary="===============7588481495351976851==" MIME-Version: 1.0 From: Richard Guo To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix JSON_ARRAY(query) empty set handling and view deparsing X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 01 May 2026 00:43:10 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7588481495351976851== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IEpTT05fQVJSQVkocXVlcnkpIGVtcHR5IHNldCBoYW5kbGluZyBhbmQgdmlldyBkZXBhcnNp bmcKCkFjY29yZGluZyB0byB0aGUgU1FML0pTT04gc3RhbmRhcmQsIEpTT05fQVJSQVkocXVlcnkp IG11c3QgcmV0dXJuIGFuCmVtcHR5IEpTT04gYXJyYXkgKCdbXScpIHdoZW4gdGhlIHN1YnF1ZXJ5 IHJldHVybnMgemVybyByb3dzLgoKUHJldmlvdXNseSwgdGhlIHBhcnNlciByZXdyb3RlIEpTT05f QVJSQVkocXVlcnkpIGludG8gYSBKU09OX0FSUkFZQUdHCmFnZ3JlZ2F0ZSBmdW5jdGlvbi4gIEJl Y2F1c2UgdGhpcyBhZ2dyZWdhdGUgZXZhbHVhdGVzIHRvIE5VTEwgb3ZlciBhbgplbXB0eSBzZXQg d2l0aG91dCBhIEdST1VQIEJZIGNsYXVzZSwgdGhlIGNvbnN0cnVjdG9yIGVycm9uZW91c2x5CnJl dHVybmVkIE5VTEwuICBBZGRpdGlvbmFsbHksIHRoaXMgcHJlbWF0dXJlIHJld3JpdGUgYmFrZWQg cGh5c2ljYWwKaW1wbGVtZW50YXRpb24gZGV0YWlscyBpbnRvIHRoZSBjYXRhbG9nLCBwcmV2ZW50 aW5nIHJ1bGV1dGlscy5jIGZyb20KZGVwYXJzaW5nIHRoZSBvcmlnaW5hbCBzeW50YXggZm9yIHZp ZXdzLgoKVGhpcyBwYXRjaCByZXNvbHZlcyBib3RoIGlzc3VlcyBieSBpbnRyb2R1Y2luZyBhIG5l dwpKU0NUT1JfSlNPTl9BUlJBWV9RVUVSWSBjb25zdHJ1Y3RvciB0eXBlLiAgVGhlIHBhcnNlciBi dWlsZHMgdGhlCmV4ZWN1dGFibGUgZm9ybSAtLS0gYSBDT0FMRVNDRS13cmFwcGVkIEpTT05fQVJS QVlBR0cgc3VicXVlcnkgLS0tIGZyb20KcmF3IHBhcnNlIG5vZGVzIHZpYSB0cmFuc2Zvcm1FeHBy UmVjdXJzZSwgYW5kIHN0b3JlcyBpdCBpbiB0aGUgZnVuYwpmaWVsZC4gIFRoZSBvcmlnaW5hbCB0 cmFuc2Zvcm1lZCBRdWVyeSBpcyBrZXB0IGluIGEgbmV3IG9yaWdfcXVlcnkKZmllbGQgc28gdGhh dCBydWxldXRpbHMuYyBjYW4gZGVwYXJzZSB0aGUgb3JpZ2luYWwgc3ludGF4IGZvciB2aWV3cy4K RHVyaW5nIHBsYW5uaW5nLCBldmFsX2NvbnN0X2V4cHJlc3Npb25zIHJlcGxhY2VzIHRoZSBub2Rl IHdpdGggdGhlCnByZS1idWlsdCBmdW5jIGV4cHJlc3Npb24uCgpUaGUgZGVwYXJzaW5nIGlzc3Vl IHdhcyByZXBvcnRlZCBieSBUb20gTGFuZS4KCkJ1bXAgY2F0YWxvZyB2ZXJzaW9uLgoKQnVnOiAj MTk0MTgKUmVwb3J0ZWQtYnk6IEx1a2FzIEVkZXIgPGx1a2FzLmVkZXJAZ21haWwuY29tPgpBdXRo b3I6IFJpY2hhcmQgR3VvIDxndW9mZW5nbGludXhAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogQW1p dCBMYW5nb3RlIDxhbWl0bGFuZ290ZTA5QGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9w b3N0Z3IuZXMvbS8xOTQxOC01OTFiYTFmMjk4NjJlZjViQHBvc3RncmVzcWwub3JnCgpCcmFuY2gK LS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3Jn L3BnL2NvbW1pdGRpZmYvOGQ4MjlmNWEwMjAzZWQ0Mzk1ZTJkNGQzOTMxY2QyMjVhMDBjMWIxNAoK TW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0KZG9jL3NyYy9zZ21sL2Z1bmMvZnVuYy1qc29u LnNnbWwgICAgICB8ICAgMyArLQpzcmMvYmFja2VuZC9ub2Rlcy9ub2RlRnVuY3MuYyAgICAgICAg IHwgIDExICsrKysKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvY2xhdXNlcy5jICB8ICAxNSAr KysrLQpzcmMvYmFja2VuZC9wYXJzZXIvcGFyc2VfZXhwci5jICAgICAgIHwgMTExICsrKysrKysr KysrKysrKysrKysrKysrKysrKystLS0tLQpzcmMvYmFja2VuZC91dGlscy9hZHQvcnVsZXV0aWxz LmMgICAgIHwgIDE1ICsrKysrCnNyYy9pbmNsdWRlL2NhdGFsb2cvY2F0dmVyc2lvbi5oICAgICAg fCAgIDIgKy0Kc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVzLmggICAgICAgICB8ICAyNiArKysr Ky0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL3NxbGpzb24ub3V0IHwgMTEzICsrKysrKysr KysrKysrKysrKysrKysrKysrKysrKysrLS0Kc3JjL3Rlc3QvcmVncmVzcy9zcWwvc3FsanNvbi5z cWwgICAgICB8ICA0OSArKysrKysrKysrKysrKysKOSBmaWxlcyBjaGFuZ2VkLCAzMTYgaW5zZXJ0 aW9ucygrKSwgMjkgZGVsZXRpb25zKC0pCgo= --===============7588481495351976851==--