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.
