mongos> db.wheretest.remove()
|
mongos> db.wheretest.save({a:NumberLong(10), b: NumberLong(10)})
|
mongos> db.wheretest.save({a:NumberLong(9), b: NumberLong(10)})
|
mongos> db.wheretest.save({a:NumberLong(10), b: NumberLong(9)})
|
mongos> db.wheretest.find({$where: "this.a < this.b"},{_id:0,a:1,b:1});//OK
|
{ "a" : NumberLong(9), "b" : NumberLong(10) }
|
mongos> db.wheretest.find({$where: "this.a > this.b"},{_id:0,a:1,b:1});//OK
|
{ "a" : NumberLong(10), "b" : NumberLong(9) }
|
mongos> db.wheretest.find({$where: "this.a == this.b"},{_id:0,a:1,b:1});//NOT OK
|
mongos> db.wheretest.find({$where: "this.a.toNumber() == this.b.toNumber()"},{_id:0,a:1,b:1});//WORKAROUND
|
{ "a" : NumberLong(10), "b" : NumberLong(10) }
|
mongos>
|