manticoresearch icon indicating copy to clipboard operation
manticoresearch copied to clipboard

Secondary indexes for JSON attrs sometimes don't work with string arrays

Open glookka opened this issue 4 months ago • 0 comments

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

glookka avatar Oct 09 '24 18:10 glookka