Hi, We found an assertion failed in sqlite. Here’s the POC: — CREATE TABLE v0 ( v2 INTEGER PRIMARY KEY UNIQUE ON CONFLICT FAIL , v1 DOUBLE CHECK( ( v2 > 10 AND v1 >= 10 AND v2 <= 10 + 10 AND v1 BETWEEN 0 AND 10 AND v2 IN ( '' , 'AIR REG' ) AND v2 NOT IN ( 0 , NULL , 10 ) AND v2 >= 10 ) + CASE v2 WHEN 10 THEN 10 ELSE 10 END ) CHECK( julianday ( 10.100000 ) ) ) ; CREATE TRIGGER x AFTER UPDATE ON v0 BEGIN REPLACE INTO v0 SELECT v1 , SUM ( v1 * ( 10 - v1 ) ) OVER( ORDER BY ( SELECT v1 FROM v0 AS x WHERE v1 IN ( v0 . v2 , 127 , v0 . v1 ) GROUP BY v1 HAVING v2 + last_insert_rowid () ) ) AS REVENUE FROM v0 GROUP BY v2 ; END ; CREATE TEMP TRIGGER x BEFORE INSERT ON v0 BEGIN UPDATE v0 SET v1 = randomblob ( 10 ) WHERE v1 >= 'EUROPE' AND v2 < ( SELECT v2 FROM v0 WHERE v2 < ( SELECT v1 FROM v0 WHERE v0 . v2 = v0 . v2 GROUP BY v0 . v2 , v1 HAVING v1 > '18' ) GROUP BY v0 . v1 , v1 ) ; END ; INSERT INTO v0 ( v1 ) VALUES ( 'Y' ) ,( '**%s**' ) ,( 'Brand#23' ) ,( 'CANADA' ); —-
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