[syncope] branch 2_1_X updated: [SYNCOPE-1767] Fixing SQL query for MemberCond

[ilgrosso]

This is an automated email from the ASF dual-hosted git repository.

ilgrosso pushed a commit to branch 2_1_X
in repository https://gitbox.apache.org/repos/asf/syncope.git


The following commit(s) were added to refs/heads/2_1_X by this push:
     new 0bcb1f527b [SYNCOPE-1767] Fixing SQL query for MemberCond
0bcb1f527b is described below

commit 0bcb1f527b7b399bedb35dec36b5929bbe345158
Author: Francesco Chicchiriccò <ilgro...@apache.org>
AuthorDate: Wed Jun 21 16:07:21 2023 +0200

    [SYNCOPE-1767] Fixing SQL query for MemberCond
---
 .../org/apache/syncope/core/persistence/jpa/dao/JPAAnySearchDAO.java  | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git 
a/core/persistence-jpa/src/main/java/org/apache/syncope/core/persistence/jpa/dao/JPAAnySearchDAO.java
 
b/core/persistence-jpa/src/main/java/org/apache/syncope/core/persistence/jpa/dao/JPAAnySearchDAO.java
index ae4904d9e8..db6ea12681 100644
--- 
a/core/persistence-jpa/src/main/java/org/apache/syncope/core/persistence/jpa/dao/JPAAnySearchDAO.java
+++ 
b/core/persistence-jpa/src/main/java/org/apache/syncope/core/persistence/jpa/dao/JPAAnySearchDAO.java
@@ -862,7 +862,7 @@ public class JPAAnySearchDAO extends AbstractAnySearchDAO {
         }
 
         query.append("SELECT DISTINCT group_id AS any_id FROM ").
-                append(new 
SearchSupport(AnyTypeKind.USER).membership().name).append(" WHERE (").
+                append(new 
SearchSupport(AnyTypeKind.USER).membership().name).append(" WHERE ").
                 append("any_id=?").append(setParameter(parameters, memberKey)).
                 append(") ");
 
@@ -875,7 +875,7 @@ public class JPAAnySearchDAO extends AbstractAnySearchDAO {
         query.append("SELECT DISTINCT group_id AS any_id FROM ").
                 append(new 
SearchSupport(AnyTypeKind.ANY_OBJECT).membership().name).append(" WHERE ").
                 append("any_id=?").append(setParameter(parameters, memberKey)).
-                append("))");
+                append(')');
 
         return query.toString();
     }