Return-Path: 
 <jena-users-return-316-apmail-incubator-jena-users-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-jena-users-archive@minotaur.apache.org
Received: (qmail 19258 invoked from network); 2 Feb 2011 19:17:32 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 2 Feb 2011 19:17:32 -0000
Received: (qmail 86132 invoked by uid 500); 2 Feb 2011 19:17:32 -0000
Delivered-To: apmail-incubator-jena-users-archive@incubator.apache.org
Received: (qmail 86116 invoked by uid 500); 2 Feb 2011 19:17:32 -0000
Mailing-List: contact jena-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:jena-users-help@incubator.apache.org>
List-Unsubscribe: <mailto:jena-users-unsubscribe@incubator.apache.org>
List-Post: <mailto:jena-users@incubator.apache.org>
List-Id: <jena-users.incubator.apache.org>
Reply-To: jena-users@incubator.apache.org
Delivered-To: mailing list jena-users@incubator.apache.org
Received: (qmail 86102 invoked by uid 99); 2 Feb 2011 19:17:32 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Feb 2011 19:17:32 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [83.222.232.117] (HELO echo.justhostme.co.uk) (83.222.232.117)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Feb 2011 19:17:24 +0000
Received: from cpc2-aztw23-2-0-cust840.aztw.cable.virginmedia.com
 ([94.171.235.73] helo=[192.168.1.10])
	by echo.justhostme.co.uk with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69)
	(envelope-from <andy.seaborne@epimorphics.com>)
	id 1PkiCQ-0006zw-Pm
	for jena-users@incubator.apache.org; Wed, 02 Feb 2011 19:17:07 +0000
Message-ID: <4D49ADAC.6030808@epimorphics.com>
Date: Wed, 02 Feb 2011 19:17:00 +0000
From: Andy Seaborne <andy.seaborne@epimorphics.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
 rv:1.9.2.13) Gecko/20101208 Thunderbird/3.1.7
MIME-Version: 1.0
To: jena-users@incubator.apache.org
Subject: Re: That NPE of mine that Andy fixed
References: <AANLkTinjQBB+jWzd6khn2LRa+0BeRLgDPfAi1COkQwXm@mail.gmail.com>
In-Reply-To: <AANLkTinjQBB+jWzd6khn2LRa+0BeRLgDPfAi1COkQwXm@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-AntiAbuse: This header was added to track abuse,
 please include it with any abuse report
X-AntiAbuse: Primary Hostname - echo.justhostme.co.uk
X-AntiAbuse: Original Domain - incubator.apache.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - epimorphics.com
X-Virus-Checked: Checked by ClamAV on apache.org



On 02/02/11 19:02, Benson Margulies wrote:
> Andy,
>
> I've become convinced that I should really have optionals rather than
> unions in the query in question (or duplicate some of the first clause
> into the two others). Can you shed any light on why it went 'splat'
> and if there's a way around it?
>
> -benson

The optimizer was messing up on nested IN expressions.

In several different ways.

Using the SNAPSHOTs should fix it - your example query ran quickly with 
the test data.

http://openjena.org/repo-dev/com/hp/hpl/jena/

then look in arq/2.8.8-SNAPSHOT/arq-2.8.8-.....zip
and
tdb/0.8.10-SNAPSHOT/tdb-0.8.10-.....zip

or with maven:

   <repositories>
     <repository>
       <id>repo-jena</id>
       <name>Jena Maven - Repository</name>
       <layout>default</layout>
       <url>http://openjena.org/repo</url>
       <snapshots>
         <enabled>false</enabled>
       </snapshots>
     </repository>

     <repository>
       <id>repo-jena-dev</id>
       <name>Jena Maven - Development Repository</name>
       <layout>default</layout>
       <url>http://openjena.org/repo-dev</url>
       <snapshots>
         <enabled>true</enabled>
       </snapshots>
     </repository>
   </repositories>

	Andy