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
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.
SAP Knowledge Base Article - Preview