Hi, We found an assertion failed in sqlite. And this assertion seems not to be fixed completely. Here’s the POC: — CREATE TABLE v0 ( v8 FLOAT , v7 UNIQUE ON CONFLICT ROLLBACK GENERATED ALWAYS AS( v6 ) , v6 INT , v5 INT UNIQUE GENERATED ALWAYS AS( NULL ) , v4 INTEGER UNIQUE , v3 DOUBLE PRIMARY KEY CHECK( v6 ) , v2 VARCHAR(20) UNIQUE , v1 FLOAT CHECK( julianday ( 'MED P' ) ) CHECK( v6 NOT LIKE 'b' ) NOT NULL ON CONFLICT REPLACE UNIQUE UNIQUE ON CONFLICT ROLLBACK ) ;
CREATE VIEW v9 ( v10 ) AS SELECT v4 FROM v0 WHERE v2 = 'Brand#12' AND v6 != v1 OR ( v1 BETWEEN 10 AND v3 ) ; SELECT 10 FROM v9 WHERE 1 = v10 OR NULL BETWEEN ( SELECT v10 FROM v9 AS prep_inst WHERE NULL BETWEEN ( SELECT sum ( v8 ) OVER( ) AS myname FROM v0 AS x GROUP BY 1 ) AND 10 GROUP BY v10 ) AND 10 ; —- This exists in the latest development code built with debug flag. Yongheng & Rui _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
