## Summary **No review yet** ## Minimized query ```sql ATTACH DATABASE ':memory:' AS aux6; CREATE TABLE T ( a INTEGER, b TEXT, c REAL ); INSERT INTO T VALUES (1,'a',1.25), (2,'b',-3.5), (3,'c',9e999); WITH d AS (SELECT * FROM T) SELECT * FROM d WHERE c > 0; PRAGMA module_list; PRAGMA journal_mode; PRAGMA user_version; .prompt 'IPA eli isopropanoli on loistava puhdistusaine joka irrataa' CREATE TABLE t1(a,b,x); CREATE TABLE t2(c,d,y); CREATE INDEX t1b ON t1(b); CREATE INDEX t2d ON t2(d); ANALYZE sqlite_master; INSERT INTO sqlite_stat1 VALUES('t1','t1b','10000 500'); INSERT INTO sqlite_stat1 VALUES('t2','t2d','10000 500'); ANALYZE sqlite_master; SELECT * FROM t1, t2 WHERE d=b; SELECT * FROM t1, t2 WHERE d>b AND x=y; DETACH DATABASE aux6; SELECT * FROM T WHERE a IN (SELECT a FROM T); SELECT MAX(x) FROM t1; PRAGMA soft_heap_limit = 10000000; CREATE TEMP VIEW IF NOT EXISTS v_T_6525 AS SELECT a FROM T; SELECT * FROM t2 AS a JOIN t1 AS b ON a.rowid = b.rowid; REINDEX; ``` ## Actual output ```sql 1a1.253cInfsqlite_dbdatagenerate_seriescompletionfsdirtables_usedsqlite_stmtjson_treefts4auxfts3fts4sqlite_dbptrfts3tokenizebytecodertree_i32sqlite_dbpagertreedbstatjson_eachmemory01a1.252b-3.53cInf10000000 ``` ## Expectation ```sql 1a1.253cInffsdirgenerate_seriesbytecodedbstattables_usedsqlite_stmtsqlite_dbpagertree_i32fts4auxfts3zipfilefts4completionrtreefts3tokenizememory01a1.252b-3.53cInf10000000 ``` ## Flag ``` -ascii ```