From users-return-17163-apmail-jackrabbit-users-archive=jackrabbit.apache.org@jackrabbit.apache.org Thu Mar 03 10:37:37 2011 Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 51872 invoked from network); 3 Mar 2011 10:37:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Mar 2011 10:37:37 -0000 Received: (qmail 42329 invoked by uid 500); 3 Mar 2011 10:37:34 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 42304 invoked by uid 500); 3 Mar 2011 10:37:34 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 42295 invoked by uid 99); 3 Mar 2011 10:37:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Mar 2011 10:37:34 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jzitting@adobe.com designates 64.18.1.27 as permitted sender) Received: from [64.18.1.27] (HELO exprod6og111.obsmtp.com) (64.18.1.27) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 03 Mar 2011 10:37:27 +0000 Received: from source ([192.150.11.134]) by exprod6ob111.postini.com ([64.18.5.12]) with SMTP ID DSNKTW9vUcGxx0iSC6qOzd/ufoc7LtoK0es2@postini.com; Thu, 03 Mar 2011 02:37:06 PST Received: from inner-relay-1.corp.adobe.com ([153.32.1.51]) by outbound-smtp-1.corp.adobe.com (8.12.10/8.12.10) with ESMTP id p23AaOKG015708 for ; Thu, 3 Mar 2011 02:36:24 -0800 (PST) Received: from nahub01.corp.adobe.com (nahub01.corp.adobe.com [10.8.189.97]) by inner-relay-1.corp.adobe.com (8.12.10/8.12.10) with ESMTP id p23Ab4Pa025665 for ; Thu, 3 Mar 2011 02:37:05 -0800 (PST) Received: from eurhub01.eur.adobe.com (10.128.4.30) by nahub01.corp.adobe.com (10.8.189.97) with Microsoft SMTP Server (TLS) id 8.3.137.0; Thu, 3 Mar 2011 02:37:05 -0800 Received: from jzitting.adobe.com (10.131.197.63) by europemail.eur.adobe.com (10.128.4.111) with Microsoft SMTP Server (TLS) id 8.3.137.0; Thu, 3 Mar 2011 10:37:03 +0000 Message-ID: <4D6F6F4B.1000809@adobe.com> Date: Thu, 3 Mar 2011 11:36:59 +0100 From: Jukka Zitting Organization: Adobe User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.13) Gecko/20101209 Fedora/3.1.7-0.35.b3pre.fc14 Lightning/1.0b3pre Thunderbird/3.1.7 MIME-Version: 1.0 To: "users@jackrabbit.apache.org" Subject: Re: sql query issue with 2.2.4 References: In-Reply-To: Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi, On 02/17/2011 10:04 PM, Alejandro Gomez wrote: > javax.jcr.UnsupportedRepositoryOperationException: Unable to split a > constraint that references both sides of a join: > ((ISDESCENDANTNODE(projects, [/repository/projects])) AND > (eventclassassociations.active = CAST('true' AS BOOLEAN))) OR > (ISDESCENDANTNODE(projects, [/repository/template])) This is a side-effect of the join query optimization work we did for 2.2. The new join engine has trouble handling OR constraints that reference both sides of a join. The best workaround for now is to split your query into two parts around the OR constraints, and then merge the results in client code. See JCR-2852 [1] for more background on this issue. I'm hoping to have a solution ready in time for Jackrabbit 2.3. [1] https://issues.apache.org/jira/browse/JCR-2852 -- Jukka Zitting