## Summary **No review yet** ## Minimized query ```sql .lint ATTACH DATABASE ':memory:' AS aux60; PRAGMA vdbe_addoptrace = YES; PRAGMA application_id = like('', '', ''); BEGIN IMMEDIATE; ATTACH DATABASE ':memory:' AS aux83; PRAGMA max_page_count = (5000000 - 0); BEGIN IMMEDIATE; .dbinfo main BEGIN EXCLUSIVE; .width ATTACH DATABASE ':memory:' AS aux12; .((schema)) @@@@@@@@@@@@@@@@ PRAGMA query_only = TRUE; .open employee.db ((BEGIN)) IMMEDIATE TRANSACTION; ATTACH DATABASE ':memory:' AS aux11; SAVEPOINT sp9707; .lint PRAGMA automatic_index = ON; PRAGMA vdbe_addoptrace = substr(randomblob(concat(NULL)), format('%x', sign(CAST(unhex(NULL) AS DOUBLE PRECISION))), (pow(json_array_length(if(power(log(json_group_object('k', NULL), 0), 0), 5, NULL), '$.arr'), 5) + 0)); PRAGMA vdbe_addoptrace = YES; .width CREATE TABLE T ( a TEXT, b TEXT, c REAL ); INSERT INTO T VALUES ('a','b',1.5), ('a','c',-2.25), ('b','b',4.75); SELECT a, SUM(CASE WHEN b='b' THEN c ELSE 0 END) AS d, SUM(CASE WHEN b='c' THEN c ELSE 0 END) AS e FROM T GROUP BY a; UPDATE T SET b = '' wheRe 1; SELECT LAG(c, 1, NULL) OVER (PARTITION BY c ORDER BY c ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING EXCLUDE GROUP) FROM T; REINDEX; ROLLBACK TO sp9707; RELEASE sp9707; /* PRAGMA vdbe_debug = TRUE; */ DROP TABLE IF EXISTS T; SELECT MIN(c) FROM T; DETACH DATABASE aux11; ALTER TABLE T ADD COLUMN extra_5285 BIGINT COLLATE RTRIM; SELECT AVG(c) FROM T; INSERT INTO T VALUES (NULL, NULL, NULL) ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; CREATE VIEW IF NOT EXISTS v_T_7436 AS SELECT a FROM T; VACUUM main; SELECT GROUP_CONCAT(c, '.') FILTER (WHERE c IS NOT NULL) OVER (ORDER BY c) FROM T; SELECT * FROM T AS a RIGHT JOIN T AS b ON a.rowid = b.rowid; CREATE TRIGGER IF NOT EXISTS trg_T_2055 BEFORE UPDATE ON T BEGIN SELECT RAISE(FAIL, 'no'); END; END TRANSACTION; ALTER TABLE T ADD COLUMN extra_2493 BIGINT DEFAULT (random()); ALTER TABLE T DROP COLUMN b; DELETE FROM T WHERE 1 RETURNING *; SELECT LAG(c, 1) OVER (ORDER BY c ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW EXCLUDE TIES) FROM T; INSERT OR ROLLBACK INTO T VALUES ('x', 'x', ''); INSERT INTO T VALUES (NULL, NULL, 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; SELECT COUNT(*) FROM T; ALTER TABLE T DROP COLUMN b; INSERT INTO T SELECT * FROM T; ALTER TABLE T DROP COLUMN b; CREATE UNIQUE INDEX IF NOT EXISTS idx_T_1152 ON T(lower(a)) WHERE a IS NOT NULL; PRAGMA short_column_names; PRAGMA automatic_index; INSERT INTO T VALUES ('x', 'x', 'x') ON CONFLICT(a) DO UPDATE SET a = excluded.a, b = excluded.b, c = excluded.c; DROP VIEW IF EXISTS T; REINDEX T; INSERT INTO T DEFAULT VALUES; REINDEX T; INSERT INTO T SELECT * FROM T; SELECT MIN(b) FROM T; SELECT AVG(b) FROM T; SELECT COUNT(*) FROM T; PRAGMA vdbe_listing = 0; ALTER TABLE T RENAME TO T_r5446; DETACH DATABASE aux12; END; ALTER TABLE T RENAME COLUMN a TO a_r6477; DELETE FROM T WHERE c IS NULL; ROLLBACK; ALTER TABLE T RENAME COLUMN c TO c_r3297; DETACH DATABASE aux83; COMMIT; CREATE VIRTUAL TABLE T USING fts5(a,b); INSERT INTO T VALUES ('a','b c'), ('d','e f'); SELECT a,b FROM T WHERE T MATCH 'b'; SELECT * FROM T AS a FULL OUTER JOIN T AS b ON a.rowid = b.rowid; REINDEX; VACUUM main; DETACH DATABASE aux60; DELETE FROM T WHERE b > (SELECT AVG(b) FROM T) RETURNING *; INSERT INTO T VALUES (NULL, NULL, NULL); ALTER TABLE T RENAME TO T_r2269; ``` ## Actual output ```sql 3.39.0 2022-05-10 23:28:12 764b71267e0b31ff7eaf2a0def7526a1a02dce4d5b456dea060d97ed342ealt1 ``` ## Expectation ```sql 3.51.1 2025-11-28 17:28:25 281fc0e9afc38674b9b0991943b9e9d1e64c6cbdb133d35f6f5c87ff6af38a88 (64-bit) ``` ## Flag ``` -version ```