Francesco Chicchiriccò created SYNCOPE-1800:
-----------------------------------------------
Summary: FIQL comparison espressions with single quote cause JSONB
search to fail
Key: SYNCOPE-1800
URL: https://issues.apache.org/jira/browse/SYNCOPE-1800
Project: Syncope
Issue Type: Bug
Components: core
Affects Versions: 3.0.6
Reporter: Francesco Chicchiriccò
Assignee: Francesco Chicchiriccò
Fix For: 3.0.7, 4.0.0
A FIQL query like as
{code:java}
surname=~D'*
{code}
is throwing the following error:
{noformat}
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)'}{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
