[ 
https://issues.apache.org/jira/browse/SOLR-4788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shawn Heisey updated SOLR-4788:
-------------------------------

    Attachment: entitytest.patch

>From what I can tell, there have never been any tests for the 
>[entityName].last_index_time properties, so I have no idea when this problem 
>started happening.

I tried to create a test for this in trunk, by duplicating 
TestSqlEntityProcessorDelta to a new class called 
TestSqlEntityProcessorDeltaEntity, and then changing all the 
dih.last_index_time values so they have the proper entity name, but the test 
fails, showing twice as many database calls at it expected.  Hopefully someone 
can tell me what I did wrong.

Attaching entitytest.patch.

                
> Multiple Entities DIH delta import: dataimporter.[entityName].last_index_time 
> is empty
> --------------------------------------------------------------------------------------
>
>                 Key: SOLR-4788
>                 URL: https://issues.apache.org/jira/browse/SOLR-4788
>             Project: Solr
>          Issue Type: Bug
>    Affects Versions: 4.2, 4.3
>         Environment: solr-spec
> 4.2.1.2013.03.26.08.26.55
> solr-impl
> 4.2.1 1461071 - mark - 2013-03-26 08:26:55
> lucene-spec
> 4.2.1
> lucene-impl
> 4.2.1 1461071 - mark - 2013-03-26 08:23:34
> OR
> solr-spec
> 4.3.0
> solr-impl
> 4.3.0 1477023 - simonw - 2013-04-29 15:10:12
> lucene-spec
> 4.3.0
> lucene-impl
> 4.3.0 1477023 - simonw - 2013-04-29 14:55:14
>            Reporter: chakming wong
>            Assignee: Shalin Shekhar Mangar
>         Attachments: entitytest.patch
>
>
> {code:title=conf/dataimport.properties|borderStyle=solid}entity1.last_index_time=2013-05-06
>  03\:02\:06
> last_index_time=2013-05-06 03\:05\:22
> entity2.last_index_time=2013-05-06 03\:03\:14
> entity3.last_index_time=2013-05-06 03\:05\:22
> {code}
> {code:title=conf/solrconfig.xml|borderStyle=solid}<?xml version="1.0" 
> encoding="UTF-8" ?>
> ...
>     <requestHandler name="/dataimport" 
> class="org.apache.solr.handler.dataimport.DataImportHandler">
>         <lst name="defaults">
>             <str name="config">dihconfig.xml</str>
>         </lst>
>     </requestHandler>
> ...
> {code}
> {code:title=conf/dihconfig.xml|borderStyle=solid}<?xml version="1.0" 
> encoding="UTF-8" ?>
> <dataConfig>
>     <dataSource name="source1"
>                 type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
>                 url="jdbc:mysql://*:*/*"
>                 user="*" password="*"/>
>     <document name="strings">
>         <entity name="entity1" pk="id" dataSource="source1"
>                 query="SELECT * FROM table_a"
>                 deltaQuery="SELECT table_a_id FROM table_b WHERE 
> last_modified > '${dataimporter.entity1.last_index_time}'"
>                 deltaImportQuery="SELECT * FROM table_a WHERE id = 
> '${dataimporter.entity1.id}'"
>                 transformer="TemplateTransformer">
>             <field> ...
>               ... 
>             ... </field>
>         </entity>
>         <entity name="entity2">
>               ... 
>               ...
>         </entity>
>         <entity name="entity3">
>               ... 
>               ...
>         </entity>
>     </document>
> </dataConfig>
> {code} 
> In above setup, *dataimporter.entity1.last_index_time* is *empty string* and 
> cause the sql query having error

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org

Reply via email to