On 8/16/16, Raja Kajiev <[email protected]> wrote: > > *The output of .fullschema command:----* > sqlite> .fullschema -indent > CREATE TABLE 'CLIPPED_UPDATE'( > CREATE TABLE 'DATASET'( > CREATE TABLE 'EXSET'( > CREATE TABLE 'EXSET_DATASET'( > /* No STAT tables available */
No indexes. No PRIMARY KEYs. I wonder if exset_id is actually the PRIMARY KEY of the exset_dataset table. Just adding a "PRIMARY KEY" declaration to that column in the CREATE TABLE statement might fix all of your problems. But to really do this right, you should consider adding appropriate PRIMARY KEYs and/or UNIQUE constraints and/or indexes on all of your tables, including the "trtu" TEMP table. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
