RE: SQLite and the LIKE operator

2011-05-16 Thread Bert Huijben
> -Original Message- > From: Hyrum K Wright [mailto:hy...@hyrumwright.org] > Sent: maandag 16 mei 2011 11:18 > To: Bert Huijben > Cc: Branko Čibej; dev@subversion.apache.org > Subject: Re: SQLite and the LIKE operator > > On Mon, May 16, 2011 at 8:28

Re: SQLite and the LIKE operator

2011-05-16 Thread Julian Foad
Branko Čibej wrote: > On 16.05.2011 11:17, Hyrum K Wright wrote: > > On Mon, May 16, 2011 at 8:28 AM, Bert Huijben wrote: > >>> 2011/5/16 Branko Čibej : > On 16.05.2011 03:13, Hyrum K Wright wrote: > > Several places in wc_db we use the following pattern to select all > > nodes with a

Re: SQLite and the LIKE operator

2011-05-16 Thread Branko Čibej
>> Cc: dev@subversion.apache.org >>> Subject: Re: SQLite and the LIKE operator >>> >>> 2011/5/16 Branko Čibej : >>>> On 16.05.2011 03:13, Hyrum K Wright wrote: >>>>> Several places in wc_db we use the following pattern to select all >&

Re: SQLite and the LIKE operator

2011-05-16 Thread Hyrum K Wright
On Mon, May 16, 2011 at 8:28 AM, Bert Huijben wrote: > > >> -Original Message- >> From: Hyrum K Wright [mailto:hy...@hyrumwright.org] >> Sent: maandag 16 mei 2011 9:39 >> To: Branko Čibej >> Cc: dev@subversion.apache.org >> Subject: Re: SQLite an

RE: SQLite and the LIKE operator

2011-05-16 Thread Bert Huijben
> -Original Message- > From: Hyrum K Wright [mailto:hy...@hyrumwright.org] > Sent: maandag 16 mei 2011 9:39 > To: Branko Čibej > Cc: dev@subversion.apache.org > Subject: Re: SQLite and the LIKE operator > > 2011/5/16 Branko Čibej : > > On 16.05.20

RE: SQLite and the LIKE operator

2011-05-16 Thread Bert Huijben
> -Original Message- > From: Branko Čibej [mailto:br...@xbc.nu] On Behalf Of Branko Cibej > Sent: maandag 16 mei 2011 9:46 > To: dev@subversion.apache.org > Subject: Re: SQLite and the LIKE operator > > On 16.05.2011 09:38, Hyrum K Wright wrote: > > 2011/

Re: SQLite and the LIKE operator

2011-05-16 Thread Branko Čibej
On 16.05.2011 09:38, Hyrum K Wright wrote: > 2011/5/16 Branko Čibej : >> On 16.05.2011 03:13, Hyrum K Wright wrote: >>> Several places in wc_db we use the following pattern to select all >>> nodes with a common tree ancestor: >>> WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ES

Re: SQLite and the LIKE operator

2011-05-16 Thread Hyrum K Wright
2011/5/16 Branko Čibej : > On 16.05.2011 03:13, Hyrum K Wright wrote: >> Several places in wc_db we use the following pattern to select all >> nodes with a common tree ancestor: >>  WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE >> '#') >> >> While this works, there was s

Re: SQLite and the LIKE operator

2011-05-15 Thread Branko Čibej
On 16.05.2011 03:13, Hyrum K Wright wrote: > Several places in wc_db we use the following pattern to select all > nodes with a common tree ancestor: > WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#') > > While this works, there was some concern about whether or not SQL

SQLite and the LIKE operator

2011-05-15 Thread Hyrum K Wright
Several places in wc_db we use the following pattern to select all nodes with a common tree ancestor: WHERE wc_id = ?1 AND (local_relpath = ?2 OR local_relpath LIKE ?3 ESCAPE '#') While this works, there was some concern about whether or not SQLite was using the proper indicies when executing thi