After deleting the database without refresh, queries on multiEntry indexes will return duplicated objects.

[laukaichung]

Hello,

When I delete the database without refreshing the page, any queries on multiEntry indexes will return duplicate objects. However, duplicated results go away after refreshing the page. I read that it is advisable to use distinct() in queries on multiEntry indexes. but do you find anything wrong with my delete function that causes it?

db.config:

export class MySubClassedDexie extends Dexie {
    constructor() {
      playlists: "++id,*competitionIds",
     });
   }
}

db.on("populate", async () => {
  await db.playlists.bulkAdd(defaultPlaylists);
});

function deleteDB(){
   const blob = await db.export({
    filter: (table) => table === "playlists"
  });
  await db.delete();
  await db.open();
  await importInto(db, blob, { overwriteValues: true });
}

Screencaps:
https://imgur.com/ox7oqJI
https://imgur.com/dA3nTBP

[laukaichung]

I found that I have to use bulkPut in the populate event to avoid this error:

await db.playlists.bulkPut(defaultPlaylists);