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 |
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 |