Strings in IN Clauses should support Single Quotes

Number:	2523
Tracker:	Change Request
Author:	Mirko Matytschak
Version:	NDO 4.0.9
Assigned to:	Mirko Matytschak
Status:	Gelöst

This Linq expression fails:

var result = pm.Objects().Where(c=>c.name.In(new[]{"String'One","String''Two"})).ResultTable;

Currently this is converted into NDOql with the subexpression

IN ('String'One','String''Two')

which results in a syntax error, since the first string ends after 'String'. The Linq expression should result in an expression with doubled quotes like this:

IN ('String''One','String''''Two')

But this expression also fails with a syntax error, since NDOql doesn't support escaped single quotes. NDOql should support '' in string literals.

---

Status = Gelöst

---

Version = NDO 4.0.9

<<  previous   next  >>
Back to the Overview