Error Code: 1064. no such table ” the query doesn't work after adding fuzzy

[Playys228]

Bug Description:

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;

query doesn't work after adding fuzzy

Error Code: 1064. no such table ‘’

describe products;

id	bigint	
name	text	indexed stored
description	text	indexed stored
oem_numbers	text	indexed stored
identifiers	text	indexed stored
article	text	indexed stored
slug	string	
short_description	string	
category_id	uint	
brand_name	string	
brand_id	bigint	
sku	string	
pc_car_ids	mva	
price	bigint	
compare_price	bigint	
product_variant_id	bigint	
reviews_count	uint	
rating	float	
storage_quantity	json	
offer_slug	json	
properties	json	
images	json	

describe property;

id	bigint	
product_variant_id	uint	
category_id	uint	
property_id	uint	
value	string	
multi_value	json	

Manticore Search Version:

Manticore 13.11.1 134b36912@25091317 (columnar 8.0.3 6d8ff91@25091005) (secondary 8.0.3 6d8ff91@25091005) (knn 8.0.3 6d8ff91@25091005) (embeddings 1.0.1)

Operating System Version:

Ubuntu 24.04.2 LTS

Have you tried the latest development version?

Yes

Internal Checklist:

^{To be completed by the assignee. Check off tasks that have been completed or are not applicable.}

Details

• Implementation completed
• Tests developed
• Documentation updated
• Documentation reviewed

[donhardman]

Fixed incorrect quotes and recovered table structure for MRE:

DROP TABLE IF EXISTS products;

CREATE TABLE products (
    id bigint,
    name text,
    description text,
    oem_numbers text,
    identifiers text,
    article text,
    slug string,
    short_description string,
    category_id uint,
    brand_name string,
    brand_id bigint,
    sku string,
    pc_car_ids multi,
    price bigint,
    compare_price bigint,
    product_variant_id bigint,
    reviews_count uint,
    rating float,
    storage_quantity json,
    offer_slug json,
    properties json,
    images json
);
DROP TABLE IF EXISTS property;

CREATE TABLE property (
    id bigint,
    product_variant_id uint,
    category_id uint,
    property_id uint,
    value string,
    multi_value json
);

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;

I'm unable to reproduce it. Maybe what you see is due to incorrect quotes? What version of Manticore are you using? I tried to run this query on 13.11.1-25091317-134b36912 and have no errors.

What i noticed you have ‘ instead of '

[donhardman]

I reproduced the issue and am looking into it.

[sanikolaev]

manticoresoftware/manticoresearch#3839 is merged

[donhardman]

The issue should be fixed in the dev version! Please give it a try. If there are any problems, feel free to reopen. For now, I'm closing the issue.

[github-actions]

Thanks for the update! However, the internal checklist is not yet complete. A Manticore team member will close this issue once everything is checked off. 🛠️