SAP Knowledge Base Article - Preview

3522838 - Fuzzy Text Search with a period in the search term scores differs in case sensitivity vs case in sensitivity

Symptom

Issue is when same keywords are used in upper case and lower case in combination with a "period" . ,  getting different results. Whereas this shouldn't impact the hits result for same alphabet i.e. "sl." and "SL.". 

SELECT

            TO_DECIMAL(SCORE(), 3, 2) AS score, *, CAST(HIGHLIGHTED(companyname) AS NVARCHAR(250))  AS mch_kws

FROM

            table1

WHERE

            CONTAINS(companyname, 'SL.', FUZZY(0.5, 'textSearch=compare,andSymmetric=on,composeWords=2,spellCheckFactor=0.6,minTextScore=0.5,andThreshold=0.51'))

ORDER BY

            score DESC, ID;

 

Search for ‘SL.’, score is 0.7


Search for ‘sl.’, score is 0.83

What is the logic for upper case and lower case in combination with a "Period" in Fuzzy Text Search?

From the above the score should be the same .

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

SAP HANA, platform edition  -  SPS 05 or higher. 

Product

SAP HANA, platform edition all versions

Keywords

FUZZY SEARCH , TOKEN SEPARATORS, SCORE , PERIOD , FAST PREPROCESS ON , KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.