我试图使用带有GROUP_BY选项思考Sphinx搜索根据文档http://pat.github.io/thinking-sphinx/searching.html#grouping :
Point.search('point', group_by: :tour_id)
但是这个代码生成不正确的狮身人面像查询
SELECT *, groupby() as sphinx_internal_group, count(*) as sphinx_internal_count
FROM `point_core`, `point_delta`
WHERE MATCH('point') AND `sphinx_deleted` = 0
GROUP BY `tour_id` LIMIT 0, 20
这引起了错误:
ThinkingSphinx::ParseError: index point_core,point_delta:
parse error: unknown identifier 'groupby' (not an attribute, not a function) -
SELECT *, groupby() as sphinx_internal_group, count(*) as sphinx_internal_count
FROM `point_core`, `point_delta` WHERE MATCH('point') AND `sphinx_deleted` = 0
GROUP BY `tour_id` LIMIT 0, 20; SHOW META
我使用的思维 - 狮身人面像-3.1.1。
什么是GROUP_BY选项用法的正确方法是什么?