[BUG] Insertion of a string value containing double quotes

[meuriceloup]

Hi guys,

I'm trying to migrate pre-existing relational data into a new polystore. I encounter a problem with data containing double quotes.

For example, let us suppose this user review which contains a double quote: blablabla " blablabla

When I try to execute the following query by escaping the double quote, insert Review {content: "blablabla \" blablabla"}

the engine returns this error: {"timestamp":"2020-07-16T12:00:05.458+0000","status":500,"error":"Internal Server Error","message":"500 Server Error","path":"/api/update"}

I tried with 1, 3, 5, ... backslashes, and always the same error.

I sure have the same error with prepared statements.

I guess there is a problem with the way the QL engine deals with backslashes.

Thanks in advance

[DavyLandman]

Oops, this was actually an open TODO, our string literals couldn't handle escapes yet, I'm gonna add them now.

[DavyLandman]

It should now work (be sure to repull the container), please open if it doesn't.

[meuriceloup]

it works now! thx ;-)

just for the ones who are interested in it:

• inserting double quote with simple insert query; insert Comment {comment: "blablabla this is a double quote \"."}

• inserting double quote with batch insert: {"command":"insert Comment{comment: ??comment}","parameterNames":["comment"],"boundRows":[["\"blablabla this is a double quote \\\".\""]]}