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
Even when the search string is empty, the where clauses are added:
select*from`users`where (`users`.`name`like'%%'or`users`.`email`like'%%'or match (`users`.`notes`) against (''in natural language mode))
order by`id`desclimit30 offset 0
Which for the database driver is irrelevant and could lead the query optimizer to pickup a wrong index (when more constraints are added).
If skipping adding the where clauses when the search string is empty is a desirable I can send a PR.
The text was updated successfully, but these errors were encountered:
Right now if we search for an empty string, for example in a endpoint that lists all users:
Even when the search string is empty, the where clauses are added:
Which for the database driver is irrelevant and could lead the query optimizer to pickup a wrong index (when more constraints are added).
If skipping adding the where clauses when the search string is empty is a desirable I can send a PR.
The text was updated successfully, but these errors were encountered: