[SOLR-12251] pk ids not sort when in deltaQuery

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 7.1
• Component/s: contrib - DataImportHandler

Environment

windows10

Solr7.1

JDK8

 

• Assignee: Unassigned
• Reporter: wzhonggo
• Created: 20/Apr/18 09:04
• Updated: 29/Aug/20 20:37
• Resolved: 29/Aug/20 20:37

Description

I use solr and mysql for search. 

 

// data-config.xml
query="select * from score order by create_date asc"  
deltaImportQuery="select * from score where id='${dih.delta.id}'" 
deltaQuery="selectid from score where update_date > '${dataimporter.last_index_time}' order by create_date asc "

 

 Mysql has three rows data in score table

 

id	name	score	create_date	update_date
UUID1	user1	60	2018-04-10	2018-04-10
UUID2	user1	70	2018-04-11	2018-04-11
UUID3	user1	80	2018-04-12	2018-04-12

The expected results In solr doc

Name	Score	CreateDate	UpdateDate
user1	80	2018-04-12	2018-04-12

 

Use full import it will correct , but use delta import will wrong.

In the org.apache.solr.handler.dataimport.DocBuilder class ,  return not LinkHashSet in 

collectDelta method. 

 

Thanks.

 

 

 

 

Issue Links

• duplicates: SOLR-7952 Change DeltaImport from HashSet to LinkedHashSet.
• is superceded by: SOLR-14783 Remove DIH from 9.0