× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
anilkalshetti reported 2015-12-16T06:51:22Z  · laxdeep(*) last modified 2016-02-01T06:40:49Z

QA(MongoJS)-> CREATE script is not generating properly for Multiple collections


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Minor
Complexity Unknown
Component MongoJS
Version 17.0

Aqua Data Studio 17.0.0-ga-4
Build #: 47801
Built on: 2015-Dec-15 07:09:53 PM     

OS: Ubuntu 14.04
Linux (3.13.0-59-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072;  Total=578,813,952;  Free=226,655,184;  CPUs=8
 
Database: MongoDB 3.0.7  
Storage Engine- MMAPv1 
 

Issue: QA(MongoJS)-> CREATE script is not generating properly for Multiple collections

Steps:

1. In QA(MongoJS), execute below script to create collection and collection index 

db.science.insert({project:'weather',duration:4});
db.science2.insert({project:'weather2',duration:8});
db.science.createIndex( { project: 1 } );
 
2. Right click on single collection 'science', and select option ->Script Object to Window As->CREATE (FULL)
script generated as below, this is expected behaviour-
db.createCollection( "science", { size:8192 } )
// MongoJS syntax is not supported for the selected object. Therefore, MongoSQL syntax has been generated.      
CREATE INDEX project_1
ON science(project)
GO


3. Open new QA(MongoJS) window, Select multiple collections (science and science2),   <-- Issue
Right click, select option->Script Object to Window As->CREATE
In 'Script Create Objects' window, click on OK button.
script generated as below in QA(MongoJS) window:

 

CREATE COLLECTION science 
 SIZE 8192
GO
CREATE INDEX _id_
    ON science(_id)
GO
CREATE INDEX project_1
    ON science(project)
GO
CREATE COLLECTION science2 
 SIZE 8192
GO
CREATE INDEX _id_
    ON science2(_id)

GO 

Observation:a] In QA(MongoJS) window, SQL script is generated for create collection instead mongojs script
                      b] For Index , '
MongoJS syntax is not supported' comment is not displayed
                       -- This issue is also observed in previous builds  ADS17.0.0-dev-48 and ADS17.0.0-rc-47
                       -- In ADS17.0.0-rc-47, issue was fixed for single collection-script generation- #13868

Expected: a] create collection script should be in mongojs format  [db.createCollection(..)]
                  b] For Index related script,  message should be displayed in comment as below- 

                     // MongoJS syntax is not supported for the selected object. Therefore, MongoSQL syntax has been generated.
 

3 attachments

Issue #14007

Closed
Fixed
Resolved 2015-12-18T19:01:11Z
 
 
Completion
No due date
Fixed Build ADS 17.0.0-ga-8
No time estimate

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