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

2010-09-23 Thread Philip Martin
Erik Huelsmann writes: >> > @@ -312,7 +312,7 @@ WHERE wc_id = ?1 AND local_relpath = ?2; >> > update nodes set translated_size = ?3, last_mod_time = ?4 >> > where wc_id = ?1 and local_relpath = ?2 >> > and op_depth = (select op_depth from nodes >> > - where wc_id = ?1 and loc

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

2010-09-23 Thread Greg Stein
On Thu, Sep 23, 2010 at 12:53, Erik Huelsmann wrote: > On Wed, Sep 22, 2010 at 11:25 PM, Greg Stein wrote: >... >> Wouldn't it be better to do: >> >> where wc_id = ?1 and local_relpath = ?2 >>  and op_depth = (select max(op_depth) from nodes >>    where wc_id=?1 and local_relpath=?2 and op_depth

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

2010-09-23 Thread Erik Huelsmann
On Wed, Sep 22, 2010 at 11:25 PM, Greg Stein wrote: > On Wed, Sep 22, 2010 at 05:39, wrote: > >... > > +++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Wed Sep 22 > 09:39:45 2010 > > @@ -215,7 +215,7 @@ update nodes set properties = ?3 > > where wc_id = ?1 and local_relpath = ?2 > >

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

2010-09-22 Thread Philip Martin
Greg Stein writes: > On Wed, Sep 22, 2010 at 05:39, wrote: >>... >> +++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Wed Sep 22 09:39:45 >> 2010 >> @@ -215,7 +215,7 @@ update nodes set properties = ?3 >>  where wc_id = ?1 and local_relpath = ?2 >>   and op_depth in >>    (select op_dep

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

2010-09-22 Thread Greg Stein
On Wed, Sep 22, 2010 at 05:39, wrote: >... > +++ subversion/trunk/subversion/libsvn_wc/wc-queries.sql Wed Sep 22 09:39:45 > 2010 > @@ -215,7 +215,7 @@ update nodes set properties = ?3 >  where wc_id = ?1 and local_relpath = ?2 >   and op_depth in >    (select op_depth from nodes > -    where wc_