Return-Path: X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7377E11D54 for ; Tue, 8 Apr 2014 22:01:34 +0000 (UTC) Received: (qmail 74683 invoked by uid 500); 8 Apr 2014 22:01:17 -0000 Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org Received: (qmail 74599 invoked by uid 500); 8 Apr 2014 22:01:17 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 74574 invoked by uid 99); 8 Apr 2014 22:01:16 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Apr 2014 22:01:16 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of solr@elyograg.org designates 166.70.79.219 as permitted sender) Received: from [166.70.79.219] (HELO frodo.elyograg.org) (166.70.79.219) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 08 Apr 2014 22:01:10 +0000 Received: from localhost (localhost [127.0.0.1]) by frodo.elyograg.org (Postfix) with ESMTP id D236E91A8 for ; Tue, 8 Apr 2014 16:00:46 -0600 (MDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=elyograg.org; h= content-transfer-encoding:content-type:content-type:in-reply-to :references:subject:subject:mime-version:user-agent:from:from :date:date:message-id:received:received; s=mail; t=1396994446; bh=jQSaxRclhcjLo5sJo7YGbR/4A8/YGxu/yKQ4dgVhRwY=; b=YYWgM1jhES63 PMWm421E3T+UE07o1XpkTT/tnD1GTXwI8BehU08qDxAr2lxN+Qzca07MqNq1MSUz NlYBIPICj8NoKO+X42DB/rHDV/Q8tYkVndgOpKd/Z2CqCXIh60BPLT6df/91gKW+ jIb06cJSuJk6zkVhMSrbJ16vyAG4Q9U= X-Virus-Scanned: Debian amavisd-new at frodo.elyograg.org Received: from frodo.elyograg.org ([127.0.0.1]) by localhost (frodo.elyograg.org [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id OOdlscaIy6xS for ; Tue, 8 Apr 2014 16:00:46 -0600 (MDT) Received: from [10.2.0.182] (client175.mainstreamdata.com [209.63.42.175]) (using TLSv1 with cipher DHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: elyograg@elyograg.org) by frodo.elyograg.org (Postfix) with ESMTPSA id F334591A4 for ; Tue, 8 Apr 2014 16:00:45 -0600 (MDT) Message-ID: <5344718C.9080201@elyograg.org> Date: Tue, 08 Apr 2014 16:00:44 -0600 From: Shawn Heisey User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.4.0 MIME-Version: 1.0 To: solr-user@lucene.apache.org Subject: Re: Range query and join, oarse exception when parens are added References: <27459721.5517.1396986511096.JavaMail.molsen@molsen-jv6cxh1> In-Reply-To: <27459721.5517.1396986511096.JavaMail.molsen@molsen-jv6cxh1> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org On 4/8/2014 1:48 PM, Mark Olsen wrote: > Solr version 4.2.1 > > I'm having an issue using a "join" query with a range query, but only when the query is wrapped in parens. > > This query works: > > {!join from=member_profile_doc_id to=id}language_proficiency_id_number:[30 TO 50] > > However this query does not (just wrapping with parens): > > ({!join from=member_profile_doc_id to=id}language_proficiency_id_number:[30 TO 50]) The {!join...} part of that is a localParam. It must precede the entire query. If you want to add parens, here's how you would need to do it: {!join from=member_profile_doc_id to=id}(language_proficiency_id_number:[30 TO 50]) With the left parenthesis where you placed it, the localParam is considered part of the query itself. It becomes incorrect Solr syntax at that point. Thanks, Shawn