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