[ https://issues.apache.org/jira/browse/SYNCOPE-1800?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17802864#comment-17802864 ]
ASF subversion and git services commented on SYNCOPE-1800: ---------------------------------------------------------- Commit e7580420f49457627829c3f0dc038d9d4a8da053 in syncope's branch refs/heads/3_0_X from Francesco Chicchiriccò [ https://gitbox.apache.org/repos/asf?p=syncope.git;h=e7580420f4 ] [SYNCOPE-1800] Correct escape for single quote added also when regex is used (#593) > 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ò > Priority: Major > Labels: jsonb > 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)