[Search field] Inconsistent search results displayed when entering three chars into the ‘Search’ field

[hanna-lenko]

Environment: Win10 v21H2 64-bit, Chrome v 98.0.4758.102
Reproducible: always
Build found: frontend: gcp-0.0.53, backend: gcp-0.0.114

Preconditions
Go to OoS (https://oos.dmytrominochkin.cloud/#/) as unregistered user
Set geographic location (e.g. ‘Київ’)
More than one workshop with word ‘танц’ in title OR description OR workshops' name OR keywords is registered

Steps to reproduce

1. Do the search with 4 chars (‘танц’)
2. Compare the results displayed on the page with records from the database. Use the following SQL query:

SELECT w.Title, w.Description, w.Keywords, w.ProviderTitle, a.City, a.Street, d.Title FROM Workshops w INNER JOIN Addresses a ON w.AddressId = a.Id AND a.City LIKE "%київ%" LEFT JOIN Directions d ON w.DirectionId = d.Id OR d.Title="%танц%" WHERE w.Description LIKE "%танц%" OR w.Title LIKE "%танц%" OR w.Keywords LIKE "%танц%" OR w.ProviderTitle LIKE "%танц%"

3. Do the search with 3 chars (‘тан’)
4. Compare the results displayed on the page with records from the database. Use the following SQL query:

SELECT w.Title, w.Description, w.Keywords, w.ProviderTitle, a.City, a.Street, d.Title FROM Workshops w INNER JOIN Addresses a ON w.AddressId = a.Id AND a.City LIKE "%київ%" LEFT JOIN Directions d ON w.DirectionId = d.Id OR d.Title="%тан%" WHERE w.Description LIKE "%тан%" OR w.Title LIKE "%тан%" OR w.Keywords LIKE "%тан%" OR w.ProviderTitle LIKE "%тан%"

Actual result

1. The 10 workshops are found and displayed on the page.
   

2. The 10 workshops are returned by script, records are equal to workshops displayed on the page.
   

3. One workshop is found and displayed on the page
   

4. The 10 workshops are returned by script, records are NOT equal to workshops displayed on the page.
   

Expected result
All search results compare with all the words that are in title, description, workshops' name, keywords: the 10 workshops are displayed when searching with 3 chars ‘тан’.

User story and test case links
User stories #23, #213
Test case OS-261

Labels to be added
"Bug", "pri: medium", "severity: major", Type "Functional".

[OksanaGuz]

Bug is reproducible with entered 3 characters, value "тан" displays 0 workshops

There should be 14 workshops

[litvinets]

@OksanaGuz @DmyMi I believe this is not a bug, because search is performing not only by title but also by keyword, categories, else

[ViktoriiaHrytchyna]

Bug is not fixed