× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
umesh dutonde
dutondeumesh reported 2016-03-09T06:59:45Z  · raghavsingh last modified 2017-01-03T06:48:59Z

Unable to alter collections


Dev
Jenny Nishimura
JennyNishimura
QA vasudevpathak(*)
Priority Major
Complexity Unknown
Component MongoSQL
Version 18.0
ADS Version: 18.0.0-dev-73
Build #: 48849
Build Date: 2016-Mar-04 09:32:20 AM
 
Operating Environment: Linux (3.13.0-79-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_72-b15
Memory: Max=704,643,072;  Total=318,242,816;  Free=61,226,976;  CPUs=8
 
Database : Mongo DB 3.2.3
Steps : 
1. Open Query Analyzer(MongoSQL) and run below query
 
EVAL( db.createCollection( "contacts", { validator: { "$or" : [{ "phone" : { "$type" : "string" } }, { "email" : { "$regex" : /@mongodb\.com$/ } }, { "status" : { "$in" : ["Unknown", "Incomplete"] } }] }, validationLevel: "moderate", validationAction: "warn" } ) )
GO
 
2. Right click on collection(contacts) -> select  Alter option
3. Go to Options tab
   - Check capped option
   - Select Validation level from Moderate to strict
4. Click on Alter button
 
Result : An SQL statement failed to execute pop-up with Syntax error
 
Observation :
Script generated in Preview SQL Tab
 
ALTER COLLECTION "contacts" CAPPED SIZE 4096
EVAL( db.runCommand( { collMod: "contacts", validationLevel: "strict" } ) )
GO
 
Expected :
ALTER COLLECTION "contacts" CAPPED SIZE 4096
GO
EVAL( db.runCommand( { collMod: "contacts", validationLevel: "strict" } ) )
Go
 
3 attachments
  •  
  •  
  • No shares
  •  
All Comments (4) Change History
Sort 

Issue #14317
Closed
Fixed
Resolved 2016-03-11T01:22:37Z
 
 
Completion
No due date
Fixed Build ADS 18.0.0-devi-83
No time estimate

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