[infinispan-issues] [JBoss JIRA] (ISPN-9494) Ickl full-text queries with wildcards are affected by upper/lower case

[ https://issues.jboss.org/browse/ISPN-9494?page=com.atlassian.jira.plugin.... ] Gustavo Fernandes commented on ISPN-9494: ----------------------------------------- The full-text wildcard query is supposed to match the terms as they are stored in the index, so depending on the analyzer, it will not ignore capitalization. In the provided sample, if the firstName is "Wolfgang", given that this field is Analyzed (using the standard analyzer), it will be stored in the index as "*wolfgang*". So wolfg*ng should match, but not W*lfgang or Wolf*ng since they don't exist in the index. If the keyword analyzer were used, they the firstName would be stored in the index as "*Wolfgang*" (no analyzer), and "Wolfg*ng", Wolfgan*", etc would all match, but not "wolfgang". In general, the wildcard query should be avoided in conjunction with full-text searches, as it has a performance drawback that causes the search engine to scan for the terms rather than performing simple lookups. -- This message was sent by Atlassian Jira (v7.12.1#712002)