On 6/1/63 13:44, Yongheng Chen 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.
Not a bug this time, I think.
The "v0" in the CTE refers to the CTE itself, not the empty temporary
table. This makes it a recursive CTE, and a (very nearly) infinite loop:
https://www.sqlite.org/lang_with.html
Thanks for all the work you've been doing on SQLite!
Dan.
Yongheng & Rui
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users