[MongoDB] scalar list filter hasEvery is broken

[Weakky]

Overview

Let’s call string_list the following value: ["a", "b"].

Now try the following filter: { NOT: { string_list: { hasEvery: ["a", "c"] } } }

• Postgres will return true, because string_list: { hasEvery: ["c"] } returns false, and !false is true
• On Mongo though, we’ve implemented that differently. NOT hasEvery means “x does not contain any element of y”. Since "a" is present on both lists, it will return false.

To be clear, the Postgres result is the correct result.

Expected Result

The filter above should return true and not false