[OLINGO-891] Use only two parameters in CONCAT function of JPA Where Expressions

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: V2 2.0.6
• Fix Version/s: V2 2.0.7
• Component/s: odata2-jpa
• Flags: Patch
• Assignee: mibo
• Reporter: Jan Penninkhof
• Created: 23/Feb/16 00:36
• Updated: 24/Feb/16 20:25
• Resolved: 24/Feb/16 09:57

Description

Substring filters such as the one below:

$filter=(substringof(%27Jan%27,FirstName)

Are translated into JPA where clauses similar to:

Where case when first_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:

Patch included in the attachments