[OLINGO-1445] Single quote in a string filtering not works as expected

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: V2 2.0.10
• Fix Version/s: V2 2.0.11
• Component/s: odata2-jpa
• Assignee: Unassigned
• Reporter: Vincent Benoit
• Created: 08/Apr/20 10:21
• Updated: 08/Apr/20 11:05
• Resolved: 08/Apr/20 11:05

Description

Hello,

When i try to filtering a string attribute with a value that contains a single quote, the JPA processor returns no values.

Step to reproduce: 

• Create a entity with string attribute
• Save a string with a single quote in that attribute like foo'bar
• Try to filter with substringof operator on that value
• The following filter has been generated : $filter=(substringof(%27foo%27%27%27,tolower(STRING_ATTRIBUT))
• No value is returned

Maybe related to issue OLINGO-1158