Bug Report: Search for a user by email which have underscore "_" with no results

[hugebug4ever]

👟 Reproduction steps

When I search a user by email, the email name have underscore inside the name, there is no result returned.

It's different with the non-bug issue here
The search is already quoted by "

👍 Expected behavior

the search should return the user with the specified email

👎 Actual Behavior

🎲 Appwrite version

Version 1.3.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

[joeyouss]

Hey! Thanks for bringing this to our attention. I tried reproducing and looking into it and have passed on this to my team. I will get back to you, soon!

[joeyouss]

A PR is on the way for the fix! utopia-php/database#279

[sunjianan9900]

Searching under fulltxt index, the problem still exists (1.3.7)

[sunjianan9900]

Can be tested on a running website "pubdev.top" , and search 'stack_art_board' and 'stack'

the des in this document is:

stack_art_board||*|A Flutter package consisting of stacks that allows adding any widgets, and enables editing, deleting, and changing the order of layers.

Query.search("des", "stack_art_board") ==> no this document
Query.search("des", "stack") ==> got this document