Filter by reset
- Everywhere
7706 - Issues
406 - Pull Requests
50 - Comments
7250
GROUP N BY X does not support JSON attributes
Manticore Search version: 3.2.2 OS…Description of the issue: SphinxQL GROUP N BY does not work…from it to perform a GROUP N BY [json attr]…WHERE MATCH('cloud') GROUP 3 BY site WITHIN GROUP ORDER BY id…sorting mode (match-sort=5, group=1, group-sort=5)
…oqsindex where entity = 1258280944859004929 group by jsonfields.1258280945043554306S, jsonfields.1258280945060331522S…there: a) searchd log, b) searchd binary, c) searchd symbols. Look into…state = /var/lib/manticore/state.sql listen = 9312 listen = 9306:…
bug
Group By on JSON Data Causes Primary To Crash
…making the call crashes when grouping the results from the…is_searchable=1 GROUP BY reward_group_id WITHIN GROUP ORDER BY…61983 AND is_searchable=1 GROUP BY category_facets.catalog_…there: a) searchd log, b) searchd binary, c) searchd symbols. Look into…
waiting
GROUP_CONCAT order values by WITHIN GROUP ORDER BY clause
…does not respect WITHIN GROUP ORDER BY clause, and…[(none)]> SELECT id, name, GROUP_CONCAT(vals.val) FROM items….val ASC; +------+-------+------------------------+ | id | name | group_concat(vals.val) | +------+-------+------------------------+ | 1 |…
COUNT(*) wrong value with GROUP N BY row WITHIN GROUP ORDER BY
…kind} and type = ${type} GROUP 2 BY type, kind WITHIN…uroot -S /var/run/manticore/searchd.sock -sse "${query1}"` response2…uroot -S /var/run/manticore/searchd.sock -sse "${query2}"` response1Compare…uroot -S /var/run/manticore/searchd.sock -e "${query1}" echo…
TO_STRING fails with WITHIN GROUP ORDER BY
…_STRING clause when using GROUP and WITHIN GROUP ORDER BY clauses. When…is not respecting the WITHIN GROUP ORDER BY clause, and instead…the lowest id of the group. When GROUP_CONCAT is combined with…set (0.000 sec) Manticore Search Version: 10.1.0 Operating…
bug
…основном запросе используется группировка (SELECT ... GROUP BY ... FACET ...) то фасеты дают…_title, title_year, imdb_score, GROUP_CONCAT(id) as ids from…| | 2003 | 1 | | 2010 | 1 | +------------+----------+ Manticore Search Version: Manticore 6.3.6…
enhancement
group N by column1,column2,column3
…the (group N by column1, column2 … ) statement, manticore search speed is…, request_type from testplain group 2 by content_type,…54.638s I tried running (group by cloumn1,column2…) select…, request_type from testplain group by content_type, protocol,request…
Fail in case of an attempt to group by a stored field
It's currently possible to group by text with no warning…doesn't make sense to group by a stored field as…sec) mysql> select * from t group by g; +---------------------+------+------+ | id | f | g…
Improvement of group_concat() aggregate function
Hello. I kindly ask you to review the possibility of improvement of the group_concat() aggregate function similar to abilities in MySQL: GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ')
enhancement
GROUP BY and FACET Inconsistent behavior with JSON array
…select groupby(), count(*) from t group by j facet j; --------------…-------------- select groupby(), count(*) from t group by j facet j -------------- +-----------------------+----------+ |…results in 0ms --- Manticore Search Version: Manticore 6.3.7…
bugest::size_M
…= '"' + JOIN(token_groups, '" "') + '"' WHERE token_groups = FOR each token_position…SQL Output: Original: MATCH('search phrase') Transformed: MATCH('(search|seach|serch)^50…original query as fallback Performance Considerations Caching Strategy: Table…
…sphinx, state query, command search thd 1 (work_9),…sphinx, state query, command search thd 2 (work_10),…sphinx, state query, command search --- Totally 5 threads, and…/../src/searchd.cpp:5559 ??:? /builds/manticoresearch/dev/build/../src/searchd.cpp:6051…
bugwaiting
query log in sphinxql format stores incorrectly OPTION expr=...
Describe the bug when i run via sphinxl this command: SELECT * FROM idx0 OPTION ranker=expr('1 2'); it's logged incorrectly - includes unnecessary phrase ranker=exp, : /* Tue Jul 20 07:19:13.389 2021 conn 2 real 0.000 wall 0.000 found 1 */ SELECT * FROM …
bug
weird group by results on columnar MVA with multple group by columns without using groupby()
…tags,price, count(*) from products group by tags,price; +----------+-----------+----------+ | tags | price…'t be used in multiple group-by' error. Maybe the query…not even be allowed? Manticore Search Version: 7.4.6 b2ff82920…
bug
If data is being written, execute group by to obtain duplicate data
…,user_id from test_table group by biz_code,user_id…a few minutes ago. Manticore Search Version: 9.3.2 Operating…
bug
The documentation about SQL expressions is far from complete
…is often unspecified. Some SQL queries are rejected by…Reproducible examples, mostly with GROUP BY: create table junks(grpid…-- OK select grpid from junks group by grpid; -- ERROR 1…-- KO: attribute not related to GROUP BY -- workaround (trick) -- For…
I'm trying to connect to Manticore Search via foreign table in PostgreSQL and when executing a query I get the error: [HV00L] ERROR: failed to prepare the MySQL query: unknown command (code=22) What I was doing: Created a table in Manticore: create table …
enhancement
Total is always zero in select via /sql endpoint
…An /sql endpoint always return 0 in "…/manticoresearch/blob/81f1893e61c2f0978141b4f6649bc4c97bf4c570/src/searchdhttp.cpp#L798 But Ok function seem…
auth: permissions management in RT Mode / SphinxQL commands
Proposal: Implement permissions management in RT Mode using SphinxQL commands. And store authentication data in system tables system.auth_users and system.auth_permissions . SphinxQL Commands: CREATE USER DROP USER GRANT REVOKE SET PASSWORD Add these into …
buddy_candidate