## Summary **No review yet** ## Minimized query ```sql PRAGMA writable_schema = YES; CREATE TABLE main.T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',-(-('[1,2,3]'))), ('a','c',-datetime(x'3ea400a5e66ccb', '+1 day')), ('b','d',jsonb_array(char(0))); SELECT COALESCE(a,'e') AS d, COALESCE(b,'f') AS e, SUM(c) AS f FROM T GROUP BY a,b; WITH cte AS (SELECT * FROM T), cte2 AS (SELECT * FROM cte) SELECT * FROM cte2; CREATE UNIQUE INDEX IF NOT EXISTS idx_T_7700 ON T(b COLLATE NOCASE) WHERE NOT NOT (b IS NOT NULL) ; REINDEX T; INSERT INTO T VALUES (NULL, NULL, NULL); CREATE TRIGGER IF NOT EXISTS trg_T_5109 AFTER INSERT ON T FOR EACH ROW BEGIN SELECT RAISE(IGNORE); END; WITH cte AS (SELECT a, SUM(a) AS total FROM T GROUP BY a) SELECT * FROM cte ORDER BY total DESC; PRAGMA vdbe_debug = NO; VACUUM; WITH RECURSIVE cnt(x) AS (VALUES(1) UNION ALL SELECT x+1 FROM cnt WHERE x<98) SELECT * FROM cnt; SELECT MIN(c) OVER (PARTITION BY c ORDER BY c RANGE BETWEEN 1 PRECEDING AND 1 FOLLOWING) FROM T; SELECT * FROM T; CREATE UNIQUE INDEX IF NOT EXISTS idx_T_7241 ON T(b COLLATE NOCASE); UPDATE T SET c = NULL WHERE rowid = 1; ``` ## Actual output ```sql | 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 93 94 95 96 97 98 || ``` ## Expectation ```sql ``` ## Flag ``` -nonce "n0Nc3" ```