Content-Type: multipart/alternative;
 boundary="------------DR32NBP92uU9SsUrnNzbXoHr"
Message-ID: <94b13098-8c2c-4b1a-87e3-579e27d17509@gmail.com>
Date: Sat, 5 Apr 2025 01:00:01 +0300
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: SQLFunctionCache and generic plans
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Alexander Pyhalov <a.pyhalov@postgrespro.ru>,
 Pavel Stehule <pavel.stehule@gmail.com>,
 Alexander Korotkov <aekorotkov@gmail.com>,
 pgsql-hackers@lists.postgresql.org, Ronan Dunklau <ronan.dunklau@aiven.io>
References: <8216639.NyiUUSuA9g@aivenlaptop>
 <CAFj8pRA7MFTfUPwDDWtghaUvAjbrMHFUPbHyLSX3h8+FDw4WFg@mail.gmail.com>
 <445556.1738612687@sss.pgh.pa.us> <464677.1738620525@sss.pgh.pa.us>
 <1fc18af56d5fb27bf3e153ffaa2ed70d@postgrespro.ru>
 <2615770.1740688857@sss.pgh.pa.us>
 <448c63cf9b4f917c01802309b9c29eb9@postgrespro.ru>
 <CAFj8pRDWDeF2cC+pCjLHJno7KnK5kdtjYN-f933R! ! ! ! !
 HS7UneArFw@mail.gmail.com>
 <CAFj8pRD0diy5VDP=8B9au5sk_yRknCWqZx35VniBtP_OA4aJNw@mail.gmail.com>
 <2827970.1741890560@sss.pgh.pa.us>
 <337e011069b6831e063bfa346f49bb46@postgrespro.ru>
 <3344719.1741985546@sss.pgh.pa.us>
 <fcc68b0ef570160cd6e88851eb244ccd@postgrespro.ru>
 <db42573039cc66815e80a48589eebea8@postgrespro.ru>
 <2691107.1743257329@sss.pgh.pa.us> <3605427.1743351017@sss.pgh.pa.us>
 <248291.1743463745@sss.pgh.pa.us> <1101294.1743617356@sss.pgh.! pa.us>
 <0fde377a-3870-4d18-946a-ce008ee5bb88@gmail.com>
 <1454289.1743707630@sss.pgh.pa.us> <6d442183-!
 102c-498a-81d1-eeeb086cdc5a@gmail.com> <2048515.1743803254@sss.pgh.pa.us>
Content-Language: en-US
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: <2048515.1743803254@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/94b13098-8c2c-4b1a-87e3-579e27d17509%40gmail.com>
Precedence: bulk

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

05.04.2025 00:47, Tom Lane wrote:
> Alexander Lakhin<exclusion@gmail.com> writes:
>> I've stumbled upon another defect introduced with 0dca5d68d:
>> CREATE FUNCTION f(VARIADIC ANYARRAY) RETURNS ANYELEMENT AS $$ SELECT x FROM generate_series(1,1) g(i) $$ LANGUAGE SQL
>> IMMUTABLE;
>> SELECT f(1);
>> SELECT f(1);
> Hmm, I see
>
> regression=# CREATE FUNCTION f(VARIADIC ANYARRAY) RETURNS ANYELEMENT AS $$ SELECT x FROM generate_series(1,1) g(i) $$ LANGUAGE SQL IMMUTABLE;
> CREATE FUNCTION
> regression=# SELECT f(1);
> ERROR:  column "x" does not exist
> LINE 1:  SELECT x FROM generate_series(1,1) g(i)
>                  ^
> QUERY:   SELECT x FROM generate_series(1,1) g(i)
> CONTEXT:  SQL function "f" statement 1
> regression=# SELECT f(1);
> ERROR:  unrecognized node type: 2139062143
> CONTEXT:  SQL function "f" statement 1
>
> Did you intend the typo?  The "unrecognized node type" does indicate
> a problem, but your message doesn't seem to indicate that you're
> expecting a syntax error.
>

Yes, the typo is intended. With Valgrind, I get the "column does not exist"
error on the first call and the Valgrind complaint on the second one.

Best regards,
Alexander Lakhin
Neon (https://neon.tech)
--------------DR32NBP92uU9SsUrnNzbXoHr
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">05.04.2025 00:47, Tom Lane wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:2048515.1743803254@sss.pgh.pa.us">
      <pre wrap="" class="moz-quote-pre">Alexander Lakhin <a class="moz-txt-link-rfc2396E" href="mailto:exclusion@gmail.com">&lt;exclusion@gmail.com&gt;</a> writes:
</pre>
      <blockquote type="cite">
        <pre wrap="" class="moz-quote-pre">I've stumbled upon another defect introduced with 0dca5d68d:
CREATE FUNCTION f(VARIADIC ANYARRAY) RETURNS ANYELEMENT AS $$ SELECT x FROM generate_series(1,1) g(i) $$ LANGUAGE SQL 
IMMUTABLE;
SELECT f(1);
SELECT f(1);
</pre>
      </blockquote>
      <pre wrap="" class="moz-quote-pre">
Hmm, I see

regression=# CREATE FUNCTION f(VARIADIC ANYARRAY) RETURNS ANYELEMENT AS $$ SELECT x FROM generate_series(1,1) g(i) $$ LANGUAGE SQL IMMUTABLE;
CREATE FUNCTION
regression=# SELECT f(1);
ERROR:  column "x" does not exist
LINE 1:  SELECT x FROM generate_series(1,1) g(i) 
                ^
QUERY:   SELECT x FROM generate_series(1,1) g(i) 
CONTEXT:  SQL function "f" statement 1
regression=# SELECT f(1);
ERROR:  unrecognized node type: 2139062143
CONTEXT:  SQL function "f" statement 1

Did you intend the typo?  The "unrecognized node type" does indicate
a problem, but your message doesn't seem to indicate that you're
expecting a syntax error.

</pre>
    </blockquote>
    <br>
    Yes, the typo is intended. With Valgrind, I get the "column does not
    exist"<br>
    error on the first call and the Valgrind complaint on the second
    one.<br>
    <br>
    Best regards,<br>
    Alexander Lakhin<br>
    Neon (<a class="moz-txt-link-freetext" href="https://neon.tech">https://neon.tech</a>)
  </body>
</html>

--------------DR32NBP92uU9SsUrnNzbXoHr--