MIME-Version: 1.0
References: 
 <CAFj8pRBoGBKopkiTa4ki3dMgy-cSTRZ-BQPKOq7=Tk0SSNsowA@mail.gmail.com>
 <CAFj8pRBCiWn12H9FHymYs17fk68nRd9Xpn+SYf18TLdb2YSUrQ@mail.gmail.com>
 <CAA4eK1JV-Ox0oRFdXnPqXSzM84wTR5QFkRzCpNVF_+0FNjS5Mg@mail.gmail.com>
 <CAFj8pRByCCcgDkeXyafAnH6LgxtAyCVwg6yfJAhyTY6GLscfZg@mail.gmail.com>
 <CAFj8pRBvUonC_ug3F=w1Q55Dp=DggojvAeL7Vmh14Q-WhFHxzw@mail.gmail.com>
 <CAFj8pRDj72P-f=SUygtOXnTOBQ0RzmL_fN=wLfaCzcbPVpGgzw@mail.gmail.com>
 <CAFj8pRDD2GQaJ_iDT4vSVe658+oHRXU2S2af7Y1-it9jaP8VFg@mail.gmail.com>
 <20200924035637.GF28585@paquier.xyz>
 <CAFj8pRAFktynx5wkanv5SRuzXkZgXu77XpVACiSE=v7i1xHFbw@mail.gmail.com>
 <CAFj8pRA=bn_g5T2AZduy5gNOQoOnUJ+pMHmnRMHi6mR0n=TAsA@mail.gmail.com>
 <20201001033824.GC8130@paquier.xyz>
 <CAFj8pRC9de05HSb4tEHDUwJ98+4Wh30W-rJrNOPnTz6ARcv0Fw@mail.gmail.com>
 <CAFj8pRBC5Wz1xHKKBmKsM0xYN0+PdSZ5oXPsk5SZt+VprdUW3A@mail.gmail.com>
 <CAFj8pRAh4pzMoZrKCLt9h+Lr2L=vhgs2PjAF45uLbp_7sijM5w@mail.gmail.com>
 <CAFj8pRA-kxQ1oErcuDeUKYsrgwB5XGLhquatwxOe3dCVy1gcyQ@mail.gmail.com>
 <51a9a68e8a998d04df17417d45c1dbd4@xs4all.nl>
 <CAFj8pRBbt2xhY9PyabOY0ZN+Aig6ee3oCon-DM9qi0Uw_3qfbw@mail.gmail.com>
 <CAFj8pRDSa52J7kPmCYXgq1BBbu3YBXwpdSOVpjgU=hnE2k04Cw@mail.gmail.com>
 <CAFj8pRD+QiWOoPrFk2NnPs3t5Eaf4X=aGRV-9ww11cnPP+fV4g@mail.gmail.com>
 <bdeb7611c6dbf22226c302bcc01d178b@xs4all.nl>
 <CAFj8pRCGTjqHvH9oeiSf4T6Bydhk9pm033DxxibgF+B7SHC6MQ@mail.gmail.com>
 <CAFj8pRAzNDhFgbZnT0T0mJ7ygA1Qje1Hc0TiKwXM8++kGooPYg@mail.gmail.com>
 <89817942c99da01cd5e7850fe418436b@xs4all.nl>
 <CAFj8pRBarjJYfkN-0-i=JRZJ4PTOYC+K7XgAhfdDqWGqRiPkyw@mail.gmail.com>
 <CAFj8pRDqdWdCULxd5asbKs5C4e9kT2TuKBkR5L-e1=hP5wF2uw@mail.gmail.com>
 <56ca532c37eb0b540961f74a7bd5db39@xs4all.nl>
 <CAFj8pRCPW56pFr0F0BcasdXjFeo3SFixNSpWKaBk0ibvznum-A@mail.gmail.com>
 <CAFj8pRD1Feit93CgwmYm1Q=X+M+AZqffCEZPFQ7qEMNHZRN4fA@mail.gmail.com>
 <CAFj8pRCc=B9-FRQg5eWDSkGwS2vpkq88hR6042cmPPizHuEGSA@mail.gmail.com>
 <CAFj8pRBk8x7afUXKLBOU-Ctg6A7QJvTAGGVEi0b6Jc8YTe8nUg@mail.gmail.com>
 <CAFj8pRCSwHQ4BJUbjF2YEausK1Z6+ejMyedpqAnWJbG+FEJDLw@mail.gmail.com>
 <CAFj8pRAbY+N+UqjqgESL5x-bsGmV+aVyyUkxUSgaGDZToZjDqQ@mail.gmail.com>
 <CAFj8pRBzKcqzj=23BHfv1QaXHt=2_SN=uhdR3rb_dAVQoit7ug@mail.gmail.com>
 <CAFj8pRCi-n6SzkAB+OHG=TZvL13xxta_qgffBLDOY0HEBqDhvg@mail.gmail.com>
 <8181bd3abc647bdae5a4f78e71e62478a98c75f4.camel@cybertec.at>
 <CAFj8pRBaD0_bMrCREWnVLfcTMdc0v7ns7Rt=sEvd1EoFmLfarQ@mail.gmail.com>
 <9e67d49deb18270eddb95e602c83f02b98459843.camel@cybertec.at>
 <CAFj8pRDXo-RRcy2VFDm_vzv3Eaaz6Ex=X19up=x8W4COyBNmaQ@mail.gmail.com>
 <f9f4d536993e48990bd7eb38e18798c4572b6700.camel@cybertec.at>
 <CAFj8pRDgraz64HHcCoFGCKDM1Cxv1ukELsqfsxux4JP3PM6RyQ@mail.gmail.com>
 <3b662dc5b615d4c20a55e8e2fbe6fc00fe00609d.camel@cybertec.at>
 <CAFj8pRAsjr0pzQpQeRrQ-wR-ew1oTc6qkW=4355KveN1jKQ+1Q@mail.gmail.com>
 <c29fb07fb1b55725e175e5625a5261baeab4a977.camel@cybertec.at>
 <6996931e8c9edf3b82223e74e92326a7ed06c1d6.camel@cybertec.at>
 <67aa68a7e6dfb44c0cbbdf7f97cadfede4269ce5.camel@cybertec.at>
 <CAFj8pRB4oRVXTqChg0JH0XCKv33assFGr4jmUw3ht+4C6ac2PQ@mail.gmail.com>
 <263ef86d2cc97751e4833d79f3713d4a02b4cfb0.camel@cybertec.at>
 <CAFj8pRBEN2LbGs-djJMQLNsM9jLgKixwkjgduZFJAZy5Kd=mqw@mail.gmail.com>
 <f7e8030fdd1f1515e0ab960126a6d924b4936af8.camel@cybertec.at>
 <CAFj8pRAVN=uw=qUZGQqug6UfG4c21Y1+VTbs_99w0sdqfHN-cg@mail.gmail.com>
 <CAFj8pRAFaaeRnM3F9BV5FLh-MgqY1t_v1QowoXi7HJ_bD1kX5g@mail.gmail.com>
 <d1fea4cc5d74100b69fb4f5ceaadc2a6979a8c87.camel@cybertec.at>
In-Reply-To: <d1fea4cc5d74100b69fb4f5ceaadc2a6979a8c87.camel@cybertec.at>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Thu, 1 Aug 2024 13:24:58 +0200
Message-ID: 
 <CAFj8pRAK5TFMxuEOa9PcF4CSc7GxEpgo9w0zRWpTvyMPH7Xmng@mail.gmail.com>
Subject: Re: proposal: schema variables
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Erik Rijkers <er@xs4all.nl>, Michael Paquier <michael@paquier.xyz>,
	Amit Kapila <amit.kapila16@gmail.com>, DUVAL REMI <REMI.DUVAL@cheops.fr>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003f9e5e061e9d7854"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFj8pRAK5TFMxuEOa9PcF4CSc7GxEpgo9w0zRWpTvyMPH7Xmng%40mail.gmail.com>
Precedence: bulk

--0000000000003f9e5e061e9d7854
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

=C4=8Dt 1. 8. 2024 v 13:22 odes=C3=ADlatel Laurenz Albe <laurenz.albe@cyber=
tec.at>
napsal:

> On Thu, 2024-08-01 at 08:12 +0200, Pavel Stehule wrote:
> > fresh rebase + fix format in doc
>
> Thanks!
>
> I'm curious, but too lazy to build the patch now, so I'm asking:
> what did you do about this error?
>

I try to investigate this issue now.

The patchset is just merging of your work


> > CREATE VARIABLE var AS date;
> > LET var =3D current_date;
> > PREPARE stmt(date) AS SELECT $1;
> > EXECUTE stmt(var);
> > ERROR:  paramid of PARAM_VARIABLE param is out of range
>


>
> Or does a later patch take care of that?
>

This is a clear bug, and I have to fix it. I hope so I'll do this today


>
> Yours,
> Laurenz Albe
>

--0000000000003f9e5e061e9d7854
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">=C4=8Dt 1. 8. 2024 v=C2=A013:22 odes=
=C3=ADlatel Laurenz Albe &lt;<a href=3D"mailto:laurenz.albe@cybertec.at">la=
urenz.albe@cybertec.at</a>&gt; napsal:<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex">On Thu, 2024-08-01 at 08:12 +0200, Pavel Stehule wro=
te:<br>
&gt; fresh rebase + fix format in doc<br>
<br>
Thanks!<br>
<br>
I&#39;m curious, but too lazy to build the patch now, so I&#39;m asking:<br=
>
what did you do about this error?<br></blockquote><div><br></div><div>I try=
 to investigate this issue now.</div><div><br></div><div>The patchset is ju=
st merging of your work</div><div><br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex">
<br>
&gt; CREATE VARIABLE var AS date;<br>
&gt; LET var =3D current_date;<br>
&gt; PREPARE stmt(date) AS SELECT $1;<br>
&gt; EXECUTE stmt(var);<br>
&gt; ERROR:=C2=A0 paramid of PARAM_VARIABLE param is out of range<br></bloc=
kquote><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0=
px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
Or does a later patch take care of that?<br></blockquote><div><br></div><di=
v>This is a clear bug, and I have to fix it. I hope so I&#39;ll do this tod=
ay<br></div><div><br></div><div>=C2=A0<br></div><blockquote class=3D"gmail_=
quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,=
204);padding-left:1ex">
<br>
Yours,<br>
Laurenz Albe<br>
</blockquote></div></div>

--0000000000003f9e5e061e9d7854--