Yongheng Chen, on Wednesday, December 18, 2019 10:45 AM, wrote... > > Hi, > > We found another crash in Sqlite. Here’s the POC: > > — > CREATE TABLE v0 ( v2 INTEGER UNIQUE ON CONFLICT IGNORE , v1 TEXT PRIMARY > KEY ) ; > CREATE VIEW v3 ( v4 ) AS SELECT v2 IN ( 9223372036854775808 , ( printf () > IN ( 0 , 0 ) ) , 10 , 10 , 10 ) AS AVG_YEARLY FROM v0 ; > CREATE TABLE v5 ( v6 , v7 ) ; INSERT INTO v0 VALUES ( 1.100000 , 'y' ) ; > INSERT INTO v5 VALUES ( 10 , 10 ) ; > INSERT INTO v0 VALUES ( 10 , 10 ) ; > SELECT DISTINCT v4 FROM v0 LEFT JOIN v3 ON v4 = 10 OR v4 = v3 . v4 ORDER > BY v4 ; > — > > This bug exists in both the latest development code and the release code.
Yep, took down sqlite3.exe with 3.30.0. Just fyi. josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users