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,
Skip to main content
New & Unread Topics
| Topic | Replies | Views | Activity |
|---|---|---|---|
| Aggregation on currentOp | 0 | 307 | May 2024 |
| Aggregating 50M of records | 4 | 442 | Nov 2024 |
| Glue MongoDB Pre-filter Data ISSUE | 0 | 191 | Aug 2024 |
| Index misses a document? | 4 | 52 | Oct 2024 |
| Performance of $gte, $lt range queries | 1 | 119 | Oct 2024 |