When querying MongoDB, if there are multiple 'not in' or '!=' statements in the 'where' clause, the query results may be abnormal.

[huangfox]

For example, there is a MongoDB data collection with three records.

When executing the following statement, the query results are abnormal.
select * from test_user where id !=1 and flag!=0;

The filter condition 'id != 1' did not take effect.

If only the 'id != 1' filter condition is present, the query results are correct.
select * from test_user where id !=1 ;

[huangfox]

This exception started occurring from version 402.

[ebyhr]

MongoSession#buildQuery method has a bug. The 1st predicate is overwritten by the 2nd predicate in the for loop because the internal key $or is duplicated.