× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
slavakiev reported Oct 8, 2013  · tariqrahiman last modified Oct 25, 2013

Issues with Primary Key tab( not all types shown and no refresh)


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Tools - Table Data Editor
Version 14.0

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:

insert into bson_coll("bson.uud","bson.md","bson.cd","bson.hd","bson.iso","bson.dates","bson.timer","bson.min","bson.max",
"bson.pattern","bson.oid","bson.dbr") values (
UUID ( '10110100111001110011001001111001' ),
MD5 ( 'AABBCCDDEEFF' ),CODE ( 'conn = new Mongo()' ), HEXDATA ( 'FF' ),
ISODATE ( '212-12-12T19:18:12.977Z' ),Date ( 'MAY 12, 2013' ),BSONTimeStamp ( 123,1 ),MinKey ( ) ,MaxKey ( ) ,pattern ( 'j.h?.' ,2 ),
ObjectId ( '123456789012345678901234' ) ,DBREF ( 'Parent_collection' , '518d39f7ecde1f4f0ab442f2' , 'Parent_DB' ) )
go
 

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 attachment
SachinPrakash   Oct 8, 2013
Field Old Value New Value
Dev Assignee SachinPrakash (Sachin Prakash) JennyNishimura (Jenny Nishimura)
JennyNishimura   Oct 8, 2013
Field Old Value New Value
Fixed Build ADS 14.0.0-1
Resolution Fixed
Resolved Date Oct 8, 2013 8:39 PM
Status New Resolved
tariqrahiman   Oct 10, 2013
Field Old Value New Value
Status Resolved Verified
tariqrahiman   Oct 25, 2013
Field Old Value New Value
Status Verified Closed

Issue #10360

Closed
Fixed
Resolved Oct 8, 2013
 
 
Completion
No due date
Fixed Build ADS 14.0.0-1
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017