[orientdb] Re: SQL Parser in 2.1+ causes a parsing error with a SQL in version 1.7.8

Hi, See this link ALTER DATABASE custom strictSql=false You might have to rewrite some of your syntax. Regards S On Tuesday, 12 January 2016 00:19:58 UTC+5:30, Hung Tran wrote: > > Hi, > > I am migrating from version 1.7.8

[orientdb] A query gets a parsing error with LIMIT statement

Hi, I am migrating from version 1.7.8 to version 2.1.8, the SQL below does not working any more SELECT eval('$TotalListsQuery[0].Count') AS TotalLists LET $TotalListsQuery = ( SELECT Count(1) AS Count FROM ContactList WHERE Account=#20:1 AND EntityInfo.State=0) LIMIT 1 It is working if

Re: [orientdb] SQL Parser in 2.1+ causes a parsing error with a SQL in version 1.7.8

Hi, the problem seems to be in the ".@this", but does it actually make sense? What's the reason to have that in the query? Thanks Luigi 2016-01-11 19:49 GMT+01:00 Hung Tran : > Hi, > > I am migrating from version 1.7.8 to version 2.1.8, the SQL below does not > working

[orientdb] Re: A query gets a parsing error with LIMIT statement

Hi Hung, Try this: SELECT first(eval('$TotalListsQuery[0].Count')) AS TotalLists LET $TotalListsQuery = (SELECT Count(1) AS Count FROM ContactList WHERE Account=#20:1 AND EntityInfo.State=0) Regards, Michela -- --- You received this message because you are subscribed to the Google Groups

Re: [orientdb] Re: A query gets a parsing error with LIMIT statement

Hi Luigi, An issue is created https://github.com/orientechnologies/orientdb/issues/5589 My Best, Hung Tran On Tuesday, January 12, 2016 at 4:08:34 PM UTC+7, Luigi Dell'Aquila wrote: > > It seems to be a bug, could you please open an issue about this? > > Thanks > > Luigi > > > 2016-01-12 10:06

Re: [orientdb] Re: A query gets a parsing error with LIMIT statement

It seems to be a bug, could you please open an issue about this? Thanks Luigi 2016-01-12 10:06 GMT+01:00 : > Hi Hung, > > Try this: > > SELECT first(eval('$TotalListsQuery[0].Count')) AS TotalLists > LET $TotalListsQuery = (SELECT Count(1) AS Count FROM ContactList

[orientdb] Re: Pyorient batch parsing issue

Is this what you wanted? { "result": [ { "@type": "d", "@version": 0, "name": "Patent", "shortName": null, "defaultClusterId": 15, "clusterIds": [ 15 ],

[orientdb] Re: Issues with login (Permission denied)

Hi Michela, I'm using 2.1.8 community edition. Regards Muthukumar On Tuesday, January 12, 2016 at 12:08:15 AM UTC-5, user.w...@gmail.com wrote: > > Hi, > > Which version are you using? > > Regards, > Michela > -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Re: Pyorient batch parsing issue

Seems like an issue with escaping the string. Can you paste your schema here? On Tuesday, 12 January 2016 16:29:14 UTC+5:30, Shaun Gupta wrote: > > So actually if I run the SQL command in string ab: > > UPDATE Patent SET primary_id = 676, original_abstract = > set(original_abstract, "The

[orientdb] A projection query returns a result set of ODocuments instead

Hi, My code is OCommandSQL oCommand = new OCommandSQL("select COUNT(*) FROM (SELECT FROM User WHERE Email=:p0)") ArrayList result = database.command(oCommand).execute(paramMap); In version 1.7.8 and earlier versions, that will return a list of rows, in this case, that is [[1]] But in version

[orientdb] Re: Pyorient batch parsing issue

Shouldn't you be posting it on pyOrient github issues page? On Friday, 8 January 2016 16:47:04 UTC+5:30, Shaun Gupta wrote: > > I am currently trying to fill an orientdb graph database using pyorient. > In general, everything works well. However, I

[orientdb] Re: Pyorient batch parsing issue

So actually if I run the SQL command in string ab: UPDATE Patent SET primary_id = 676, original_abstract = set(original_abstract, "The present invention relates to compounds of the general formula (I) wherein\\n\\nR1 is the group (A) or (B) or (C) or (D); R2 is a non