Aqua Data Studio 15.0.0-dev-269
Build #: 37723
Built on: 2014-May-06 06:22:23 PM
Windows 7:64 bit
Database: MongoDB 2.6
1: Connect to MongoDB
2: Open query analyzer for any database.
3: Execute following query.
INSERT INTO "policies"( "status", "coverages", "underwriting.staff_id", "underwriting.action", "underwriting.date")
VALUES( 'draft',[ { "type" : 'assets', "limit" : 1000000.0, "rates" : [ { "rate" : 200.0, "staff_id" : ObjectId('5097f7351d9a5999f5111d70'), "date" : ISODate('2012-12-05T17:29:54.561Z'), "current" : true } ] }, { "type" : 'car', "deductible" : 5004.0, "limit" : 100000.0, "rates" : [ { "rate" : 300.0, "staff_id" : ObjectId('5097f7351d9a5999f5111d70'), "date" : ISODate('2012-12-05T17:29:56.561Z'), "current" : true } ] } ], OBJECTID('5097f84cf8dd729bc7273069'), 'approved', ISODATE('2012-12-05T17:33:00.693Z'))
GO
4: Go to tree node -> Expand above created "policies" collection.
5: Drag n drop "covereges" or "underwriting" columns in query analyzer window.
Here it is observed that, columns having "record" or "array(record)" datatype are dropped with datatype appended to column name.
However only column name is dropped in query analyzer for columns having other than "record" datatype.