## Summary **No review yet** ## Minimized query ```sql BEGIN EXCLUSIVE; -- if(1, {v}, 0, {v}, 0, {v}) ATTACH DATABASE '' || (':memory:') AS aux37; PRAGMA defer_foreign_keys = TRUE; PRAGMA encoding = 'utf-16'; -- PRAGMA module_list; CREATE TABLE t1(abcd, efgh); INSERT INTO t1 VALUES (hex(NULL), timediff(CAST(-(-(-(-(printf('%d', date(unlikely(NULL))))))) AS NCHAR(55)), 0)); CREATE VIEW v1 AS SELECT * FROM t1 WHERE NOT NOT (+abcd>efgh) ; CREATE UNIQUE INDEX IF NOT EXISTS idx_t1_3742 ON t1(efgh COLLATE NOCASE); /* sqlite_compileoption_used(NULL) */ CREATE TEMPORARY VIEW IF NOT EXISTS v_t1_511 AS SELECT efgh FROM t1; REINDEX t1; SELECT * FROM t1 WHERE efgh > (SELECT AVG(efgh) FROM t1); SELECT AVG(efgh) FROM t1; DELETE FROM t1 WHERE 0; SELECT COUNT(*) FROM t1; DETACH DATABASE aux37; ALTER TABLE t1 RENAME COLUMN abcd TO abcd_r4633; ANALYZE t1; WITH RECURSIVE cnt(x) AS (VALUES(0) UNION ALL SELECT x-1 FROM cnt WHERE x>-92) SELECT * FROM cnt; INSERT INTO t1 DEFAULT VALUES; INSERT INTO t1 VALUES (NULL, NULL); SELECT * FROM t1 AS a LEFT JOIN t1 AS b ON a.rowid = b.rowid; SELECT STRING_AGG(efgh, '|') FROM t1; COMMIT TRANSACTION; CREATE UNIQUE INDEX IF NOT EXISTS idx_t1_6457 ON t1(efgh) WHERE efgh IS NOT NULL; SELECT MIN(efgh) FROM t1; ``` ## Actual output ```sql 0 0 -1 -2 -3 -4 -5 -6 -7 -8 -9 -10 -11 -12 -13 -14 -15 -16 -17 -18 -19 -20 -21 -22 -23 -24 -25 -26 -27 -28 -29 -30 -31 -32 -33 -34 -35 -36 -37 -38 -39 -40 -41 -42 -43 -44 -45 -46 -47 -48 -49 -50 -51 -52 -53 -54 -55 -56 -57 -58 -59 -60 -61 -62 -63 -64 -65 -66 -67 -68 -69 -70 -71 -72 -73 -74 -75 -76 -77 -78 -79 -80 -81 -82 -83 -84 -85 -86 -87 -88 -89 -90 -91 -92 ||| ||| ``` ## Expectation ```sql ``` ## Flag ``` ```