I have been observing the following freaky behaviour of SQLite. When i run:
select count(*) from (select * from huge_table union all select * from
huge_table);
Sqlite starts writting in /var/tmp/ a file like:
/var/tmp/etilqs_gblRd6vUPcx91Hl, the root partition of fills up and an
error is raised.
Why does SQLite 3.7.14.1 need to write at all when doing union all? It
seems to me that there is no reason for doing so.
Best regards,
lefteris.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users