Wrong results when using $in and $nin together

techfort / LokiJS

javascript embeddable / in-memory database

http:/techfort.github.io/LokiJS

MIT License

6.71k stars 478 forks source link

Wrong results when using $in and $nin together #936

Open dnish opened 2 months ago

dnish commented 2 months ago

Hey, I'm try to use the following query:

    let newDB = loki.addCollection(`test`);
    newDB.insert([{a:1},{a:2},{a:3},{a:4}]);

    const doc = newDB.chain().find({a:{$nin:[1,2],$in:[2]}}).data();
    console.log(doc);

This will give me a:3 and a:4 as output, which is not correct because a needs to 2.