Greg Stein <gst...@gmail.com> writes:
> On Mar 17, 2011 7:19 PM, <phi...@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
