[
https://issues.apache.org/jira/browse/SYNCOPE-971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15686005#comment-15686005
]
ASF GitHub Bot commented on SYNCOPE-971:
----------------------------------------
Github user ilgrosso commented on a diff in the pull request:
https://github.com/apache/syncope/pull/40#discussion_r89058906
--- Diff:
core/persistence-jpa/src/main/java/org/apache/syncope/core/persistence/jpa/dao/JPAAnySearchDAO.java
---
@@ -769,7 +783,12 @@ private void fillAttributeQuery(final StringBuilder
query, final PlainAttrValue
if (not) {
query.append(" NOT ");
}
- query.append(" LIKE
?").append(setParameter(parameters, cond.getExpression()));
+ query.append(" LIKE ");
--- End diff --
Ah, it seems you're right, good to know!
For additional safety, I have found references for
[H2](http://www.h2database.com/html/functions.html#lower),
[MySQL](http://www.sqlinfo.net/mysql/mysql_function_upper_lower.php),
[PostgreSQL](https://www.postgresql.org/docs/9.3/static/functions-string.html),
[Oracle DB](http://www.sqlinfo.net/oracle/oracle_function_upper_lower.php), [MS
SQL
Server](http://www.sqlinfo.net/sqlserver/sql_server_function_upper_lower.php),
hence all of our supported DBMSes
> Case insensitive search
> -----------------------
>
> Key: SYNCOPE-971
> URL: https://issues.apache.org/jira/browse/SYNCOPE-971
> Project: Syncope
> Issue Type: Improvement
> Components: client, console, core
> Reporter: gonzalad
> Fix For: 2.0.2, 2.1.0
>
>
> Handle case insensitive search in syncope.
> i.e. querying all users with an attribute givenName that matches (case
> insensitive) 'martin' would return :
> * Martin
> * martin
> * mArtin
> A nice thing would be to provide a FIQL feature for this (with a custom
> operator ? with some fiql functions ?).
> Reference mail thread:
> https://lists.apache.org/thread.html/13284771128bcffbd860972c770ca0af6bbdb59948f70c969494aa50@%3Cuser.syncope.apache.org%3E
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
