Hi, We found one crash bug in sqlite, which causes a dead loop and then OOM. ———— CREATE TABLE v0 ( v1 ) ; CREATE TABLE v2 ( v3 ) ; CREATE VIEW v4 AS WITH x AS ( SELECT x () OVER( ) FROM v4 ) SELECT v3 AS x FROM v2 ; DROP TRIGGER IF EXISTS x ; ALTER TABLE v2 RENAME TO t3; ———— The bug exists in "SQLite version 3.31.0 2019-12-08 00:06:39” and before.
We reported this bug to one of the developers but didn’t get response. And we reported several bugs to the same person one-to-one before (which was required by him) and the bugs got fixed but we never got any credits for them. We hope somebody else can help us. Thanks. Best. Yongheng Chen & Rui Zhong _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users