Forgot to add DDL for the outer table: CREATE TABLE materializedInstances ( provider TEXT(2000000000), instanceId TEXT(2000000000), packageId INTEGER, date TEXT(2000000000), duration INTEGET, transportType INTEGER, CONSTRAINT MATERIALIZEDINSTANCES_PK PRIMARY KEY (provider,instanceId) );
CREATE INDEX 1ab7a7b8a24dce53a34a650587c5bfdabcc785a2 ON materializedInstances (packageId,provider,instanceId,date,duration,transportType); CREATE INDEX sqlite_autoindex_materializedInstances_1 ON materializedInstances (provider,instanceId);