How does search query work?

[pitcairn1987]

👟 Reproduction steps

II'm designing a mobile app search filter and I have a fullindex on 2 attributes.

The Query.search method works strangely. For example, if I have the string "1111,2222", method finds the record both if I pass the string "2222" or "1111". But if the string looks like this "1111,ww" and I type "ww" it no longer finds this record. It only finds if I type "1111".

But this is not the only case where it works in unexpected ways.
For example, I have the string "11111hutat". When I type "hutat" it doesn't find me a record. But if I enter "11111 hutat", or "11111;hutat", so with some separator, it already finds.

I was wondering if it might have something to do with caching some things by backend, because It works in a completely unpredictable way.

👍 Expected behavior

Query.search method should always search in the whole string some substring, not from the beginning,

👎 Actual Behavior

It works in a completely unpredictable way. It only works always fine if I have a string of digits separated by a separator

🎲 Appwrite version

Version 1.0.x

💻 Operating system

Linux

🧱 Your Environment

I use appwrite as backend for Flutte mobile app.

👀 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

[stnguyen90]

Appwrite uses MariaDB's full-text search in boolean mode for the search query. When you make a query like:

Query.search("yearTags", ["1111"])

Appwrite sends a query to MariaDB like:

MATCH(yearTags) AGAINST("'1111*'" IN BOOLEAN MODE)

Note: The * at the end of your query value does a wildcard to support auto-complete.

source code

Since we're using MariaDB's full-text search, there are a few other things to keep in mind.

1. Only words are indexed. A "word" is considered "any sequence of true word characters (letters, digits, and underscores) as a word." A word may also contain 1 apostrophe.
2. Words less than 3 characters are ignored
3. Words greater than 84 characters are ignored

I hope that gives you more insight into how the search works.

[pitcairn1987]

Thanks!! I would never have guessed it:)

[xuelink]

Are there rules are still valid ? Because i can use search query with 1 char now.