Yongheng Chen, on Sunday, December 8, 2019 02:51 PM, wrote... > > 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.
This definitely crashes in Windows 10: 17:21:58.01>sqlite3 SQLite version 3.30.1 2019-10-10 20:19:45 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> CREATE TABLE v0 ( v1 ) ; sqlite> CREATE TABLE v2 ( v3 ) ; sqlite> CREATE VIEW v4 AS WITH x AS ( SELECT x () OVER( ) FROM v4 ) SELECT v3 AS x FROM v2 ; sqlite> DROP TRIGGER IF EXISTS x ; sqlite> ALTER TABLE v2 RENAME TO t3; 17:23:08.57> Just fyi. thanks. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users