Re: sql/json remaining issue

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: sql/json remaining issue
Date: 2024-04-18 00:33:23
Message-ID: CA+HiwqGcP+YbtEhsK8WYeLtE4nHO_e0SjbYg1b3aQojiYYgWXQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Apr 15, 2024 at 9:46 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Sat, Apr 13, 2024 at 11:12 PM jian he <jian(dot)universality(at)gmail(dot)com> wrote:
> > On Fri, Apr 12, 2024 at 5:44 PM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> > >
> > > > elog(ERROR, "unrecognized json wrapper %d", wrapper);
> > > > should be
> > > > elog(ERROR, "unrecognized json wrapper %d", (int) wrapper);
> > >
> > > Fixed in 0003.
> > >
> > the fix seems not in 0003?
> > other than that, everything looks fine.

Oops, really fixed now in 0002.

> I've combined these patches into one -- attached 0001. Will push tomorrow.

Decided to break the error message improvement patch into its own
after all -- attached 0001.

> Now studying the JsonBehavior DEFAULT expression issue and your patch.

I found some more coercion-related expression nodes that must also be
checked along with CoerceViaIO and CoerceToDomain. Also, after fixing
the code to allow them, I found that we'd need to also check
recursively whether their argument expression is also one of the
supported expression nodes. Also, I decided that it's not necessary
to include "cast" in the error message as one of the supported
expressions.

Will push all today.

--
Thanks, Amit Langote

Attachment Content-Type Size
v5-0002-SQL-JSON-Miscellaneous-fixes-and-improvements.patch application/octet-stream 4.9 KB
v5-0001-SQL-JSON-Improve-some-error-messages.patch application/octet-stream 17.0 KB
v5-0003-SQL-JSON-Fix-issues-with-DEFAULT-.-ON-ERROR-EMPTY.patch application/octet-stream 11.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2024-04-18 00:42:08 Re: ALTER TABLE SET ACCESS METHOD on partitioned tables
Previous Message Thomas Munro 2024-04-18 00:31:05 Re: Cannot find a working 64-bit integer type on Illumos