"suggest" API call difference to PHP version
I confirm that this is an issue with aurweb's code and not a user-uploaded package.
I have described the bug in complete detail in the Description section.
I have specified steps in the Reproduction section.
I have included any logs related to the bug in the Logs section.
I have included the versions which are affected in the Version(s) section.
The suggest method returns a different result in the FastAPI implementation:
The PHP one queries with
like 'searchterm%' whereas the python one does
StartsWith vs. Contains...
This has a huge impact on performance as well since the latter one needs to perform a table-scan and can't rely on the index on the "Name" column.
Probably intended though
Run the same query against against both endpoints and compare the results. (F.e.