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
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.