3378710 - CONTAINS() Query Syntax and Fuzzy Search Option for Asterisk '*'

If there is some special characters like asterisks "*" included in search term in "contains ()" clause, you might get unexpected result.  

For example : 

select mandt, spras,maktg,score() as score

FROM test_makt

WHERE mandt = '300'

AND SPRAS = '1'

AND contains( maktg ,'mytest 9*9*', fuzzy(0) )

ORDER BY score desc;

You expected there should be some data rows in the result set, but the returned result set is actually empty.

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

Asterisk '*', searchMode=alphanum, Fuzzy Search Option for Asterisk, Search Term, Alphanumeric Search, Search Mode 'alphanum' and Wildcards, Search Mode "alphanum", alphanum , KBA , HAN-DB , SAP HANA Database , Problem