On 12/8/19, Yongheng Chen <changoch...@gmail.com> wrote:
>
> We found one crash bug in sqlite,

Simplified test case:

CREATE TABLE t1(a);
CREATE VIEW v2(b) AS WITH t3 AS (SELECT b FROM v2) VALUES(1);
ALTER TABLE t1 RENAME TO t4;

Notice how the definition of the V2 view refers to itself.  The ALTER
TABLE command was failing to detect this circular reference in the
view definition.  This caused an infinite recursion of attempts to
resolve the definition of V2, ultimately resulting in a stack
overflow, which on some systems manifests as a segfault.  Dan checked
in a fix earlier today.

-- 
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to