UtilsApi sql issues with multiple queries
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.
When I run this query I get the results as expected
Pls provide the code you use to run this query.
The code used to run all the queries is
var res = await utils.sql(<query here>);
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.
Hi, is there any update on this?
We're still working on the related issue which should fix this one too.
Fixed in https://github.com/manticoresoftware/manticoresearch-buddy/pull/539