You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
What I'm experiencing is when the term 'NOT' is within the string(s) of columns we are trying to join, I'm getting back 'OperationalError: malformed MATCH expression' . My feeling is because there is a SQL dependency for reserved words, example below ought to show error.
He said he fixed it but he must have forgotten about 'NOT'.
I believe you are right. Anywhere the word 'not' is mentioned in my data it gives me an error. I've tried removing those entries one by one and that error for that particular entry goes away. However I still haven't been able to get rid of the error completely yet.
But yeah, seconding this. Still looking for a way around this. Would appreciate some tips.
It's fixed here on GitHub but when you install the package via pip, it seems that takes an older version.
You just have to edit the file fuzzymatcher/data_getter_sqlite.py and in the line 180, add the "NOT" token to escape:
tokens_to_escape = ["AND", "OR", "NEAR", "NOT"]
You can look for the location of the package with the command "pip show fuzzymatcher"
What I'm experiencing is when the term 'NOT' is within the string(s) of columns we are trying to join, I'm getting back 'OperationalError: malformed MATCH expression' . My feeling is because there is a SQL dependency for reserved words, example below ought to show error.
The below code snipped ought to reproduce error.
The text was updated successfully, but these errors were encountered: