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 1wEzfr-004e4H-2d for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Apr 2026 01:13:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wEzfp-005BW7-1X for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Apr 2026 01:13:09 +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 1wEzfp-005BVn-0h for pgsql-bugs@lists.postgresql.org; Tue, 21 Apr 2026 01:13:09 +0000 Received: from mail-ot1-x335.google.com ([2607:f8b0:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wEzfm-000000020WF-3qYf for pgsql-bugs@lists.postgresql.org; Tue, 21 Apr 2026 01:13:08 +0000 Received: by mail-ot1-x335.google.com with SMTP id 46e09a7af769-7dca00c1591so953030a34.3 for ; Mon, 20 Apr 2026 18:13:07 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1776733986; cv=none; d=google.com; s=arc-20240605; b=RknrrUoZ/G7L562I2WhfWqR658JAyZKKhu2PkhyoedwDRmFLyYPemlFAWQZrmuDc3O E7dhwIsfjtusAOs11SuhrJX3xdH5WiqC2/NqvEK2Yvi8mbA/wrTiL0oGZtPZoDdGPbCo kHFgaEzJQFPX/CSNGLfP675/BY1DDlK46EMjWTkq+JkH+ZHZQfqtwouP6Uw0tXcdkHCZ 5dJatqZA1nkA/qoXBjG1gPRneiUKRZkPq4OfDYFpQUYKUM77rIzqbPP9QbT1VCVy1Avh GBzv8POwKveQwkAtUf0xmHGIVzh1fDqyXiRlD/DDPD6pIm/SjEOf6OHNNyJDBFjJzVSI cVDQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=FdGFx8jHqi7fDl6PJ9f0rfyiAjYL1n3OEyiCoM2GDAE=; fh=d+GkVEy+dqhZQDkbdBqktXJT+cqMl58FiEWO9UCy3HA=; b=IUW4qbSb/U3q8IEf6/FZomY9k3infs04QDbLmJM/38L3BBjts5ld+571jLshSZPd4r BN9F6kIYQ0N8s+fVGLJoeDph5XmONj9vLEyXbSZ+qHj8BfXrjKINxYpPp90ItgkHUPIP VGT5lFMs/0Mnj/TBCuC+gOg8+QUDMk49fbBDzzMlw9n971hhovZfTIyliv/uKZR7DH1e Je8Yhnu4OHUOdDVuWg/wDuYLDAPlJg7VOFWIsCKwHVo3YrdRtQmJeVbIveFLRo5ljN7o 9x4jInwx7L/u2eIWGn0hyCNVicA6I499uYvWe6/vI9c/1lFZbWhg7gcCz2fu+aJT2g+4 gZdg==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1776733986; x=1777338786; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=FdGFx8jHqi7fDl6PJ9f0rfyiAjYL1n3OEyiCoM2GDAE=; b=dPJA7YDxZLvIvGZJDUsLaEOZdNrslZ/hzrsJYkYVm1LyFzXGsDk062h8W+OQviTS4A IFeDRChlol1qO2tzEWHcdtzuerB+f1yMxMgOC8hM9rKW+jPYaiqClUisHxhXsSl8W4Ew /8XpzY6s6hTTr4S9U50OIuL/Tu6LA71V6YRzCRdEBGFhlVPH+Tu7nFtqEhNWuxltCUWv 7WczDdkLqB0IQINnCaJhoB3jjjY21QnFNN84BfZbJFRSs5xfZmveSqjhc0m+7uvCF2T7 U71zPWT5ir2Zgp1gsdHFMEoirUHt0beQnK3VqYBSWKdGQOaELIto3/GAcmBomRKDLxEI IU+w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1776733986; x=1777338786; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=FdGFx8jHqi7fDl6PJ9f0rfyiAjYL1n3OEyiCoM2GDAE=; b=onGvK+qNDSXfmi+6axLB8zKlcfrK2llXu7Ul9ydjaQlnyJYOA4+feZk8W/QwTrKKwe QioNtcHUetFePE0qv9r62Y8vqVHnKlbRsM+9zsXdyLK3nC2dXjEZIh8OOWYogMMkKzVK tiUCrGpnsNKZ+JlGw+d5yGPF4B1VBurKehXLF0UI5Okx5g4Fn4v9v4NlaKvoPEv4ynX5 ee92Z8kfx/41yTu195G7ALXYQGh3WimsTHEBKOt2RqEyt2DBD3+ZFU1pM7W7wg5h4itb 325iwYUWYgQ1JQjCMcaJ87+WfUHpQUZsBlh1F2ML5S0NmBX24uifEH3KBkHOzWl+0ZxU o0YA== X-Forwarded-Encrypted: i=1; AFNElJ+mNu74oeLg/dFdlqoDci2RlerQCJpCAJChNl1DbqPQzMGtVOFOX6nfbEPgr5E14EU7MquuvzEUcdjG@lists.postgresql.org X-Gm-Message-State: AOJu0Yx4NfxZ9AgJ6uQhq4nmzdq9GNPjftqOWiWXl4/AAJRQoMTlVeJN x6mEVBVxLQDomv2hVOWNK0OhplSvZXA8YrZAnpSJqDrLH3Slg9v2AWzBgooYy6fYKwjSz58tZoz m/Qo1FnMwYye1pnNlGWO+GUMIXHKEMn0= X-Gm-Gg: AeBDies1beD57YcTTydemXaAbT+38FCwx+9iCMrpqFcqfX9ibw8vDk5we5qX/41+rf8 MvB3h5rzvoO/xfGtc8ql1cUJlKPSuvA799f+E+fx6Vsf4J7t/wfPkGFWi01NJAZy4bJ+LPA3+aP qi6x59ZxGUJx4v9XT2e3yp6pO34kJ64l8r/v3ALPQrZ/q6lf7/t1ZSZITZkFNO0nQbbTtffn1Nq he8zrUttVZMJPNwJhByHq+Yx71DTZ1pnQ8U0fJdPPzCFKIUU72255eXR8Fp2tT+ocl5NSAobMVb fbTRtVyDup9TGOkMJdQV X-Received: by 2002:a4a:e84a:0:b0:692:a19b:af6b with SMTP id 006d021491bc7-69462e57b48mr8531834eaf.13.1776733986608; Mon, 20 Apr 2026 18:13:06 -0700 (PDT) MIME-Version: 1.0 References: <19418-591ba1f29862ef5b@postgresql.org> <2abdb464-27f5-4759-bb0b-f09ab5b5ceab@postgresfriends.org> <501040.1772433449@sss.pgh.pa.us> In-Reply-To: From: Richard Guo Date: Tue, 21 Apr 2026 10:12:55 +0900 X-Gm-Features: AQROBzDNjuXi2RZVbDCTrfd3hnm6dMIY5xUiQfs_uX01K2fj4nXSx3fKPbGllCM Message-ID: Subject: Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 To: Amit Langote Cc: Tom Lane , Vik Fearing , lukas.eder@gmail.com, pgsql-bugs@lists.postgresql.org, =?UTF-8?Q?=C3=81lvaro_Herrera?= Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 21, 2026 at 9:57=E2=80=AFAM Richard Guo wrote: > On Mon, Apr 20, 2026 at 6:05=E2=80=AFPM Amit Langote wrote: > > Agreed that v4 is the better direction. > Thanks for review! Another question I'd like to raise: is it OK to commit this patch to master given that feature freeze has passed? I think the answer is yes, because this is arguably a bug fix rather than a new feature. However, it does change user-visible behavior, and existing app code that relies on the NULL behavior would break. So if we commit it, we need to add in the release notes about this incompatibility. Thoughts? - Richard