Error when including related table that does not have rows corresponding to the foreign key

[GGAlanSmithee]

Given the schema

db.version(1).stores({
    bands: '++id, name',
    albums: '++id, bandId -> bands.id, name'
})

If I add a band, but no corresponding album:

await db.bands.put({
    name: "My Band"
})

and then query the DB for bands, including albums by relation;

const bands = await db.bands.with({albums: 'albums'})

I´d expect to get one band with an empty array of albums, but instead I get the error

Promise.js:836 Unhandled rejection: Error: Could not lookup foreign key where albums.bandId == band.albums. The content of the failing key was: 1.

Is this the expected behaviour? Seems a bit odd that you cannot have 0 entities in a one to many relation.

[ccgman123]

I have been having the same issue.

line 194 of dexie-relationships/dist/index.js is

var record = lookup[foreignKey]

I switched it to the following and it fixed the issue.

var record = lookup[foreignKey] || [];

However i am not sure if this is the proper way of fixing the issue.

[KeithScheiwiller]

@dfahlander Any input on this? Or your branch for #12? Would either be safe enough to use?

[mickyginger]

Any update on this? I can make a PR for this if helpful