Re: SQL/JSON: functions

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Oleg Bartunov <obartunov(at)postgrespro(dot)ru>, Erik Rijkers <er(at)xs4all(dot)nl>
Subject: Re: SQL/JSON: functions
Date: 2021-09-16 14:52:24
Message-ID: 50df2280-7c7a-dffd-a942-9c67b1550e2c@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On 9/14/21 8:55 AM, Andrew Dunstan wrote:
> On 9/2/21 2:50 PM, Andrew Dunstan wrote:
>> On 5/18/21 3:22 PM, Andrew Dunstan wrote:
>>> On 5/8/21 2:21 PM, Andrew Dunstan wrote:
>>>> On 4/28/21 5:55 PM, Andrew Dunstan wrote:
>>>>> On Fri, Mar 26, 2021 at 9:14 PM Nikita Glukhov
>>>>> <n(dot)gluhov(at)postgrespro(dot)ru <mailto:n(dot)gluhov(at)postgrespro(dot)ru>> wrote:
>>>>>
>>>>> Attached 54th version of the patches rebased onto current master.
>>>>>
>>>>> On 27.03.2021 01:30, Andrew Dunstan wrote:
>>>>>> Specifically, patch 4 (SQL-JSON-query-functions) fails with this when
>>>>>> built with LLVM:
>>>>>>
>>>>>>
>>>>>> There is also a bug that results in a warning in gram.y, but fixing it
>>>>>> doesn't affect this issue. Nikita, please look into this ASAP.
>>>>> LLVM issues and gram.y are fixed.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> It's apparently bitrotted again. See
>>>>> <http://cfbot.cputube.org/patch_33_2901.log
>>>>> <http://cfbot.cputube.org/patch_33_2901.log>>
>>>>>
>>>>>
>>>> This set should remove the bitrot.
>>>>
>>>>
>>> Rebased for removal of serial schedule
>>>
>>>
>> rebased on master and incorporating fixes from Erik Rijkers
>>
>>
> rebased to remove bitrot from the removal of the  Value node type.
>
>

Rebased, and fixed a bug (which I had faithfully replicated above) in
the APP_JUMB code, as reported by Erik Rijkers.

cheers

andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

Attachment Content-Type Size
0001-Common-SQL-JSON-clauses-v59.patch text/x-patch 30.7 KB
0002-SQL-JSON-constructors-v59.patch text/x-patch 186.8 KB
0003-IS-JSON-predicate-v59.patch text/x-patch 54.5 KB
0004-SQL-JSON-query-functions-v59.patch text/x-patch 195.7 KB
0005-SQL-JSON-functions-for-json-type-v59.patch text/x-patch 57.0 KB
0006-GUC-sql_json-v59.patch text/x-patch 23.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2021-09-16 14:55:39 Re: SQL/JSON: JSON_TABLE
Previous Message Magnus Hagander 2021-09-16 14:38:04 Re: pgstat_send_connstats() introduces unnecessary timestamp and UDP overhead