I have version string field/property in collection which stores semantic version values like ‘12.0.0’, ‘9.0.0’, ‘9.3.0’ etc.
When I execute following syntax { version: { $in: “9.0.0” } } i get about 54 records but when execute { version: { $gte: “9.0.0”, $lte: “10.0.0” } } I get none, why?
I thought MongoDB does Lexicographic Comparison.
Thanks,