| 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: | Whole Thread | Raw Message | 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 |