Re-submitted cause line color in red didn’t come thru. [] around the
reported line
Subject: sqlite testing with Boundschecker
Hi,
I have done some testing with 3.2 and now 3.4, visual studio2003 and
boundschecker (and XP). I get a few reported errors when I simply do the
.dump command
Hi,
I have done some testing with 3.2 and now 3.4, visual studio2003 and
boundschecker (and XP). I get a few reported errors when I simply do the
.dump command with no db. Happens on other times with a db, this is easier.
Line numbers are from the downloaded 3.4.0 source. I don’t really know
, but before
sqlite3_finalize causes crash in btree.c
On 9/1/05, Damian Slee <[EMAIL PROTECTED]> wrote:
>
>
> Work arounds are to call sqlite3_finalize on the query (to cleanup)
> before detaching, or only selecting the top N in the first place.
>
> I don't know the inte
Hi,
Don't know yet if this is fixed in the latest version, but I thought I would
bring it up anyway.
We are using 3.2.2 library on windows.
Open a database
If you then attach another database
- sqlite3_exec()
Then step a select query, combining some info from tables from both database
-
>>In order to implement the ORDER BY clause, SQLite reads the entire result set
>>into memory and sorts it there. When your result set gets very large (13000
>>rows) and each row uses in excess of 1KB or memory,this is apparently causing
>>your machine to thrash.
If an index exists on the
I tried it on windows for you. sqlite3.exe v3.21
sqlite> select round(1-0.5);
1
sqlite> select round(2-0.5);
2
sqlite> select round(3-0.5);
3
sqlite> select round(4-0.5);
4
sqlite> select round(5-0.5);
5
sqlite> select round(6-0.5);
6
Maybe the math libarary on the C compiler you are using?
You could create a new os_ram.c file, with new versions of these functions, but
instead of read/writing to disk you are read/writing from a linked list of
filenames, of which each could contain a ptr to the file data. You would then
be responsible for copying it back to disk at some point.
Hi,
In the sqlite wiki below it describes the use of pragma user_version, but
doesn't really say how to use it. I'm evaluating the latest sqlite.exe.
Say on initial creation of me DB I set user_version to 1. then product with DB
schema 1 gets released.
Then at some point in the future I want
From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
Sent: Sun 1/05/2005 1:07 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] backup open database
Why is it inappropriate to use:
sqlite originaldb ".dump" | sqlite backupdb
On Sun, 2005-05-01 at 00:28 +0800, Damian
hi all,
i want to make a copy of a sqlite3 database file while it is open. is there
anyway that i can tell programatically that any caches/journals are flushed
out? or is there any way to get and exclusive lock i guess, before making a
backup copy?
my proposed application would have quite a
10 matches
Mail list logo
