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

Different result sets when using combination of keywords  in upper case and lower case a period 

This should not  impact the result sets . The following combination  "sl." and "SL."  should return the same 

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.