manticoresearch
manticoresearch copied to clipboard
Secondary indexes for JSON attrs sometimes don't work with string arrays
Bug Description:
Secondary indexes for JSON attributes sometimes don't return proper results with string arrays like
{"names":["data1", "data2", "data3"]}
and queries like
select *, in(j['names'], 'data1') as a from test WHERE a=1;
The issue happens when filters are transformed, but SI iterators are not spawned (e.g. when the index is too small). As SI are not used, transformed filter doesn't process string arrays correctly.
Manticore Search Version:
6.3.1
Operating System Version:
Any
Have you tried the latest development version?
Yes
Internal Checklist:
To be completed by the assignee. Check off tasks that have been completed or are not applicable.
- [ ] Implementation completed
- [ ] Tests developed
- [ ] Documentation updated
- [ ] Documentation reviewed
- [ ] Changelog updated