Hi Adrian, let me guess, you are trying it on 2.1 but with the old db, aren't you? The new parser is disabled by default on old databases (for backward compatibility and soft transition) and is enabled by default on newly created DBs.
You can enable it with the following command: alter database custom strictSql = true I tried your query on my local 2.1 rc1 and it works fine. Let me know if it works for you too Thanks Luigi 2015-04-24 8:12 GMT+02:00 Adrian Mihalcea <[email protected]>: > I Luigi, > > > thanks for the reply. Followed your advice, and installed v2.1-rc1. This > problem doesn't appear to go away though: > > here's an excerpt from the server's console. Ran the query through the web > UI. > > 2015-04-24 09:06:46:502 INFO OrientDB Server v2.1-rc1 is active. [OServer] > 2015-04-24 09:07:13:453 SEVERE Internal server error: > com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error > on parsing command at position #47: Invalid keyword '0' > Command: select $x from A let $x = out() where $x.size()>0 > > let me know if I can help with some other tests or verifications. > > On Thursday, April 23, 2015 at 3:11:13 PM UTC+3, Luigi Dell'Aquila wrote: > Hi Adrian, > > > v 2.0 suffers from a lot of these problems with the SQL parser. In 2.1 we > rewrote it from scratch, so all these problems will be fixed in that > release. RC1 is already available and final release will be ready in a few > weeks. > > > Regards > > > Luigi > > > > > 2015-04-23 14:03 GMT+02:00 Adrian Mihalcea <[email protected]>: > > Hi all, > > > this is not that big of a problem, but it can be annoying if you can't > figure out why. I'm using version 2.0.8 for this. > > > for a query like:select $x from A let $x = out() where $x.size()>0 > > > I get this exception in the web UI: > com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error > on parsing command at position #47: Invalid keyword '0' Command: select $x > from A let $x = out() where $x.size()>0 > -------------------------------------------------------^ > > > the culprit seems to be the last part. If I rewrite the statement with > spaces around > operator, it works fine: > > > select $x from A let $x = out() where $x.size() > 0 > > > > Best Regards, > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > > -- > > --- > You received this message because you are subscribed to the Google Groups > "OrientDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
