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