wrong result for filter by id

[tomatolog]

Bug Description:

The query with the not equal filter by id returns different results depends on the index size and the workers count that process the query select * from idx where id <> 60

the wrong query result

select id from test where id <> 60 order by id desc limit 5 option threads=1 /*+ DocidIndex(id) */;
	id
	60

however if there are multiple workers thread processing the query result is good

select id from test where id <> 60 order by id desc limit 5 option threads=5 /*+ DocidIndex(id) */;
	id
	64
	63
	62
	61
	59

Manticore Search Version:

9.5.5

Operating System Version:

linux

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

[github-actions]

Thanks for the update! However, the internal checklist is not yet complete. A Manticore team member will close this issue once everything is checked off. 🛠️

[tomatolog]

fixed at e2589e8 that lookup iterator will not create for filter by id if the has not equal part to value(s);

Test cases also added into ubertest 374