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 ) id 1wa6h4-001XKD-2O for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Jun 2026 06:57:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wa6h3-00AFOf-1P for pgsql-bugs@arkaria.postgresql.org; Thu, 18 Jun 2026 06:57:41 +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 ) id 1wa6h3-00AFOV-0b for pgsql-bugs@lists.postgresql.org; Thu, 18 Jun 2026 06:57:41 +0000 Received: from mail-pf1-x429.google.com ([2607:f8b0:4864:20::429]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wa6h1-00000000vrO-2j1k for pgsql-bugs@lists.postgresql.org; Thu, 18 Jun 2026 06:57:40 +0000 Received: by mail-pf1-x429.google.com with SMTP id d2e1a72fcca58-8453f568e84so368090b3a.0 for ; Wed, 17 Jun 2026 23:57:39 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1781765858; cv=none; d=google.com; s=arc-20240605; b=ZI1PkwUgHnLiXRwAn8uSnpgRtY5E907u4vGErbTSmAOAX7k8G8woz1+tg3Z46HGx6D 1VviZvEFxTr/WKm0ZfGWZCz/+9O3HDCK1nfj9Phv6sISYGGfyeb8clleqG3DgPodEFCr FHAt/vGX+7Mde/J6pUKwPmyQ/cXH9P46P/aCncuZZUR6LvWotieO6BnnMqQmicRQVafH 39gs6+FLaJX7HcZowbyEqpkLW4fiAex6KsaTBHbKjpeWW2s+bGAKWb5DDz7yt2FAzF73 /Nqk6JPcaXGF8pkG0KQE1L8gWe4sWMKZ7i3KJdkRqxQuD4KuQm0jiABpodBxG7Voe4y1 oj2A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=9CL7jFaKhY8HmLnhymQRAksxGClzHNvR+NPhesal3OU=; fh=KrLGn7qdcU+vx1SlD5/F+43oTi4GvFsHCRs0HiGmB9A=; b=RGaj2CY+5ZNztkXXQvkcmDFDBMOH+PWao+mEYNr4twkmPNPcB3eDuPuq1fslttvbbp gN0T4zyLAjH9yM8lbec3MAls49xLA5PtKjvo6kDqp2WmPdTPSF1R6I/R3qsNruv2huMB 2SUgNQFavYOe4AIMz3N06dGxW0RL2d1OkRKerGSxWpsHpolTIviElfIv8FdypuLshIPO 8Wj31yxsA9k4l+YPZJcp8Mg4YoqbG2PnvKN7wJly6iLMLEwUsbBjeUMN6iWdLsGr7EMe 5xToSZlCaJs3+RcTP83Z3YBoiO7fNP6tVcSwESzNVeoERofK0DPmG5QVH3PNdmTewC+M BzzQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1781765858; x=1782370658; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=9CL7jFaKhY8HmLnhymQRAksxGClzHNvR+NPhesal3OU=; b=bBrqjy39iX6hmkmjbTxRJmAi5CErCiXuzREGR+D/aJmokkzx1+Vx5G/imGwYGH1ylM mdqu681MOThWzFwM9aZdl9L/iYAa4whNL+Vc66w49VYU0cCzXjdUp1k/jtgR3kaU3aWg Yyu2AJbmVqmHTv3z8DPiozc9Qdumn14E4/aXBAmNuq7Gq3hXXBtOOsAqT5S5fQigQTcl nxZ79OO4Ql/uHsFjFbpwKzJCuttE6gW4SJXr8ZgRHFbslihrXGByMvavbovNxBjyVAWh WPwum5K2d3wITwTIX44osWxV3Hu2Pa/J2YQikU2FKQ3D/F0VJou2xf519YMXMjrQNtUU JvKA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781765858; x=1782370658; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=9CL7jFaKhY8HmLnhymQRAksxGClzHNvR+NPhesal3OU=; b=QNKTyMx8SvYmzRUTDJUV5iRbpS5eJDbTSYoh7JIV+ZVK2Q88tlAzU2OJlk8d0yXXaw 5drUJ+2AwuTcFgpHLUx2AFzYMs6x9fGhXQEZnqhCLEAEnkSQdfvuRTOtqAyWrKLi1sOx eoElClEyez8pAWOp/CvbFnhIs6fHDSGm3RGKxhT7yNyeMKKuGGz+V66fr3EyHZOpS0LQ uzWopyd5V1Jn95KFKCD63eHmtnY0DAsmSbjud1QeL6MBmw86B2mbxf38WjKMeVvXvCYO /Le+CjJsanffCfJpsYRky4jS8ZvBTRKFkTv2i56H1GtaCGmwuW6aNIkPUflJ8oSx2V0d 3BOA== X-Forwarded-Encrypted: i=1; AFNElJ/JMxEdNrh5mZHDBGCHYI5//JDVv7H0B+FMn3AvyFy/znd3AGe/3uAcLT++voWnuDyKqDr8LBkKjPSQ@lists.postgresql.org X-Gm-Message-State: AOJu0YzGdcJKbjW5AfKjZa2cWVyIgV5RvsHqRyv4vVbup8LSNhwYl0zT /nFM7OET6xlV79PU953OhieIOSmVJyj0FHoRXAg6n3UP2hyuj5lEiUOGHbhchCphCUepG8pGfOa JNaP1FSpRwg1Mz4uo6ABSRHslEVO5Uss= X-Gm-Gg: Acq92OE1hyMgdVdNU8QKs4r/vEZ9E7vfzjtPQgnEz4z8JMZkhrBfH1oma+Zrkd/m9sG Oef7t9MZSwTnFD7vrfnP61P0Y9LVNgdTe21Mk32+GxAiF4EWBgzdCGEtS5meWv0BOT0xM1eUv+A dxVvderW+Oq0bzz2VC36cK5KPZncMY9PXkCS/G/kz68QKmFqNCxaOC54ECg9RbZWlswMtInJ8mW Y8mTEjCCNto4XwD0pQklLumTWPWYNh7xvSiv4KCLyt/0iv+pM3PukctS/A07KgqvY6HCbCcATI5 6VYv98yUepaVIfmDjo8nx4+syq8ujoXy4S57a7IJIWWiPzUDH7hcpA== X-Received: by 2002:a05:6a00:2d87:b0:845:42a7:ae81 with SMTP id d2e1a72fcca58-84542a7cde5mr1165376b3a.10.1781765858433; Wed, 17 Jun 2026 23:57:38 -0700 (PDT) MIME-Version: 1.0 References: <19458-a69c98bc498333ba@postgresql.org> <6DE4A9D6-6D5C-41C0-8AFE-F51CFBDDAD5A@yandex-team.ru> <674AEA44-D9C5-423D-B118-693CA130106E@yandex-team.ru> In-Reply-To: From: Amit Langote Date: Thu, 18 Jun 2026 15:57:20 +0900 X-Gm-Features: AVVi8CfwOPyz1R82czUthByxv2IOLf2qcFn7T7qdDlOZahLzUGtQXVttasJgQQE Message-ID: Subject: Re: BUG #19458: OOM killer in jsonb_path_exists_opr (@?) with malformed JSONPath containing non-existent variables To: Andrey Rachitskiy Cc: Andrey Borodin , Nikita Malakhov , PostgreSQL mailing lists , Nikolay Shaplov Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Jun 17, 2026 at 6:58=E2=80=AFPM Andrey Rachitskiy wrote: > > Hi Amit, > > I tested patch v2-0001-Report-undefined-jsonpath-variable-when-no-variab.= patch on: > > REL_14_STABLE > REL_15_STABLE > REL_16_STABLE > > Results: > The patch applies cleanly on all three branches. > Regression tests added/affected by the patch pass on all three branches: > REL_14: all relevant tests passed > REL_15: all relevant tests passed > REL_16: all relevant tests passed > The provided jsonpath reproducer query now consistently returns an error = about an undefined jsonpath variable on all three branches, which matches t= he expected behavior change from this patch. > > Conclusion: > The patch looks good from the testing side and can be merged. Thanks for checking, pushed. --=20 Thanks, Amit Langote