Yongheng Chen, on Monday, January 6, 2020 01:44 AM, wrote...
>
> Hi,
>
> We found a test case that hangs Sqlite:
> —
> CREATE TEMPORARY TABLE v0 ( v1 INT UNIQUE ) ;
> WITH RECURSIVE v0 ( v1 ) AS ( SELECT -128 UNION SELECT v1 + 33 FROM v0 )
> SELECT 'x' from v0;
> —
>
> This seems triggering a dead loop. However, since v0 is empty, it might
> not enter a dead loop I think ? We are not sure whether this is a bug.

Yep, infinite loop with 3.30.0.  Continues to display x and new line.  Thanks.

josé
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to