[SYNCOPE-1800] FIQL comparison espressions with single quote cause JSONB search to fail

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.6
• Fix Version/s: 3.0.7, 4.0.0
• Component/s: core
• Labels: jsonb
• Assignee: Francesco Chicchiriccò
• Reporter: Francesco Chicchiriccò
• Created: 04/Jan/24 08:45
• Updated: 17/May/24 07:25
• Resolved: 04/Jan/24 09:57

Description

A FIQL query like as

surname=~D'*

is throwing the following error:

org.apache.openjpa.persistence.PersistenceException: Unterminated identifier started at position 209 in SQL SELECT count(t.id) FROM SyncopeUser t,jsonb_path_query_array(plainattrs, '$[*] ? (@.schema=="lastName")."values"') AS lastName WHERE jsonb_path_exists(lastName, '$[*] ? (@.stringValue like_regex "D'.*" flag "i")') AND realm_id IN (?1)'. Expected " char {SELECT count(t.id) FROM SyncopeUser t,jsonb_path_query_array(plainattrs, '$[*] ? (@.schema=="lastName")."values"') AS lastName WHERE jsonb_path_exists(lastName, '$[*] ? (@.stringValue like_regex "D'.*" flag "i")') AND realm_id IN (?1)'}

Issue Links

• links to: GitHub Pull Request #593