## Summary **No review yet** ## Minimized query ```sql .timer 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 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 Run Time: real 0.001 user 0.000037 sys 0.000000 Run Time: real 0.000 user 0.000004 sys 0.000000 Run Time: real 0.000 user 0.000003 sys 0.000000 Run Time: real 0.000 user 0.000160 sys 0.000000 Run Time: real 0.000 user 0.000037 sys 0.000000 Run Time: real 0.000 user 0.000011 sys 0.000000 Run Time: real 0.000 user 0.000010 sys 0.000000 Run Time: real 0.000 user 0.000010 sys 0.000000 1.79769313486232e+308|1.0 1|-1.0 2|Inf Run Time: real 0.000 user 0.000010 sys 0.000000 ok Run Time: real 0.000 user 0.000041 sys 0.000000 Run Time: real 0.000 user 0.000002 sys 0.000000 Run Time: real 0.000 user 0.000038 sys 0.000000 Run Time: real 0.000 user 0.000033 sys 0.000000 Run Time: real 0.000 user 0.000038 sys 0.000000 Run Time: real 0.000 user 0.000011 sys 0.000000 Run Time: real 0.000 user 0.000004 sys 0.000000 Run Time: real 0.000 user 0.000003 sys 0.000000 Run Time: real 0.000 user 0.000005 sys 0.000000 Run Time: real 0.000 user 0.000004 sys 0.000000 Run Time: real 0.000 user 0.000004 sys 0.000000 2 3 Run Time: real 0.000 user 0.000062 sys 0.000000 Run Time: real 0.000 user 0.000009 sys 0.000000 Run Time: real 0.000 user 0.000367 sys 0.000000 Run Time: real 0.000 user 0.000004 sys 0.000000 Run Time: real 0.001 user 0.000468 sys 0.000000 Run Time: real 0.000 user 0.000007 sys 0.000000 Run Time: real 0.000 user 0.000044 sys 0.000000 Run Time: real 0.000 user 0.000009 sys 0.000000 -1.0 1.0 Inf Run Time: real 0.000 user 0.000066 sys 0.000000 Run Time: real 0.000 user 0.000005 sys 0.000000 Run Time: real 0.000 user 0.000037 sys 0.000000 Run Time: real 0.000 user 0.000005 sys 0.000000 Run Time: real 0.000 user 0.000007 sys 0.000000 ``` ## Expectation ```sql ``` ## Flag ``` ```