EF7: issue with case/when in version 10.1.151.7 (ORA-00920 : invalid relational operator)
Hi,
In version 10.1.151.7 a wrong query is generated. We currently use version 10.1.134.7 which doesn't have this issue.
The generated query looks as follows (in bold the incorrect part):
----
SELECT "l".A "A", "l".B "B", (CASE
WHEN "l".C THEN 2
ELSE 1
END) "X", (CASE
WHEN "l".D THEN 2
ELSE 1
END)
"Y", (CASE
WHEN "l".E THEN 2
ELSE 1
END)
"Z"
FROM T1 "l"
----
correct syntax is: WHEN "l".C = 1 THEN 2