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
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
I think once SQLite ver 3.0 stabilizes, all of the enhancements to the SQL
capabilities will be addressed then. Once the the file format and low level
enhancements are in production, I am sure many of us will want more
code similar to SQL
> 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).
To unsubscribe, e-mail: [EMAIL
No. Instead of 'where exists (select * ... )', use
'where (select count(*) ...) > 0'.
> cor[r]elated subqueries
No. They're called variable subqueries on the
> range variables, or are they host variables ?
Both. (Neither is supported.)
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
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]
Mail list logo