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.


Mirko Matytschak - 21.12.2021 13:20:14

Status = Gelöst


Mirko Matytschak - 21.12.2021 14:06:50

Version = NDO 4.0.9

<<  previous   next  >>
Back to the Overview