manticoresearch-javascript icon indicating copy to clipboard operation
manticoresearch-javascript copied to clipboard

UtilsApi sql issues with multiple queries

Open marz0405 opened this issue 11 months ago • 1 comments

When I run this query I get the results as expected. SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500; show meta; But when I run this SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500 OPTION fuzzy=1; show meta; I get an error saying "Invalid options in query string, make sure they are separated by commas" If I remove the show meta part and run the query it works but obviously I don't get the meta information. SELECT id, content_type, content_id, title, type FROM main WHERE MATCH('text') limit 500 OPTION fuzzy=1; Can anyone please tell me how to run a query with options and also meta information.

marz0405 avatar Mar 13 '25 05:03 marz0405

When I run this query I get the results as expected

Pls provide the code you use to run this query.

sanikolaev avatar Mar 14 '25 05:03 sanikolaev

The code used to run all the queries is var res = await utils.sql(<query here>);

marz0405 avatar Mar 15 '25 03:03 marz0405

It looks to be related not to the client, but to Manticore Buddy. I've opened another issue https://github.com/manticoresoftware/manticoresearch-buddy/issues/507 to fix this.

Nick-S-2018 avatar Mar 18 '25 04:03 Nick-S-2018

Hi, is there any update on this?

marz0405 avatar Apr 16 '25 03:04 marz0405

We're still working on the related issue which should fix this one too.

Nick-S-2018 avatar Apr 17 '25 14:04 Nick-S-2018

Fixed in https://github.com/manticoresoftware/manticoresearch-buddy/pull/539

Nick-S-2018 avatar Jun 12 '25 07:06 Nick-S-2018