× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
slavakiev reported 2013-10-08T10:55:55Z  · tariqrahiman last modified 2013-10-25T23:08:11Z

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

Issue #10360

Closed
Fixed
Resolved 2013-10-08T20:39:14Z
 
 
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