Tested in Aqua Data Studio 14.0.0-rc-44 Build #: 34314 on Ubuntu 12.04( Mongo DB 2.4.3)
1. Not all types shown:
Create bson_coll collection:
and open it in the Table Editor/Primary Key tab.
Next types not shown: binary(HexData), BSONTimeStamp, DBRef, MaxKey, MinKey.
Binary(HexData) is editable and has 1 param in MongoSQL realization and definitely should be shown on the Primary Key tab. BSONTimeStamp and DBRef are complex types( have more than 1 paramater) and it is hard to make them editable. But they are cloned without problem. Why in the same way they can't be included into the WHERE clause? MaxKey and Minkey have no sence in the WHERE so their absence is not a problem. But better to include them too to have same view as in the Alter Table dialog.
2. No refresh:
When make changes in the Table Editor which alters collection structure, e.g. delete first row which differs from second row in number of fields and save changes/press Refresh button. Then open Primary Key tab - it will still show old collection structure. No refresh happens.
1) Won't Fix
- MongoDB supports different binary subtypes. MongoSQL supports only subtype 0, MD5, and UUID. Therefore, binary fields don't appear in the Primary Key tab.
- MinKey and MaxKey are for MongoDB internal use only. Therefore, they don't appear in the Primary Key tab. From MongoDB documentation:
MinKey and MaxKey compare less than and greater than all other possible BSON element values, respectively, and exist primarily for internal use.
2) Fixed
- The error message that the table definition may have been changed and inform the user to reopen the Table Data Editor will now be displayed if the underlying metadata has been changed.
Issue #10360 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 14.0.0-1 |
No time estimate |
1) Won't Fix
- MongoDB supports different binary subtypes. MongoSQL supports only subtype 0, MD5, and UUID. Therefore, binary fields don't appear in the Primary Key tab.
- MinKey and MaxKey are for MongoDB internal use only. Therefore, they don't appear in the Primary Key tab. From MongoDB documentation:
2) Fixed
- The error message that the table definition may have been changed and inform the user to reopen the Table Data Editor will now be displayed if the underlying metadata has been changed.