Error Code: 1064. no such table '' - при fuzzy search

Не работает запрос, если добавить сюда fuzzy

Error Code: 1064. no such table ‘’

SELECT id, category_id, name, description, slug, article, brand_name, product_variant_id, reviews_count, rating, storage_quantity, images, highlight({}, ‘article, name, brand_name’) as highlight
FROM products
LEFT JOIN property ON property.product_variant_id = products.id
WHERE 1=1
AND MATCH(‘масло’)
GROUP BY id
ORDER BY weight() DESC
LIMIT 20
OFFSET 0
OPTION fuzzy=1, layouts=‘us, ua’, distance=3, field_weights=(name=5,article=5,description=3,oem_numbers=2,identifiers=1)
FACET brand_id DISTINCT id limit 5000
FACET property.value, property.property_id BY property.property_id, property.value LIMIT 5000;

Лучше завести issue на гитхабе. Вероятно, это баг.

1 Like