[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: svn commit: r1082650 - /subversion/trunk/subversion/libsvn_wc/wc-queries.sql

From: Philip Martin <philip.martin_at_wandisco.com>
Date: Thu, 17 Mar 2011 20:08:34 +0000

Greg Stein <gstein_at_gmail.com> writes:

> On Mar 17, 2011 7:19 PM, <philip_at_apache.org> wrote:
>>
>> Author: philip
>> Date: Thu Mar 17 19:19:11 2011
>> New Revision: 1082650
>>
>> URL: http://svn.apache.org/viewvc?rev=1082650&view=rev
>> Log:
>> Only single statements in wc-queries.sql are executed, anything after
>> a semi-colon is ignored. That means that some statements setting up
>> indices were not getting executed, and one statement lost part of
>> it selection criteria.
>
> You can use svn_sqlite__exec_statements() for those multi-statement
> operations.

Not if one wants to bind:

-- STMT_CACHE_NODE_PROPS_RECURSIVE
CREATE TEMPORARY TABLE temp__node_props_cache AS
  SELECT local_relpath, kind, properties FROM nodes_current
  WHERE wc_id = ?1
    AND (?2 = '' OR local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#')
    AND local_relpath NOT IN (
      SELECT local_relpath FROM actual_node WHERE wc_id = ?1)
    AND (presence = 'normal' OR presence = 'incomplete');
CREATE UNIQUE INDEX temp__node_props_cache_unique
  ON temp__node_props_cache (local_relpath)

-- 
Philip
Received on 2011-03-17 21:09:45 CET

This is an archived mail posted to the Subversion Dev mailing list.