[bug report] A sql statements make query hang

--0000000000002354cf059b72ed3f
Content-Type: text/plain; charset="UTF-8"

Hi,


When we run follow statements make query hang and never return in
PostgreSQL 13devel, we consider it might be a bug of PostgreSQL and report
it.

-------

CREATE TEMPORARY TABLE v0 ( v1 INT UNIQUE ) ;

WITH RECURSIVE v0 ( v1 ) AS ( SELECT -128 UNION SELECT v1 + 33 FROM v0 )
SELECT 'x' from v0;

-------


When we run in mysql, it suddenly return an empty set.


Best,

Yongheng & Rui

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

<div dir=3D"ltr">





<p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:13px;line-height:no=
rmal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">Hi,</p><p cla=
ss=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-varian=
t-east-asian:normal;font-stretch:normal;font-size:13px;line-height:normal;f=
ont-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)"><br></p><p class=3D=
"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-variant-eas=
t-asian:normal;font-stretch:normal;font-size:13px;line-height:normal;font-f=
amily:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">When we run follow state=
ments make query hang and never return in PostgreSQL 13devel, we consider i=
t might be a bug of=C2=A0PostgreSQL and report it.</p>





<p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:13px;line-height:no=
rmal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">-------</p><p=
 class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-va=
riant-east-asian:normal;font-stretch:normal;font-size:13px;line-height:norm=
al;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">





</p><p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;f=
ont-variant-east-asian:normal;font-stretch:normal;font-size:13px;line-heigh=
t:normal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">CREATE TE=
MPORARY TABLE v0 ( v1 INT UNIQUE ) ;</p>
<p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;font-=
variant-east-asian:normal;font-stretch:normal;font-size:13px;line-height:no=
rmal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">





</p><p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric:normal;f=
ont-variant-east-asian:normal;font-stretch:normal;font-size:13px;line-heigh=
t:normal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">WITH RECU=
RSIVE v0 ( v1 ) AS ( SELECT -128 UNION SELECT v1 + 33 FROM v0 ) SELECT &#39=
;x&#39; from v0;</p><p class=3D"gmail-p1" style=3D"margin:0px;font-variant-=
numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size=
:13px;line-height:normal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0=
,0,0)">-------</p><p class=3D"gmail-p1" style=3D"margin:0px;font-variant-nu=
meric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:1=
3px;line-height:normal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0=
,0)"><br></p><p class=3D"gmail-p1" style=3D"margin:0px;font-variant-numeric=
:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:13px;l=
ine-height:normal;font-family:&quot;Helvetica Neue&quot;;color:rgb(0,0,0)">=
When we run in mysql, it suddenly return an empty set.</p><p class=3D"gmail=
-p1" style=3D"margin:0px;font-variant-numeric:normal;font-variant-east-asia=
n:normal;font-stretch:normal;font-size:13px;line-height:normal;font-family:=
&quot;Helvetica Neue&quot;;color:rgb(0,0,0)"><br></p><p class=3D"gmail-p1" =
style=3D"margin:0px;font-variant-numeric:normal;font-variant-east-asian:nor=
mal;font-stretch:normal;font-size:13px;line-height:normal;font-family:&quot=
;Helvetica Neue&quot;;color:rgb(0,0,0)">Best,</p><p class=3D"gmail-p1" styl=
e=3D"margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;=
font-stretch:normal;font-size:13px;line-height:normal;font-family:&quot;Hel=
vetica Neue&quot;;color:rgb(0,0,0)">Yongheng &amp; Rui</p><p class=3D"gmail=
-p1" style=3D"margin:0px;font-variant-numeric:normal;font-variant-east-asia=
n:normal;font-stretch:normal;font-size:13px;line-height:normal;font-family:=
&quot;Helvetica Neue&quot;;color:rgb(0,0,0)"><br></p></div>

--0000000000002354cf059b72ed3f--