## Summary **No review yet** ## Minimized query ```sql PRAGMA foreign_keys = FALSE; -- sign(1) PRAGMA cell_size_check = 3370811959573763011; PRAGMA page_size; .recover CREATE TABLE map_integer (id INT, name); INSERT INTO map_integer VALUES(1,'a'); CREATE TABLE map_text (id TEXT, name); INSERT INTO map_text VALUES('4','e'); CREATE TABLE data (id TEXT, name); INSERT INTO data VALUES(1,'abc'); INSERT INTO data VALUES('4','xyz'); CREATE VIEW idmap as SELECT * FROM map_integer UNION SELECT * FROM map_text; CREATE TABLE mzed AS SELECT * FROM idmap; PRAGMA automatic_index=ON; SELECT * FROM data JOIN idmap USING(id); CREATE TEMP VIEW IF NOT EXISTS v_map_integer_924 AS SELECT id FROM map_integer; SELECT NTILE(4) OVER (ORDER BY name GROUPS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) FROM map_integer; ``` ## Actual output ```sql 4096 PRAGMA foreign_keys=OFF; BEGIN; PRAGMA writable_schema = on; PRAGMA writable_schema = off; COMMIT; 1|abc|a 1 ``` ## Expectation ```sql 4096 .dbconfig defensive off BEGIN; PRAGMA writable_schema = on; PRAGMA foreign_keys = off; PRAGMA encoding = 'UTF-8'; PRAGMA page_size = '4096'; PRAGMA auto_vacuum = '0'; PRAGMA user_version = '0'; PRAGMA application_id = '0'; PRAGMA writable_schema = off; COMMIT; 4|xyz|e 1 ``` ## Flag ``` -nofollow ```