OrientDB 2.1 - newline in string in SQL

Skip to first unread message

Glenn Irwin

Aug 21, 2015, 7:15:54 AM8/21/15
to OrientDB
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

Aug 21, 2015, 8:46:10 AM8/21/15
to OrientDB
Hi Glenn,
Please could you open a new issue or that?

Best Regards,

Luca Garulli
Founder & CEO


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

Aug 21, 2015, 2:34:42 PM8/21/15
to OrientDB
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.

Reply all
Reply to author
0 new messages