[sqlite] archive of this list

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

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 variable

Re: [sqlite] Exists keyword and corelated subqueries

> 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] archive of this list

http://www.mail-archive.com/[EMAIL PROTECTED]/ http://www-lnc.usc.edu/~brannon/sqlite-mail-archive/gzip-file/ (old) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] Exists keyword and corelated subqueries

Thanks a lot for that, Kurt. Any chance of their being added to SQLite anytime soon ? Vijay Kurt Welgehausen <[EMAIL PROTECTED]>

Re: [sqlite] Exists keyword and corelated subqueries

> 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 PR

RE: [sqlite] Exists keyword and corelated subqueries

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 Server/Oracle/Sybase/MySQL/etc

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

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 shell

Re: [sqlite] Concurrency, MVCC

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 >>

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

I have found the problem. The lock hash table uses inodes as a hash key. Well, we are using DOS (I know, I know ...) so that did not work and all files were using the same lock. Thanks, Juan// -Original Message- From: Juan Romano [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 200