## Summary **No review yet** ## Minimized query ```sql .timer sin(192319231923) PRAGMA read_uncommitted = NO; BEGIN DEFERRED TRANSACTION; PRAGMA vdbe_trace = OFF; .explain auto CREATE TABLE T1 ( a VARCHAR(255), b REAL ); CREATE TABLE T2 ( a INTEGER, b REAL ); INSERT INTO T1 VALUES (1.7976931348623157e+308,1.0); INSERT INTO T2 VALUES (1,-1.0),(2,9e999); INSERT OR REPLACE INTO T1 SELECT * FROM T2; SELECT * FROM T1; PRAGMA quick_check; PRAGMA vdbe_addoptrace = TRUE; CREATE TABLE IF NOT EXISTS photo(pk integer primary key, x); CREATE TABLE IF NOT EXISTS tag(pk integer primary key, fk int, name); SELECT P.pk from PHOTO P WHERE NOT NOT (NOT NOT (NOT EXISTS ( SELECT T2.pk from TAG T2 WHERE T2.fk = P.pk EXCEPT SELECT T3.pk from TAG T3 WHERE T3.fk = P.pk AND T3.name LIKE ('%foo%' || '')))) ; INSERT INTO photo VALUES(sign(-(-(1))),1); INSERT INTO photo VALUES(2,2); INSERT INTO photo VALUES(3,3); INSERT INTO /**/ tag VALUES(11,1,'one'); INSERT INTO tag VALUES(12,1,'two'); INSERT INTO tag VALUES(21,1,'one-b'); SELECT P.pk from PHOTO P WHERE NOT EXISTS (SELECT T2.pk from TAG T2 WHERE T2.fk = P.pk EXCEPT SELECT T3.pk from TAG T3 WHERE T3.fk = P.pk AND T3.name LIKE '%foo%'); DELETE FROM photo WHERE +rowid = 41; ALTER TABLE photo RENAME TO photo_r2124; PRAGMA defer_foreign_keys = YES; ALTER TABLE tag RENAME COLUMN pk TO pk_r9440; INSERT INTO T2 DEFAULT VALUES; CREATE TRIGGER IF NOT EXISTS trg_T1_8903 AFTER UPDATE OF b ON T1 BEGIN SELECT RAISE(FAIL, 'no'); END; SELECT STRING_AGG(b, '|') FROM T1; SELECT FIRST_VALUE(b) OVER (ORDER BY b RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T1; INSERT INTO T1 VALUES (NULL, NULL); SELECT LEAD(a, 1, NULL) OVER (PARTITION BY a ORDER BY a) FROM T2; END; INSERT INTO T2 VALUES (NULL, NULL); ``` ## Actual output ```sql 1.79769313486232e+308|1.0 1|-1.0 2|Inf ok 2 3 -1.0 1.0 Inf ``` ## Expectation ```sql ``` ## Flag ``` ```