## Summary **No review yet** ## Minimized query ```sql PRAGMA schema_version = 5; CREATE TABLE A (A1 DOUBLE, A2 TEXT COLLATE NOCASE, A3 DOUBLE); -- glob('[0-9]', '5') -- concat_ws('|', NULL, 'a', 'b') INSERT INTO A VALUES(acosh(39136),'ABC',1201900000); INSERT INTO A VALUES(39136,'ABC',1207000000); SELECT typeof(sum(a3)) FROM a; SELECT typeof(sum(a3)) FROM a GROUP BY a1; SELECT * FROM A AS a RIGHT OUTER JOIN A AS b ON a.rowid = b.rowid; WITH cte(a, b, c) AS (SELECT A3, A3, A3 FROM A) SELECT a, b, c FROM cte; CREATE TRIGGER IF NOT EXISTS trg_A_6440 BEFORE UPDATE OF A3 ON A BEGIN SELECT RAISE(ROLLBACK, 'rb'); END; INSERT INTO A SELECT * FROM A; ALTER TABLE A ADD COLUMN extra_6320 REAL COLLATE NOCASE; SELECT MIN(A3) FROM A; ``` ## Actual output ```sql SQLite version 3.39.0 2022-05-10 23:28:12 Enter ".help" for usage hints. sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> real sqlite> real real sqlite> sqlite> 11.2679452188836|ABC|1201900000.0|11.2679452188836|ABC|1201900000.0 39136.0|ABC|1207000000.0|39136.0|ABC|1207000000.0 sqlite> 1201900000.0|1201900000.0|1201900000.0 1207000000.0|1207000000.0|1207000000.0 sqlite> sqlite> sqlite> sqlite> 1201900000.0 sqlite> ``` ## Expectation ```sql SQLite version 3.51.1 2025-11-28 17:28:25 Enter ".help" for usage hints. sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> sqlite> real sqlite> real real sqlite> sqlite> 11.2679452188836|ABC|1201900000.0|11.2679452188836|ABC|1201900000.0 39136.0|ABC|1207000000.0|39136.0|ABC|1207000000.0 sqlite> 1201900000.0|1201900000.0|1201900000.0 1207000000.0|1207000000.0|1207000000.0 sqlite> sqlite> sqlite> sqlite> 1201900000.0 sqlite> ``` ## Flag ``` -interactive ```