From: Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Subject: Re: SQL/JSON: functions
To: Andrew Dunstan <andrew@dunslane.net>,
 Nikita Glukhov <n.gluhov@postgrespro.ru>
Cc: Ibrar Ahmed <ibrar.ahmad@gmail.com>,
 PostgreSQL-development <pgsql-hackers@postgresql.org>,
 Zhihong Yu <zyu@yugabyte.com>, Michael Paquier <michael@paquier.xyz>,
 Justin Pryzby <pryzby@telsasoft.com>, Pavel Stehule
 <pavel.stehule@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>,
 Thomas Munro <thomas.munro@gmail.com>, Andrew Alsup
 <bluesbreaker@gmail.com>, Andres Freund <andres@anarazel.de>,
 Dmitry Dolgov <9erthalion6@gmail.com>,
 Oleg Bartunov <obartunov@postgrespro.ru>, Erik Rijkers <er@xs4all.nl>,
 Simon Riggs <simon@2ndquadrant.com>
References: <be40362b-7821-7422-d33f-fbf1c61bb3e3@postgrespro.ru>
 <d05e0b43-9d3c-2b33-315c-b2351011d4f5@2ndQuadrant.com>
 <20200917054100.GS2873@paquier.xyz>
 <5b0c37d4-9201-7596-dd39-663522b34b15@postgrespro.ru>
 <CALNJ-vSojGWni=rpAjJqf6-sUWoL-_aLQwWTVoQQS2j2g34GKg@mail.gmail.com>
 <CALNJ-vSmJbaoUm7nuyV65UdeYTee2UxqG49CZ7CjR_rEB5ZdJg@mail.gmail.com>
 <5f8987e9-4c3d-6402-b18c-b3e84b786739@postgrespro.ru>
 <0feb891c5a60d17eca49dc77c93d86fb@xs4all.nl>
 <CALtqXTdHvT+tsGm4=aGL9=vFuiRX=dk0fHGtAjqCe=QSQmWKwA@mail.gmail.com>
 <ba5eb2a3-fe35-66bc-2ed1-a3624f15ec8a@dunslane.net>
 <edd10ba6-8600-075f-f035-e11f8de7ab30@dunslane.net>
 <ea71320c-0fdb-522d-4ada-f2bd42d173f9@dunslane.net>
 <24c35f9a-d11d-855e-ebfc-5638993c8d99@postgrespro.ru>
 <CAD5tBcL5pr673RUED4Diy4PV7yKpY1HX_rt0N_W1d9XtLoC7kA@mail.gmail.com>
 <55a4a276-2ed7-077b-8c4e-8209b58ebbf5@dunslane.net>
 <cbda15f2-3f3c-434a-51b3-772b60901f0b@2ndQuadrant.com>
 <264268a3-f836-487f-b56e-0a19739ca03b@dunslane.net>
Message-ID: <97da94b2-dcfd-20cf-2ed7-b9f68c6b6c16@2ndQuadrant.com>
Date: Tue, 14 Sep 2021 08:55:59 -0400
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.4.0
MIME-Version: 1.0
In-Reply-To: <264268a3-f836-487f-b56e-0a19739ca03b@dunslane.net>
Content-Type: multipart/mixed;
 boundary="------------DE4D62B6480273A9C591CBA1"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/97da94b2-dcfd-20cf-2ed7-b9f68c6b6c16%402ndQuadrant.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------DE4D62B6480273A9C591CBA1
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit


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.gluhov@postgrespro.ru <mailto:n.gluhov@postgrespro.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.


cheers


andrew


-- 

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


--------------DE4D62B6480273A9C591CBA1
Content-Type: text/x-patch; charset=UTF-8;
 name="0001-Common-SQL-JSON-clauses-v58.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="0001-Common-SQL-JSON-clauses-v58.patch"