I am having problems while using Penthao $maxScan in MongoInput step. The query is as followed

{ $query : { "_id" : { $gte : {'$oid':"543d0f7402a697a69aba94ce"} } }, $maxScan : 50 }

This displays 50 results as expected no problems, but when I increase the number greater than 100 i.e.


{ $query : { "_id" : { $gte : {'$oid':"543d0f7402a697a69aba94ce"} } }, $maxScan : 101 }

This displays 204 rows which is the total number of records in my collection. Any pointers to what's happening here ? I also tried the $limit keyword but its also not working !