Return-Path: X-Original-To: apmail-subversion-commits-archive@minotaur.apache.org Delivered-To: apmail-subversion-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 19051171DE for ; Fri, 6 Feb 2015 13:15:27 +0000 (UTC) Received: (qmail 97959 invoked by uid 500); 6 Feb 2015 13:15:27 -0000 Delivered-To: apmail-subversion-commits-archive@subversion.apache.org Received: (qmail 97929 invoked by uid 500); 6 Feb 2015 13:15:27 -0000 Mailing-List: contact commits-help@subversion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@subversion.apache.org Delivered-To: mailing list commits@subversion.apache.org Received: (qmail 97917 invoked by uid 99); 6 Feb 2015 13:15:27 -0000 Received: from eris.apache.org (HELO hades.apache.org) (140.211.11.105) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Feb 2015 13:15:27 +0000 Received: from hades.apache.org (localhost [127.0.0.1]) by hades.apache.org (ASF Mail Server at hades.apache.org) with ESMTP id C6D5FAC006C; Fri, 6 Feb 2015 13:15:26 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1657798 - /subversion/trunk/subversion/libsvn_wc/wc-queries.sql Date: Fri, 06 Feb 2015 13:15:26 -0000 To: commits@subversion.apache.org From: rhuijben@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20150206131526.C6D5FAC006C@hades.apache.org> Author: rhuijben Date: Fri Feb 6 13:15:25 2015 New Revision: 1657798 URL: http://svn.apache.org/r1657798 Log: * subversion/libsvn_wc/wc-queries.sql (STMT_SELECT_OP_DEPTH_MOVED_PAIR): The op-depth we want to use is the same for all records, so only query it once. Modified: subversion/trunk/subversion/libsvn_wc/wc-queries.sql Modified: subversion/trunk/subversion/libsvn_wc/wc-queries.sql URL: http://svn.apache.org/viewvc/subversion/trunk/subversion/libsvn_wc/wc-queries.sql?rev=1657798&r1=1657797&r2=1657798&view=diff ============================================================================== --- subversion/trunk/subversion/libsvn_wc/wc-queries.sql (original) +++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Fri Feb 6 13:15:25 2015 @@ -1638,9 +1638,8 @@ FROM nodes n JOIN nodes p ON p.wc_id = ?1 AND p.local_relpath = ?2 AND p.op_depth=(SELECT MAX(d.op_depth) FROM nodes d - WHERE d.wc_id = ?1 - AND d.local_relpath = p.local_relpath - AND d.op_depth < ?3) + WHERE d.wc_id = ?1 AND d.local_relpath = ?2 + AND d.op_depth < ?3) WHERE n.wc_id = ?1 AND IS_STRICT_DESCENDANT_OF(n.local_relpath, ?2) AND n.op_depth = ?3