Return-Path: 
 <dev-return-60097-apmail-lucene-dev-archive=lucene.apache.org@lucene.apache.org>
Delivered-To: apmail-lucene-dev-archive@www.apache.org
Received: (qmail 84121 invoked from network); 25 Nov 2010 14:05:39 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 25 Nov 2010 14:05:39 -0000
Received: (qmail 62447 invoked by uid 500); 25 Nov 2010 14:05:37 -0000
Delivered-To: apmail-lucene-dev-archive@lucene.apache.org
Received: (qmail 62286 invoked by uid 500); 25 Nov 2010 14:05:37 -0000
Mailing-List: contact dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@lucene.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@lucene.apache.org>
List-Post: <mailto:dev@lucene.apache.org>
List-Id: <dev.lucene.apache.org>
Reply-To: dev@lucene.apache.org
Delivered-To: mailing list dev@lucene.apache.org
Received: (qmail 62276 invoked by uid 99); 25 Nov 2010 14:05:36 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Nov 2010 14:05:36 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Nov 2010 14:05:35 +0000
Received: from thor (localhost [127.0.0.1])
	by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id oAPE5FM5028804
	for <dev@lucene.apache.org>; Thu, 25 Nov 2010 14:05:15 GMT
Message-ID: <12155804.312311290693915287.JavaMail.jira@thor>
Date: Thu, 25 Nov 2010 09:05:15 -0500 (EST)
From: "Koji Sekiguchi (JIRA)" <jira@apache.org>
To: dev@lucene.apache.org
Subject: [jira] Updated: (SOLR-2252) when child entity is the root in nested
 entities, delta-import doesn't work
In-Reply-To: <30843935.311771290692474333.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


     [ 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

> 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
>
>
> 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-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org