lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fuad Efendi" <f...@efendi.ca>
Subject RE: Simple problem with a nested entity and it's SQL
Date Wed, 28 Oct 2009 18:49:18 GMT

Why can't we use single entity with single SELECT ... LEFT OUTER JOIN ...?


> -----Original Message-----
> From: Jonathan Hendler [mailto:jonathan.hendler@gmail.com]
> Sent: October-28-09 1:33 PM
> To: solr-user@lucene.apache.org
> Subject: Simple problem with a nested entity and it's SQL
> 
> I have a nested entity on a jdbc data import handler that is causing
> an SQL error because the second key is either NULL (blank when
> generating the sql) or non-zero INT.
> The query is in the following form:
> 
> <document name="content">
>                  <entity name="bl_lessonfiles"
> transformer="TemplateTransformer" query="SELECT * FROM table1 ">
>                        ...
> 			<entity name="user_index" query="SELECT *  FROM
table2
> WHERE  id = $
> {table1.somethin_like_a_foreign_key} ">
>                              ....
>                          </entity>
>                  </entity>
>          </document>
> 
> Is the only way to avoid this to modify the source DB schema to be NOT
> NULL so it always returns at least a 0?
> 
> - Jonathan



Mime
View raw message