Jan Penninkhof created OLINGO-891:
-------------------------------------
Summary: Use only two parameters in CONCAT function of JPA Where
Expressions
Key: OLINGO-891
URL: https://issues.apache.org/jira/browse/OLINGO-891
Project: Olingo
Issue Type: Bug
Components: odata2-jpa
Affects Versions: V2 2.0.6
Reporter: Jan Penninkhof
Fix For: V2 2.0.7
Substring filters such as the one below:
$filter=(substringof(%27Jan%27,FirstName)
Are translated into JPA where clauses similar to:
Where case when last_name like concat('%', 'Jan', '%') then 1 else 0 end=1
However, not all database support concat functions with more than 2 parameters.
The SAP Hana database is one of them.
I would propose to turn the where clause into:
Where case when last_name like concat('%', concat('Jan', '%')) then 1 else
0 end=1
to get the clause to run on more database platforms.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
