D. Richard Hipp wrote:
Rolf Schaeuble wrote:
There are other places in sqlite3pager_get where SQLITE_IOERR are
returned; I've not checked whether these can also be triggered by the
db being locked or if they indicate serious problem.
If someone is interested, I can send a test case for this
Kurt Welgehausen wrote:
Your update is logically equivalent to this pseudocode:
for every testcs in (select checksum from test) do
update test set id =
(select bucketid from buckets
where buckets.checksum = testcs)
where test.checksum = testcs
You'll
> update test set ID=BucketID
> from buckets B, test T
> where B.CheckSum=T.CheckSum
Your update is logically equivalent to this pseudocode:
for every testcs in (select checksum from test) do
update test set id =
(select bucketid from buckets
where
Hi all,
This is my first post here, so I'd like to express thanks to Mr D.
Richard Hipp for creating
such a great small database!
Now here is my question -- it appears that it is not possible to update
table
while doing join with other tables, something I got so used to with
"big" databases.
Rolf Schaeuble wrote:
Hello,
I've had a look at pager.c to understand what's going on in there. While
I think I understand most of it, there's one point I don't understand:
The comment for pager_stmt_playback says:
**(2) In addition to playing back the statement journal, also
**
Rolf Schaeuble wrote:
There are other places in sqlite3pager_get where SQLITE_IOERR are
returned; I've not checked whether these can also be triggered by the db
being locked or if they indicate serious problem.
If someone is interested, I can send a test case for this problem.
Please go to
6 matches
Mail list logo