Posts

Showing posts with the label data type

MongoDB tip, db.col.insert integer becomes double by default

Image
This post is using MongoDB version 3.2.11 I ran into this issue after we performed db.col.insertMany and everything seemed to work fine without a problem, all records were there... until application connected to it and we started seeing a bunch error.  We noticed that the error is indicating some sort of type error, so we began to investigate,  Through a simple test we can see how this version of mongod behaves when we perform a simple insert of an integer db.test.insert({a:1}) and we look into what we had inserted db.test.find().pretty() {     "_id" : ObjectId("59724963cd6857bf00a347fb"),     "testInt" : 1 } the output seems to have indicated it's stored correctly as an integer, but when we look deeper We can see the type is stored as double instead of int Therefore, to insert either the int32 or int64 type, we should do db.test.insert({b:NumberInt(1)})   for int32, or db.test.insert({c:Numbe...