twice single quotes considered as single quotes

[niravshah2705]

stem_word function should have removed all the single quotes as it does not make sense to keep it in stem word.

here is the example where it keep 1 single quote from 2 single quotes string input.

select stem_word('en','hello'''''),'hello'''''; +-----------------------------+---------+ | stem_word('en','hello''''') | hello'' | +-----------------------------+---------+ | hello' | hello'' | +-----------------------------+---------+ 1 row in set (0.02 sec)

[jasny]

The stemmers are not defined by the udf. Instead it uses the snowball library. For english the porter stemmer is used. Have a look at the instructions on how to modify and rebuild the lib_snowball.