Info

Appears to be a change in behavior between 2.4.5 and 2.5.4-Pre how $gte and $gt evaluate arrays of booleans in some cases. The behavior in 2.5.4-Pre seems to be correct, ticket is to confirm that. Reproduce: db.q.drop(); db.q.insert({ "b" : [ [ ISODate("2013-09-29T00:00:00Z") ] ] }) db.q.insert({ "b" : [ [ ISODate("2008-02-29T00:00:00Z") ], "An inventor is simply a fellow who doesnt take his education too seriously." ] }) db.q.find( { "b" : { $gte : [ [ true ] ] } } ).itcount() db.q.find( { "b" : { $gte : [ true ] } } ).itcount() db.q.find( { "b" : { $gt : [ [ true ] ] } } ).itcount() db.q.find( { "b" : { $gt : [ true ] } } ).itcount() 2.4.5: 2 documents returned per query 2.5.4-Pre: Zero Note: However, these comparisons works the same on both versions db.q.find( { "b" : { $lte : [ [ true ] ] } } ).itcount() db.q.find( { "b" : { $lte : [ true ] } } ).itcount() db.q.find( { "b" : { $lt : [ [ true ] ] } } ).itcount() db.q.find( { "b" : { $lt : [ true ] } } ).itcount() db.q.find( { "b" : { $gte : true } } ).itcount() db.q.find( { "b" : { $gte : true } } ).itcount() db.q.find( { "b" : { $gt : true } } ).itcount() db.q.find( { "b" : { $lte : true } } ).itcount() db.q.find( { "b" : { $lt : true } } ).itcount()

Top User Comments

alvin commented on Mon, 28 Oct 2013 15:48:24 +0000: Another similar (and probably releated) case is for an array of Booleans db.q.drop() db.q.insert({"c" : [ [ false ] ] }) db.q.find( { "c" : { $gte : [ [ ISODate("0000-01-01") ] , ISODate("2008-02-29") ] } } ) db.q.find( { "c" : { $gt : [ [ ISODate("0000-01-01") ] , ISODate("2008-02-29") ] } } ) 2.4.5: One doc returned per query 2.5.4-Pre: Zero docs returned per query Note: The following return zero documents on both versions db.q.find( { "c" : { $lte : [ [ ISODate("0000-01-01") ] , ISODate("2008-02-29") ] } } ) db.q.find( { "c" : { $lt : [ [ ISODate("0000-01-01") ] , ISODate("2008-02-29") ] } } )

Steps to Reproduce