1493207 - [Machinery] Translation memory suggestion fails at longer strings due to postgres levenstein limitations

Status: RESOLVED DUPLICATE of bug 1469010

(Webtools Graveyard :: Pontoon, defect)

Description

[Serj Zee]

User Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.139 Safari/537.36

Steps to reproduce:

Version: commit a9f1982928a6a8739f114c0b590a8c138d6f24a4

1. I have the following string in my project:
"<b>Cookie notice:</b> This website uses cookies to improve functionality. By using this website without changing your browser settings, you consent to the use of cookies in accordance with our <a href="%(href)s" target="%(target)s" rel="%(rel)s" class="%(className)s" >Cookie Policy</a>." (287 chars)
2. Pontoon calls backend to  https://pontoon.local/translation-memory/?text=%3Cb%3ECookie+notice%3A%3C%2Fb%3E+This+website+uses+cookies+to+improve+functionality.+By+using+this+website+without+changing+your+browser+settings%2C+you+consent+to+the+use+of+cookies+in+accordance+with+our+%3Ca+href%3D%22%25(href)s%22+target%3D%22%25(target)s%22+rel%3D%22%25(rel)s%22+class%3D%22%25(className)s%22+%3ECookie+Policy%3C%2Fa%3E.&locale=ru&pk=522


Actual results:

Api call results in status code: 501 
Body: Not Implemented: levenshtein argument exceeds maximum length of 255 characters


Expected results:

200, response from backend containing suggestions.

---
Postgres' levenstein function (https://www.postgresql.org/docs/9.5/static/fuzzystrmatch.html) accepts input of maximum of 255 characters. Maybe trim or another function could be applied.