works! thank you.
On Friday, April 24, 2015 at 2:20:05 PM UTC+3, Luigi Dell'Aquila wrote: > > 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] > <javascript:>>: > >> 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] <javascript:>. >> 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.
