manticoresoftware / manticoresearch

Easy to use open source fast database for search | Good alternative to Elasticsearch now | Drop-in replacement for E in the ELK soon
https://manticoresearch.com
GNU General Public License v3.0
8.93k stars 495 forks source link

Queries using JSON SI return different result sets with ps=1 #2577

Closed glookka closed 1 week ago

glookka commented 1 week ago

Bug Description:

Queries using JSON SI return different result sets with pseudo_sharding=1 depending on the number of threads used.

These queries return different result sets:

select id, in(j.str,'str1','str2','str3') as check from t where check=1 order by id asc option threads=1;
select id, in(j.str,'str1','str2','str3') as check from t where check=1 order by id asc option threads=2;

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.

- [x] Implementation completed - [x] Tests developed - [x] Documentation updated - [x] Documentation reviewed - [x] [Changelog](https://docs.google.com/spreadsheets/d/1mz_3dRWKs86FjRF7EIZUziUDK_2Hvhd97G0pLpxo05s/edit?pli=1&gid=1102439133) updated
glookka commented 1 week ago

Fixed in cd1b93fcc56ad8e8e99c6c7a2f4c230e1bdaedce