Return-Path: 
 <oak-dev-return-545-apmail-jackrabbit-oak-dev-archive=jackrabbit.apache.org@jackrabbit.apache.org>
X-Original-To: apmail-jackrabbit-oak-dev-archive@minotaur.apache.org
Delivered-To: apmail-jackrabbit-oak-dev-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 10B119D0A
	for <apmail-jackrabbit-oak-dev-archive@minotaur.apache.org>;
 Tue,  3 Apr 2012 11:40:40 +0000 (UTC)
Received: (qmail 97337 invoked by uid 500); 3 Apr 2012 11:40:40 -0000
Delivered-To: apmail-jackrabbit-oak-dev-archive@jackrabbit.apache.org
Received: (qmail 97307 invoked by uid 500); 3 Apr 2012 11:40:39 -0000
Mailing-List: contact oak-dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:oak-dev-help@jackrabbit.apache.org>
List-Unsubscribe: <mailto:oak-dev-unsubscribe@jackrabbit.apache.org>
List-Post: <mailto:oak-dev@jackrabbit.apache.org>
List-Id: <oak-dev.jackrabbit.apache.org>
Reply-To: oak-dev@jackrabbit.apache.org
Delivered-To: mailing list oak-dev@jackrabbit.apache.org
Received: (qmail 97299 invoked by uid 99); 3 Apr 2012 11:40:39 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2012 11:40:39 +0000
X-ASF-Spam-Status: No, hits=-0.7 required=5.0
	tests=RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of jukka.zitting@gmail.com
 designates 209.85.212.178 as permitted sender)
Received: from [209.85.212.178] (HELO mail-wi0-f178.google.com)
 (209.85.212.178)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2012 11:40:32 +0000
Received: by wibhq7 with SMTP id hq7so3628464wib.1
        for <oak-dev@jackrabbit.apache.org>;
 Tue, 03 Apr 2012 04:40:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        bh=qBKuGbTJmQOxJHsQ6rQcmXoUKZLakegGWvfeyY02CM8=;
        b=pvuf69Zxqydnn7Mx550MwQ1IBoTlcHUKV/dRA9q5jVqMf+9iduala4eizt1Iu4vrBf
         FsNh+C5lq7dXx7eT7J2jmKaK4d3SZCmE6z6tD7GsO6qrKtdSob3zY+Tel175ng22cNMr
         4h1eFhso7B99SZdJdeHXkrqbcaVHEI0OnLJPB2Uh/nXnzYmgaSeLENicNI8TPJ2jLzCl
         dLivlusTOIdytWs0xupmy38Tk7BRTE6dQ0iVXLS5WbFUzflaQCa5i8iUQQl/dPtEqWdR
         CUVCTeuVoTLzr1AKfoscMZdaQ3WK8myFy0WLDN8oH4gBKn89xY4gb3NYVE96I9hYQ9CT
         KAbw==
Received: by 10.180.101.8 with SMTP id fc8mr35662153wib.12.1333453212250; Tue,
 03 Apr 2012 04:40:12 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.180.84.199 with HTTP; Tue, 3 Apr 2012 04:39:52 -0700 (PDT)
In-Reply-To: <CBA0A047.29684%mueller@adobe.com>
References: <CBA0A047.29684%mueller@adobe.com>
From: Jukka Zitting <jukka.zitting@gmail.com>
Date: Tue, 3 Apr 2012 13:39:52 +0200
Message-ID: 
 <CAOFYJNYbZzOu8wnWtbFWeb-rQosNo1jvZKEL+2aFvALSxY+z=A@mail.gmail.com>
Subject: Re: Converting XPath to SQL-2
To: oak-dev@jackrabbit.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Hi,

On Tue, Apr 3, 2012 at 12:40 PM, Thomas Mueller <mueller@adobe.com> wrote:
> How would the SQL-2 query look like to match the XPath query?

I'd just make it:

    select * from [nt:base] where [test]='hello'

The //* expression matches all nodes, so no need to map it to any
specific constraint.

BR,

Jukka Zitting