🐛 Bug Report: Search for a user by email returns all accounts with the same domain

[stonith404]

👟 Reproduction steps

Search for a user by its email adress in the console or with any sdk.

👍 Expected behavior

The response should be the user with the searched email adress.

👎 Actual Behavior

Appwrite ignores the character @ and lists all users with the same email provider (domain after the @).

🎲 Appwrite version

Version 0.13.x

💻 Operating system

Linux

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[eldadfux]

We are thinking on adding a queries param to all "list" endpoints to allow more flexibility in this area

[stnguyen90]

Appwrite ignores the character @ and lists all users with the same email provider (domain after the @).

Yes, the search uses MariaDB's Full Text Search in Boolean Mode (for the most part). In short, symbols are removed so that the text that is indexed becomes:

• test123 gmail com
• me gmail com
• test1 gmail com

And your search for [email protected] searches for test123, gmail, or com and all of them are returned because they either have gmail or com.

One solution is to wrap your search with double quotes:

Anything enclosed in the double quotes is taken as a whole (so you can match phrases, for example).

So, search for [email protected] searches for test123 gmail com.

Given:

Searching "[email protected]" results in:

[stonith404]

Thanks @stnguyen90 for your explanation that fixes it. I'll close the issue because it's not a bug.