Collection creation:
use apimindex
db.createCollection("garage")
db.garage.insert({"cars":["A","B","C"]})
db.garage.insert({"cars":["B","C","D"]})
db.garage.insert({"cars":["C","D","E"]})
db.garage.insert({"cars":["F","G","B"]})
db.garage.ensureIndex({"cars":1})
Informix behavior does not return the correct results using the
$in:
> db.garage.find()
{ "_id" : ObjectId("59553741ac1317d7bd258b91"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("5955374eac1317d7bd258b92"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955375bac1317d7bd258b93"), "cars" : [ "C",
"D", "E" ] }
{ "_id" : ObjectId("59553767ac1317d7bd258b94"), "cars" : [ "F",
"G", "B" ] }
> db.garage.find({"cars" : {$in:["A"]}})
> db.garage.find({"cars" : {$in:["A","B","C"]}})
{ "_id" : ObjectId("59553741ac1317d7bd258b91"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("5955374eac1317d7bd258b92"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955375bac1317d7bd258b93"), "cars" : [ "C",
"D", "E" ] }
{ "_id" : ObjectId("59553767ac1317d7bd258b94"), "cars" : [ "F",
"G", "B" ] }
> db.garage.find({"cars" : {$in:["B","C"]}})
{ "_id" : ObjectId("59553741ac1317d7bd258b91"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("5955374eac1317d7bd258b92"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955375bac1317d7bd258b93"), "cars" : [ "C",
"D", "E" ] }
{ "_id" : ObjectId("59553767ac1317d7bd258b94"), "cars" : [ "F",
"G", "B" ] }
> db.garage.find({"cars" : {$in:["C"]}})
{ "_id" : ObjectId("5955374eac1317d7bd258b92"), "cars" : [ "B",
"C", "D" ] }
After dropping index I get the correct behavior with informix
> db.garage.dropIndex("cars_1")
{ "ok" : 1, "nIndexesWas" : 2 }
> db.garage.find({cars: {$in:["A"]}})
{ "_id" : ObjectId("59553741ac1317d7bd258b91"), "cars" : [ "A",
"B", "C" ] }
> db.garage.find({"cars" : {$in:["A","B","C"]}})
{ "_id" : ObjectId("59553741ac1317d7bd258b91"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("5955374eac1317d7bd258b92"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955375bac1317d7bd258b93"), "cars" : [ "C",
"D", "E" ] }
{ "_id" : ObjectId("59553767ac1317d7bd258b94"), "cars" : [ "F",
"G", "B" ] }
> db.garage.find({"cars" : {$in:["B","C"]}})
{ "_id" : ObjectId("59553741ac1317d7bd258b91"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("5955374eac1317d7bd258b92"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955375bac1317d7bd258b93"), "cars" : [ "C",
"D", "E" ] }
{ "_id" : ObjectId("59553767ac1317d7bd258b94"), "cars" : [ "F",
"G", "B" ] }
> db.garage.find({"cars" : {$in:["C"]}})
{ "_id" : ObjectId("59553741ac1317d7bd258b91"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("5955374eac1317d7bd258b92"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955375bac1317d7bd258b93"), "cars" : [ "C",
"D", "E" ] }
MongoDB behavior appears to be correct with or without the index
MongoDB Enterprise > db.garage.find()
{ "_id" : ObjectId("595552f65d33235f736b80d8"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("595552fe5d33235f736b80d9"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("595553065d33235f736b80da"), "cars" : [ "C",
"D", "E" ] }
{ "_id" : ObjectId("5955530e5d33235f736b80db"), "cars" : [ "F",
"G", "B" ] }
MongoDB Enterprise > db.garage.find({"cars" : {$in:["A"]}})
{ "_id" : ObjectId("595552f65d33235f736b80d8"), "cars" : [ "A",
"B", "C" ] }
MongoDB Enterprise > db.garage.find({"cars" :
{$in:["A","B","C"]}})
{ "_id" : ObjectId("595552f65d33235f736b80d8"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("595552fe5d33235f736b80d9"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955530e5d33235f736b80db"), "cars" : [ "F",
"G", "B" ] }
{ "_id" : ObjectId("595553065d33235f736b80da"), "cars" : [ "C",
"D", "E" ] }
MongoDB Enterprise > db.garage.find({"cars" : {$in:["B","C"]}})
{ "_id" : ObjectId("595552f65d33235f736b80d8"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("595552fe5d33235f736b80d9"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("5955530e5d33235f736b80db"), "cars" : [ "F",
"G", "B" ] }
{ "_id" : ObjectId("595553065d33235f736b80da"), "cars" : [ "C",
"D", "E" ] }
MongoDB Enterprise > db.garage.find({"cars" : {$in:["C"]}})
{ "_id" : ObjectId("595552f65d33235f736b80d8"), "cars" : [ "A",
"B", "C" ] }
{ "_id" : ObjectId("595552fe5d33235f736b80d9"), "cars" : [ "B",
"C", "D" ] }
{ "_id" : ObjectId("595553065d33235f736b80da"), "cars" : [ "C",
"D", "E" ] }
MongoDB Enterprise > |
