Stefan Sperling <s...@elego.de> writes:

> On Tue, Nov 01, 2011 at 06:29:59PM +0000, Philip Martin wrote:
>> I put in the ORDER BY to preserve the parents before children
>> notification used by 1.6.  I wonder if that notification order is
>> important?
>
> See r1196191.
> It should preserve the 1.6.x order (via svn_path_compare_paths()).
>
>> A patch that we could commit without affecting the order is:
>> 
>> Index: subversion/libsvn_wc/wc-queries.sql
>> ===================================================================
>> --- subversion/libsvn_wc/wc-queries.sql      (revision 1196106)
>> +++ subversion/libsvn_wc/wc-queries.sql      (working copy)
>> @@ -1193,7 +1193,7 @@
>>  CREATE TEMPORARY TABLE delete_list (
>>  /* ### we should put the wc_id in here in case a delete spans multiple
>>     ### working copies. queries, etc will need to be adjusted.  */
>> -   local_relpath TEXT PRIMARY KEY NOT NULL
>> +   local_relpath TEXT PRIMARY KEY NOT NULL UNIQUE
>>     )
>
> Interesting. Can you explain why this doesn't affect order?
Because I retained ORDER BY in the select statement.

> I guess this works because there is only one column in the table?
> Do UNIQUE columns happen to be inserted, or selected, in sorted order?

UNIQUE simple means that an index is created so the ORDER BY is fast.

-- 
Philip

Reply via email to