Re: "memory exhausted" in query parser/simplifier for many nested parentheses

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Niklas Hambüchen <mail(at)nh2(dot)me>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org, ruben(at)benaco(dot)com, Niklas Hambüchen <niklas(at)benaco(dot)com>
Subject: Re: "memory exhausted" in query parser/simplifier for many nested parentheses
Date: 2024-12-12 12:39:40
Message-ID: CAKAnmm+1Xv2ge76CQhqKicgOmU2Z5CVJbNm_oLsYusmBophXxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

While not agreeing that this is a bug (perhaps an under-documented but
totally sane limit?) - but here is a shorter repro for the archives:

do $$begin execute format('%s', repeat('(',9999));end$$;

Cheers,
Greg

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Mike Bayer 2024-12-12 14:08:58 invalid constraint type "n" when using pg_catalog.pg_get_constraintdef() on pg17, regression from pg16
Previous Message Laurenz Albe 2024-12-12 06:47:24 Re: Problem with constraint unique.