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
We have 3 products with the name:
1.защитное стекло для экрана samsung galaxy
2.защитное стекло для экрана apple iphone
3.защитное стекло для экрана xiaomi
• we have a synonym "бронестекло => защитное стекло"
upon request SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло' I get all 3 items.
But if I add another word, there will be errors:
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +iphone'
I expect to get only the second product, but I get all three.
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +samsung'
I expect to see only the first product, but displays all three products
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +xiaomi'
I expect only the third product, but displays all three.
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +something +not +in +the +title'
I expect a blank search, but all three products are displayed
type Product struct {
Id string reindex:"id" json:"id"
SpaceId string reindex:"space_id" json:"space_id"
Name string reindex:"name,tree" json:"name"
_ struct{} reindex:"name+brand=search_products,text,composite"
_ struct{} reindex:"id+space_id,,composite,pk"
}
products := []Product{
{
Id: "1",
SpaceId: "msk_cl",
Name: "защитное стекло для экрана samsung galaxy",
},
{
Id: "2",
SpaceId: "msk_cl",
Name: "защитное стекло для экрана apple iphone",
},
{
Id: "3",
SpaceId: "msk_cl",
Name: "защитное стекло для экрана xiaomi",
},
}
The text was updated successfully, but these errors were encountered:
ilyamaksimov1991
changed the title
Некорректная работа полнотекстового поиска при использовании синонима в связке с дополнительным словом
Incorrect work of full-text search when using synonym with an extra word
Sep 24, 2020
We have 3 products with the name:
1.защитное стекло для экрана samsung galaxy
2.защитное стекло для экрана apple iphone
3.защитное стекло для экрана xiaomi
• we have a synonym "бронестекло => защитное стекло"
upon request SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло' I get all 3 items.
But if I add another word, there will be errors:
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +iphone'
I expect to get only the second product, but I get all three.
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +samsung'
I expect to see only the first product, but displays all three products
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +xiaomi'
I expect only the third product, but displays all three.
SELECT , COUNT() FROM products WHERE search_products = '@name +бронестекло +something +not +in +the +title'
I expect a blank search, but all three products are displayed
type Product struct {
Id string reindex:"id" json:"id"
SpaceId string reindex:"space_id" json:"space_id"
Name string reindex:"name,tree" json:"name"
_ struct{} reindex:"name+brand=search_products,text,composite"
_ struct{} reindex:"id+space_id,,composite,pk"
}
products := []Product{
{
Id: "1",
SpaceId: "msk_cl",
Name: "защитное стекло для экрана samsung galaxy",
},
{
Id: "2",
SpaceId: "msk_cl",
Name: "защитное стекло для экрана apple iphone",
},
{
Id: "3",
SpaceId: "msk_cl",
Name: "защитное стекло для экрана xiaomi",
},
}
The text was updated successfully, but these errors were encountered: