Hi Keith, in 2.1 we introduced a new, stricter parser, now valid identifiers (class names, property names and so on), can only contain letters, numbers, _ and $. For backward compatibility, you can disable the new parsing setting strictSql=false (see Studio -> db tab)
Thanks Luigi 2016-01-25 19:39 GMT+01:00 Keith Freeman <[email protected]>: > Hello, > > We recently upgraded from v2.0 to v2.1.9, and we're suddenly unable to > query our clusters. This query: > > select * from cluster:tdv-st-2014-01-19 > > worked fine in 2.0 (and earlier), but now we get (in console and in Java > API): > > Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: > Error on parsing command at position #0: Error parsing query: > select * from cluster:tdv-st-2014-01-19 > Encountered " "-" "- "" at line 1, column 26. > Was expecting one of: > <EOF> > <WHERE> ... > <ORDER> ... > <GROUP> ... > <LIMIT> ... > <SKIP2> ... > <OFFSET> ... > <TIMEOUT> ... > <FETCHPLAN> ... > <LOCK> ... > <LET> ... > <NOCACHE> ... > <PARALLEL> ... > <UNWIND> ... > ";" ... > <LET> ... > <WHERE> ... > <GROUP> ... > <ORDER> ... > <UNWIND> ... > <SKIP2> ... > <OFFSET> ... > <LIMIT> ... > <FETCHPLAN> ... > <TIMEOUT> ... > <LOCK> ... > <PARALLEL> ... > <NOCACHE> ... > > > Looks like it doesn't like "-" characters in the cluster name any more? > We've tried quoting the cluster name, etc. but haven't found a way to get > this query to work. Anybody have an idea? > > -- > > --- > 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.
