manticoresoftware / manticoresoftware/manticoresearch
GitHub#60 ⁃ Facet aliasing conflict
Open
@tomatolog is already working on this.
Since Dec 12, 2018.
bug
To Do
- Dominant language
- C++
- Stars
- 12k
- Forks
- 642
- Avg merge
- 3d 12h
- Merged PRs (30d)
- 47
Description
id | name | cities(mva) | work_city_id(int)
MySQL [(none)]> SELECT * FROM rt_index WHERE work_city_id > 0 LIMIT 0, 45 FACET work_city_id AS cities ORDER BY COUNT(*) DESC LIMIT 0, 999;
ERROR 1064 (42000): index rt_index: alias ‘cities’ must be unique (conflicts with another alias)
When I replace * with columns concatenated (SELECT id, name, cities, work_city_id FROM rt_index WHERE work_city_id > 0 LIMIT 0, 45 FACET work_city_id AS cities ORDER BY COUNT(*) DESC LIMIT 0, 999;) , all good.
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.