Schema: CREATE TABLE combination7 (mer7 TEXT PRIMARY KEY, pop_ur50 DEFAULT 0, pop_dev_ur50 DEFAULT 0, pop_est DEFAULT 0, amylogen DEFAULT 0, pop_ur50_nr DEFAULT 0, pop_dev_ur50_nr DEFAULT 0); CREATE INDEX id_pop on combination7(pop_ur50); CREATE INDEX id_pop_dev on combination7(pop_dev_ur50); CREATE INDEX id_pop_est on combination7(pop_est); CREATE INDEX id_amylogen on combination7(amylogen); CREATE INDEX id_pop_nr on combination7(pop_ur50_nr); CREATE INDEX id_pop_dev_nr on combination7(pop_dev_ur50_nr); CREATE INDEX id_pop_dev_amylog on combination7(pop_dev_ur50,amylogen); CREATE INDEX id_pop_dev_nr_amylog on combination7(pop_dev_ur50_nr,amylogen); /* No STAT tables available */ sqlite> select count(*) from combination7 where amylogen < 0.5; Error: database disk image is malformed sqlite> pragma quick_check; ok sqlite> pragma integrity_check; (still running) Best regards, Witek