You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Shawn Heisey (JIRA)" <ji...@apache.org> on 2018/04/20 13:50:00 UTC
[jira] [Resolved] (SOLR-12251) pk ids not sort when in deltaQuery
[ https://issues.apache.org/jira/browse/SOLR-12251?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shawn Heisey resolved SOLR-12251.
---------------------------------
Resolution: Invalid
Although it is entirely possible that this is a bug, it doesn't seem very likely. This issue tracker is not a support portal. This should have been brought up on the mailing list or the IRC channel, to confirm whether or not there's a bug before opening an issue.
http://lucene.apache.org/solr/community.html#mailing-lists-irc
There, we can give you steps for debugging the problem. If it turns out that there is a bug, then we can re-open this issue. Note that even if there is a bug, it will have to be confirmed in the latest version (currently 7.3.0). A problem like this is not severe enough to warrant a new 7.1.x version.
> pk ids not sort when in deltaQuery
> -----------------------------------
>
> Key: SOLR-12251
> URL: https://issues.apache.org/jira/browse/SOLR-12251
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: contrib - DataImportHandler
> Affects Versions: 7.1
> Environment: windows10
> Solr7.1
> JDK8
>
> Reporter: wzhonggo
> Priority: Major
>
> I use solr and mysql for search.
>
> {code:xml}
> // 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 "
> {code}
>
> 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.
>
>
>
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org