## Summary **No review yet** ## Minimized query ```sql .tables PRAGMA count_changes = TRUE; SAVEPOINT sp6059; CREATE TABLE T ( a TEXT, b TEXT ); INSERT INTO T VALUES ('a','2020-01-01'), ('b','2026-01-01'); SELECT a, CAST( (julianday('now')-julianday(b))/(floor(timediff(json_patch(hex(-(-(12345678))), 365.25), 365.25)) + 0.0) AS INTEGER ) AS c FROM T; .quit PRAGMA function_list; PRAGMA foreign_keys = FALSE; PRAGMA secure_delete; .fullschema BEGIN; create TABLE abc(a, b, c, PRIMARY KEY(a, b)); INSERT INTO abc VALUES((sign(-cos(--(-(9223372036854775807)))) * 1), 1, 1); INSERT INTO abc SELECT a+(select max(a) FROM abc), b+(select max(a) FROM abc), c+(select max(a) FROM abc) FROM abc; COMMIT; SELECT count((SELECT a FROM abc WHERE +a = NULL OR b >= upper.c)) FROM abc AS upper; SELECT * FROM sqlite_master WHERE rowid=10; SELECT MAX(b) FROM abc; INSERT INTO abc VALUES (NULL, NULL, NULL); ANALYZE abc; ANALYZE; CREATE UNIQUE INDEX IF NOT EXISTS idx_abc_6185 ON abc(c) WHERE c IS NOT NULL; INSERT INTO abc VALUES (NULL, NULL, NULL); ANALYZE abc; SELECT GROUP_CONCAT(a, '.') FILTER (WHERE a IS NOT NULL) OVER (PARTITION BY a ORDER BY a /**/ ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) FROM abc; CREATE TRIGGER IF NOT EXISTS trg_abc_4753 BEFORE INSERT ON abc BEGIN SELECT RAISE(ABORT, 'abort'); END; ALTER TABLE abc RENAME COLUMN b TO b_r2938; INSERT INTO abc VALUES (NULL, NULL, NULL); PRAGMA mmap_size; WITH cte AS (SELECT 1.5 AS x) SELECT CAST(x AS TEXT) FROM cte; ROLLBACK TRANSACTION TO SAVEPOINT sp6059; CREATE TABLE T ( a INTEGER, b REAL ); INSERT INTO T VALUES (1,1.5), (2,-2.5), (3,0.0); CREATE INDEX c ON T(b); SELECT * FROM T WHERE b >= -2.5 AND b < 2.0; RELEASE SAVEPOINT sp6059; SELECT COUNT(*) FROM abc; INSERT OR ABORT INTO abc VALUES ('', 0, ''); ALTER TABLE abc DROP COLUMN a; INSERT INTO T SELECT * FROM T; ANALYZE T; CREATE UNIQUE INDEX IF NOT EXISTS idx_abc_7425 ON abc(lower(c)) WHERE c > 0; REINDEX abc; ALTER TABLE T DROP COLUMN a; CREATE TABLE T ( a INTEGER, b TEXT, c REAL, d REAL ); INSERT INTO T VALUES (1,'a',40.5,-70.0), (2,'b',-10.25,20.5), (3,'c',9e999,-9e999); SELECT b FROM T WHERE ABS(c) > 5 AND ABS(d) > 5; UPDATE T SET d = json_object('k', d) WHERE 1 RETURNING *; SELECT * FROM T WHERE b IN (SELECT b FROM T WHERE b GLOB "*"); DELETE FROM T WHERE 0; ``` ## Actual output ```sql 2 ``` ## Expectation ```sql ``` ## Flag ``` ```