barryhunter

Ok good point. Yes should be able to manage that.

Just testing this out, recoded this as SQL, which I find easier for testing ``` RT>CREATE TABLE products (title text, content text, contentid text); Query OK, 0 rows affected (0.006...

One 'workaround' is to specifally formulate the query to allow the HIGHLIGHT to work, eg allow it to match fields with any of the words. But then might need to...

Ah, just found `highlight_query` ``` import re highlight_query = re.sub(r"\s+","|",squery) resp = searchApi.search({"index":"products", "query":{"query_string":f"{squery}"},"highlight":{"fields":["content"], "before_match": '', "after_match": '', "limit": 0, "encoder": "default", "highlight_query":f"{highlight_query}"}}) ``` just using the re lib to...

manticore has 'fixed' this, but you need to enable the option for it work There is a per query option `OPTION not_terms_only_allowed=1` in the python API, guessing it something like...

Ah, what version of searchd are you using? It requires recent version. That been said perhaps can reproduce it (sorry, no idea how to get the python client installed) ```...

Thinking long term, would be great if this functionality could be 'abused' to power CREATE TABLE index2 SELECT id,title FROM index1 WHERE images> 1000 kind of query. ie create a...

Hmm, that could work. But seems like it would still mean transfering all the data out of searchd, then the PHP app, has to repackage all the data (and re...

Well there is `CREATE FUNCTION` https://manual.manticoresearch.com/Extensions/UDFs_and_Plugins/UDF/Creating_a_function :) ... if you meaning to be able to just run a user defined SQL script, that seems like a big ask, would need...

I've narrowed it down I think to one using the label in CONCAT (a field in the docstore) **AND** the TO_STRING() that causes the issue ``` RT.staging>SELECT CONCAT('test',TO_STRING(images)) AS test...