× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
vasudevpathak(*) reported 2016-02-12T07:37:20Z  · tariqrahiman last modified 2016-03-30T17:19:58Z

Unable to drop the user for MongoDB 3.2.1


Dev
Jenny Nishimura
JennyNishimura
QA vasudevpathak(*)
Priority Low
Complexity Unknown
Component MongoSQL
Version 17.0

Product: Aqua Data Studio
Version: 18.0.0-dev-49
Build #: 48564
Build Date: 2016-Feb-10 09:36:40 PM

Operating Environment: Linux (3.13.0-62-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_72-b15
Memory: Max=704,643,072;  Total=486,014,976;  Free=139,462,192;  CPUs=8

Database: MongoDB 3.2.1
Issue is applicable only for MongoDB 3.2.1

Steps to reproduce:

Connect with Mongo 3.2.1 and create one user.

  1. In Query Analyzer execute below script to create User
    CREATE  USER "test" IDENTIFIED BY 'test'
     
  2. User created. Expand Users tree node, Right click on  'test', select drop user
     
  3. Following Error message displayed. (Refer attached screen shot )
    Syntax error on input SQL `USE new`: MismatchedSetException(191!=null)

Observation -
a] Issue is specific to MongoDB 3.2.1 - script generated - Use dbName
// In the generated script double quotes around dbName is missing, causing the script to fail.

b]When ADS is connected to Previous version MongoDB 3.0.7- Proper script generates- Use "dbName"

1 attachment
  • Error

    2016-02-12T07:37:20Z

    109 KB

Issue #14276

Closed
Fixed
Resolved 2016-02-12T21:15:08Z
 
 
Completion
No due date
Fixed Build ADS 17.0.3-3, 18.0.0-dev-51
No time estimate

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