Dataimporthandler sql query don't run

[Jens Mayer <mj...@yahoo.com.INVALID>]

Hello everyone,
I need to run the following query to import my index from a H2 database:
<entity name="StreetInfo"  query="SELECT si.*, zi.inhabitants            FROM StreetInfo si            left join (SELECT city, city_appendix, max(inhabitants) as inhabitants            FROM zipinfo            group by city, city_appendix) zi            on zi.city = si.city            and zi.city_appendix = si.city_appendix            where house_no = '';"></entity>
but if I start to full-import nothing happens. The last information from my log file is the following:
[25.09.2015 20:06:24.418 INFO  commitScheduler-11-thread-1 o.a.s.u.DirectUpdateHandler2.commit:548] start commit{,optimize=false,openSearcher=false,waitSearcher=true,expungeDeletes=false,softCommit=false,prepareCommit=false}[25.09.2015 20:06:24.418 INFO  commitScheduler-11-thread-1 o.a.s.u.DirectUpdateHandler2.commit:588] No uncommitted changes. Skipping IW.commit.[25.09.2015 20:06:24.419 INFO  commitScheduler-11-thread-1 o.a.s.u.DirectUpdateHandler2.commit:637] end_commit_flush
If I try to run the SQL into the H2 directly I'll receive the expected results.The strange thing is that if I run the following query everything goes right and my data will be indexed. But I'm confused why the first statement fails and the second one succeed:
<entity name="StreetInfo"  query="SELECT StreetInfo.*, ZipInfo.inhabitants  FROM StreetInfo  left join ZipInfo  on ZipInfo.zip = StreetInfo.zip  and ZipInfo.city = StreetInfo.city  and ZipInfo.city_appendix = StreetInfo.city_appendix  where house_no = '';"></entity>
Have someone of you an Idea why the first statement fails?
Thanks for your help