Thanks for the fix. > On Dec 9, 2019, at 9:43 AM, Richard Hipp <d...@sqlite.org> wrote: > > 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
_______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users