OrientDB 2.1 - newline in string in SQL

[Glenn Irwin]

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?

[Luca Garulli]

Hi Glenn,

Please could you open a new issue or that?

Best Regards,

Luca Garulli

Founder & CEO

OrientDB

--

---
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 orient-databa...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Glenn Irwin]

Issue #4837 opened

I suppose I could encode my updates to the Java API instead of assembling SQL but I think it would be useful to be able to update this data through SQL as well as direct API.

Thanks