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);

Reply via email to