Hi Glenn, Please could you open a new issue or that? Best Regards,
Luca Garulli Founder & CEO OrientDB <http://orientdb.com/> On 21 August 2015 at 13:15, Glenn Irwin <[email protected]> wrote: > I am migrating to 2.1 and I noticed that the SQL parser gives me an error > when I try to give it a data string (wrapped in quotes) with a newline or > \r in it. I am just trying to update the field that was inserted directly > with Java API which accepted the data just fine with the newlines. But > when I update it using SQL, it doesn't accept it. > > Exception in thread "Thread-8" > com.orientechnologies.orient.core.sql.parser.TokenMgrError: Lexical error > at line 1, column 68. Encountered: "\r" (13), after : "\"/* horizontal > menu style */" > > at > com.orientechnologies.orient.core.sql.parser.OrientSqlTokenManager.getNextToken( > OrientSqlTokenManager.java:3370) > > at com.orientechnologies.orient.core.sql.parser.OrientSql.getToken( > OrientSql.java:12758) > > at com.orientechnologies.orient.core.sql.parser.OrientSql.Expression( > OrientSql.java:4167) > > at com.orientechnologies.orient.core.sql.parser.OrientSql.UpdateItem( > OrientSql.java:2403) > > at com.orientechnologies.orient.core.sql.parser.OrientSql.UpdateOperations( > OrientSql.java:2220) > > at com.orientechnologies.orient.core.sql.parser.OrientSql.UpdateStatement( > OrientSql.java:2053) > > at com.orientechnologies.orient.core.sql.parser.OrientSql.Statement( > OrientSql.java:571) > > at com.orientechnologies.orient.core.sql.parser.OrientSql.parse( > OrientSql.java:79) > > > any advice as to what I can do? Is there any way to encode a newline in a > string in OrientDB SQL? > > -- > > --- > 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.
