Substring in combination with Array results in wrong SQL (Oracle)
Posted: Tue 26 Jul 2022 11:27
If you use a substring in combination with an array (in c#) devart creates wrong SQL.
Here are some (pseudo) code to reproduce:
First call is correct, it generates:
but second looks like:
and the next one will be:
and so forth.
Looks like an static variable which get increased every call.
Version was Devart.Data.Oracle.EFCore Version=9.16.1434, also the Version 10 has the same bug.
Here are some (pseudo) code to reproduce:
Code: Select all
var array = new string[] { "23", "71" };
var query = this.DataContext.MyState.Where(x => array.Contains(x.Value.Substring(0, 2)));
var q = query.ToQueryString();
Code: Select all
SELECT "f".ID, "f".VALUE
FROM MYSTATE "f"
WHERE SUBSTR("f".VALUE, 0 + 1, 2) IN ('23', '71')
Code: Select all
SELECT "f".ID, "f".VALUE
FROM MYSTATE "f"
WHERE SUBSTR("f".VALUE, (0 + 1) + 1, 2) IN ('23', '71')
Code: Select all
SELECT "f".ID, "f".VALUE
FROM MYSTATE "f"
WHERE SUBSTR("f".VALUE, (((0 + 1) + 1) + 1) + 1, 2) IN ('23', '71')
Looks like an static variable which get increased every call.
Version was Devart.Data.Oracle.EFCore Version=9.16.1434, also the Version 10 has the same bug.