Yongheng Chen, on Thursday, December 19, 2019 01:21 PM, wrote... > > Hi, > > We found another crash in Sqlite. Here’s the POC: > — > CREATE TABLE v0 ( v1 INTEGER PRIMARY KEY ) ; > CREATE VIEW v2 ( v3 ) AS SELECT DISTINCT ( SELECT DISTINCT v1 , v1 , v1 , > v3 , v1 , v3 , v1 , 10.100000 ) ; > CREATE TABLE v4 ( v5 INTEGER PRIMARY KEY , v6 INT ); > DELETE FROM v0 WHERE NULL BETWEEN ( SELECT v1 FROM v0 AS x GROUP BY v1 > ORDER BY 10 + sum ( v1 ) OVER( ORDER BY - 10 ) DESC ) AND 10 ;
Entering each of those lines above, one at a time, when I hit enter after the last line above, sqlite3 crashes right after. So, I don't even need the line below. This is using sqlite3 v3.30.0 in Windows. Just an FYI. > SELECT * FROM v4 , v2 WHERE v3 = v3 AND v3 = 10; > — > > This bug exists in both the latest development code and the release code. > (And thanks josé for the confirmation every time we report a bug). You're welcome. I have SQlite3 tool opened, so it's a "nice copy and paste" and see your replication text/steps go to work. ;-) josé _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
