[
https://issues.apache.org/jira/browse/SYNCOPE-1922?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18033595#comment-18033595
]
ASF subversion and git services commented on SYNCOPE-1922:
----------------------------------------------------------
Commit 6378ea9a3b31aa0bfda829e1ff612276bc84d373 in syncope's branch
refs/heads/3_0_X from Andrea Patricelli
[ https://gitbox.apache.org/repos/asf?p=syncope.git;h=6378ea9a3b ]
[SYNCOPE-1922] raise error while searching by encrypted plain schema, removed
suggestion of such schemas on search in console (#1218)
> Disallow searches by encrypted attribute
> ----------------------------------------
>
> Key: SYNCOPE-1922
> URL: https://issues.apache.org/jira/browse/SYNCOPE-1922
> Project: Syncope
> Issue Type: Bug
> Components: core
> Affects Versions: 3.0.14, 4.0.2
> Environment: PostgreSQL JSONb
> Reporter: Andrea Patricelli
> Assignee: Andrea Patricelli
> Priority: Major
> Fix For: 3.0.15, 4.0.3, 4.1.0
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> # Define an encrypted plain schema and assing it to USER any object
> # Assign a value to such plain attribute of some user and save
> # Try to search by the encrypted plain attribute, the following exception
> raises
> {noformat}
> GenericPersistence: ReportingSQLException: ERROR: syntax error at end of
> jsonpath input
> Posizione: 182 {prepstmnt 1849864243 SELECT COUNT(DISTINCT t.id) FROM
> SyncopeUser t,jsonb_path_query_array(plainattrs, '$[*] ?
> (@.schema=="transparent")."values"') AS transparent WHERE
> ((jsonb_path_exists(transparent, '$[*] ? (@.stringValue == test)')) AND
> (realm_id IN (?)))} [code=0, state=42601]{noformat}
> This error appears only while JSONb persistence is enabled.
> Generally speaking searches by encrypted attributes shouldn't be allowed.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
