[
https://issues.apache.org/jira/browse/SOLR-2252?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Koji Sekiguchi updated SOLR-2252:
---------------------------------
Attachment: SOLR-2252.patch
I added tests. All tests pass.
I'll commit in a few days if no one objects.
> when child entity is the root in nested entities, delta-import doesn't work
> ---------------------------------------------------------------------------
>
> Key: SOLR-2252
> URL: https://issues.apache.org/jira/browse/SOLR-2252
> Project: Solr
> Issue Type: Bug
> Components: contrib - DataImportHandler
> Affects Versions: 1.4.1
> Reporter: Koji Sekiguchi
> Priority: Minor
> Fix For: 3.1, 4.0
>
> Attachments: SOLR-2252.patch, SOLR-2252.patch
>
>
> sample data-config.xml:
> {code}
> <dataConfig>
> <dataSource driver="org.postgresql.Driver"
> url="jdbc:postgresql://localhost/exercise" user="solr"
> password="solr" />
> <document>
> <entity name="team" query="select * from team" pk="team_id"
> rootEntity="false"
> deltaQuery="select team_id from team where last_modified >
> '${dih.last_index_time}'"
> deltaImportQuery="select * from team where
> team_id='${dih.delta.team_id}'">
> <field column="team_name" name="team"/>
> <field column="team_yard" name="yard"/>
> <entity name="team_athlete" pk="team_id" rootEntity="false"
> query="select athlete_id from team_athlete where
> team_athlete.team_id=${team.team_id}"
> deltaQuery="select distinct team_id from team_athlete where
> last_modified > '${dih.last_index_time}'"
> deltaImportQuery="select athlete_id from team_athlete where
> team_athlete.team_id=${dih.delta.team_id}"
> parentDeltaQuery="select team_id from team where
> team_id=${team_athlete.team_id}">
> <entity name="athlete" pk="athlete_id" rootEntity="true"
> query="select athlete_name from athlete where
> athlete_delflag='N' AND athlete.athlete_id=${team_athlete.athlete_id}"
> deletedPkQuery="select athlete_id from athlete where
> athlete_delflag='Y' AND last_modified > '${dih.last_index_time}'"
> deltaQuery="select athlete_id from athlete where
> athlete_delflag='N' AND last_modified > '${dih.last_index_time}'"
> deltaImportQuery="select athlete_name from athlete where
> athlete_delflag='N' AND athlete.athlete_id=${dih.delta.athlete_id}"
> parentDeltaQuery="select team_id from team_athlete where
> athlete_id=${athlete.athlete_id}">
> <field column="athlete_name" name="name"/>
> </entity>
> </entity>
> </entity>
> </document>
> </dataConfig>
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
