[sqlite] archive of this list

2004-04-16 Thread Andrew Shakinovsky
Does anyone know if there is an archive of this list anywhere? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread VTenneti
Hi, Can anyone please tell me if 'EXISTS' is supported (for subqueries in the WHERE clause) and also if corelated subqueries are supported ? One more thing: on the 'features not supported' page, the second point mentions variables not being supported in queries: are these 'corelation

Re: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread Kurt Welgehausen
> EXISTS No. Instead of 'where exists (select * ... )', use 'where (select count(*) ...) > 0'. > cor[r]elated subqueries No. They're called variable subqueries on the Features-not-supported page. > range variables, or are they host variables ? Both. (Neither is supported.) Regards

Re: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread Kurt Welgehausen
> Any chance of their being added ... ? I doubt it; there have been lots of proposals for changes and additions flying around, but these points haven't come up (as best I can recall). Regards - To unsubscribe, e-mail: [EMAIL

RE: [sqlite] Exists keyword and corelated subqueries

2004-04-16 Thread Thomas, Basil
I think once SQLite ver 3.0 stabilizes, all of the enhancements to the SQL language capabilities will be addressed then. Once the the file format and low level engine enhancements are in production, I am sure many of us will want more compliant SQL code similar to SQL

RE: [sqlite] Help with "SQL error: database is locked"

2004-04-16 Thread Juan Romano
Hi, I am in the process of porting sqlite (version 2.8.13) to vxworks. I am running into some problems. It seems to work when I invoke the shell with no database (:memory:). I can then create tables, insert records, etc. In general I can submit SQL queries at will. However, when I invoke the

Re: [sqlite] Concurrency, MVCC

2004-04-16 Thread Christian Smith
On Thu, 15 Apr 2004, Doug Currie wrote: > >Thursday, April 15, 2004, 9:16:01 AM, Christian Smith wrote: > >> On Wed, 14 Apr 2004, Doug Currie wrote: > >>>One way to get table level locking without a great deal of pain is to >>>integrate the shadow paging ideas with BTree management. Rather than