× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported Apr 11, 2013  · swissarmyknife(*) last modified Jul 10, 2013

Syntax error for inserting date but same works with mongodb command terminal


Dev
Emil Goicovici
emil.goicovici
QA
Jenny Nishimura
JennyNishimura
Priority Low
Complexity Unknown
Component MongoSQL
Version 14.0
Version: 14.0-dev-37
Build #: 31885
Build Date: 2013-Apr-10 08:20:37 AM
 
Syntax error for inserting date but same works with mongodb command terminal
 
1. Execute the below query in a ADS Query Analyzer against a mongoDB Server and you get an invalid date error
2. Execute Query #2 against mongodb terminal which is the same query as in 1, but it executes fine without any error
 
Q #1
 

INSERT INTO jira_2 VALUES

{ "version" : "1.6.3",

"uptime" : 4712,

"uptimeEstimate" : 3844,

"localTime" : Date( "Wed Oct 13 20:52:15 2010" )

}

)

 

 

Q #2

 

db.jira_2.insert

{ "version" : "1.6.3",

"uptime" : 4712,

"uptimeEstimate" : 3844,

"localTime" : Date( "Wed Oct 13 20:52:15 2010" )

}

)

 

 

1 attachment
emil.goicovici   Apr 12, 2013
Field Old Value New Value
Fixed Build nosql-jdbc 1.1.1
SachinPrakash   Apr 16, 2013
Field Old Value New Value
Resolution Fixed
Resolved Date Apr 16, 2013 7:42 PM
Status New Resolved
tariqrahiman   May 1, 2013
Field Old Value New Value
Status Resolved Closed

Issue #8659

Closed
Fixed
Resolved Apr 16, 2013
 
 
Completion
No due date
Fixed Build nosql-jdbc 1.1.1
No time estimate

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