Re: remaining sql/json patches - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: remaining sql/json patches
Date
Msg-id Zg-VKJs-gmB0sYRK@paquier.xyz
Whole thread Raw
In response to Re: remaining sql/json patches  (Alexander Lakhin <exclusion@gmail.com>)
Responses Re: remaining sql/json patches
List pgsql-hackers
On Fri, Apr 05, 2024 at 09:00:00AM +0300, Alexander Lakhin wrote:
> Please look at an assertion failure:
> TRAP: failed Assert("count <= tupdesc->natts"), File: "parse_relation.c", Line: 3048, PID: 1325146
>
> triggered by the following query:
> SELECT * FROM JSON_TABLE('0', '$' COLUMNS (js int PATH '$')),
>   COALESCE(row(1)) AS (a int, b int);
>
> Without JSON_TABLE() I get:
> ERROR:  function return row and query-specified return row do not match
> DETAIL:  Returned row contains 1 attribute, but query expects 2.

I've added an open item on this one.  We need to keep track of all
that.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Alexander Lakhin
Date:
Subject: Re: remaining sql/json patches
Next
From: Ashutosh Bapat
Date:
Subject: Re: Statistics Import and Export