Shouldn't vdbeaux.c line 753: rc = sqlite3BtreeFactory(db, ":memory:", 0, TEMP_PAGES, &pAgg->pBtree); obey the TEMP_STORE macro so it is stored either in memory or disk?
I know it's there for speed, but that's what TEMP_STORE is for. Isn't it? If I change in that line the ":memory:" to a 0 (zero), would I break anything? Also it seems the parser "supports" something weird: CREATE TABLE table1 (field1 integer); CREATE TABLE table2 (field2 integer); INSERT INTO table1 (field1) VALUES (1); INSERT INTO table2 (field2) VALUES (2); SELECT table1. field1, table2. field2 FROM table1, table2; Note the extra spaces between tables and fields in SELECT.