Thanks for the fix. > On Dec 9, 2019, at 9:43 AM, Richard Hipp <[email protected]> wrote: > > On 12/8/19, Yongheng Chen <[email protected]> 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 > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

