Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wTgIF-000gc2-14
	for pgsql-bugs@arkaria.postgresql.org;
	Sun, 31 May 2026 13:33:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wTgID-007egx-0a
	for pgsql-bugs@arkaria.postgresql.org;
	Sun, 31 May 2026 13:33:29 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <x4mmm@yandex-team.ru>)
	id 1wTgIC-007egp-31
	for pgsql-bugs@lists.postgresql.org;
	Sun, 31 May 2026 13:33:29 +0000
Received: from forwardcorp1b.mail.yandex.net
 ([2a02:6b8:c02:900:1:45:d181:df01])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <x4mmm@yandex-team.ru>)
	id 1wTgIA-00000000QIU-0NCQ
	for pgsql-bugs@lists.postgresql.org;
	Sun, 31 May 2026 13:33:28 +0000
Received: from mail-nwsmtp-smtp-corp-canary-81.sas.yp-c.yandex.net
 (mail-nwsmtp-smtp-corp-canary-81.sas.yp-c.yandex.net
 [IPv6:2a02:6b8:c21:271d:0:640:65b1:0])
	by forwardcorp1b.mail.yandex.net (Yandex) with ESMTPS id 84FC680764;
	Sun, 31 May 2026 16:33:18 +0300 (MSK)
Received: from smtpclient.apple (unknown [2a02:6bf:8080:541::1:3c])
	by mail-nwsmtp-smtp-corp-canary-81.sas.yp-c.yandex.net (smtpcorp) with
 ESMTPSA id GXdPOl1YJSw0-KKe8VTnV;
	Sun, 31 May 2026 16:33:18 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru;
	s=default; t=1780234398;
	bh=xslmmV6CkOz2OBLbLGoDl5yIzRPykg64W75P4hqq+tM=;
	h=Message-Id:To:Date:References:Cc:In-Reply-To:From:Subject;
	b=T1f2Ius8JMMj3udTZ4gPVfbaC1Tko5IQgopRTayJdqk6NCLhsARI2dP6pOnrq45wH
	 VwLT1+KPKZji2PZMZLLlduWduRK+PCA/WNF8I8TQPePRUzbw6MDaxeId02xaDRZ+sC
	 WDrl8nV4JVI2kRLgaRjZwIBhjn6VIjvpOD4MDWJk=
Authentication-Results: mail-nwsmtp-smtp-corp-canary-81.sas.yp-c.yandex.net;
 dkim=pass header.i=@yandex-team.ru
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\))
Subject: Re: BUG #19458: OOM killer in jsonb_path_exists_opr (@?) with
 malformed JSONPath containing non-existent variables
From: Andrey Borodin <x4mmm@yandex-team.ru>
In-Reply-To: 
 <CAN-LCVPiBi9XXW__RorX=dH2_fANAMXhdbULmHFFg97F_0ubRw@mail.gmail.com>
Date: Sun, 31 May 2026 18:33:06 +0500
Cc: Amit Langote <amitlangote09@gmail.com>,
 Andrey Rachitskiy <pl0h0yp1@gmail.com>,
 PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>,
 Nikolay Shaplov <dhyan@nataraj.su>
Content-Transfer-Encoding: 7bit
Message-Id: <674AEA44-D9C5-423D-B118-693CA130106E@yandex-team.ru>
References: <19458-a69c98bc498333ba@postgresql.org>
 <CAB8bMit1HvJsAasUYwmq+82Oa3zQhJyvsHNS4PGF_S_BCMnuVA@mail.gmail.com>
 <AE0E8193-85BD-4A10-BE23-582D92DA281D@yandex-team.ru>
 <CAN-LCVNh2z4EE+F21XPe7XRSWfPFtZx1WYAswpU5qs+RdR=jjg@mail.gmail.com>
 <6DE4A9D6-6D5C-41C0-8AFE-F51CFBDDAD5A@yandex-team.ru>
 <CAN-LCVPiBi9XXW__RorX=dH2_fANAMXhdbULmHFFg97F_0ubRw@mail.gmail.com>
To: Nikita Malakhov <hukutoc@gmail.com>
X-Mailer: Apple Mail (2.3864.600.51.1.1)
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/674AEA44-D9C5-423D-B118-693CA130106E%40yandex-team.ru>
Precedence: bulk



> On 26 May 2026, at 16:17, Nikita Malakhov <hukutoc@gmail.com> wrote:
> 
> of course OOM is very bad behavior and should be corrected

I think the biggest problem is not OOM, but incorrect results for query
SELECT '42'::jsonb @? '$"no_such_var"';


Best regards, Andrey Borodin.