-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/14/2010 07:41 PM, Hemant Shah wrote:
Sometimes I get following error:
SQL logic error or missing database.
That text corresponds to the error code SQLITE_ERROR which is the code used
for a wide variety of error conditions that don't have a
Do you have SQLite Manager extension for Firefox installed? I had problems
with it having the database open until Firefox is restarted.
On Tue, Sep 14, 2010 at 15:45, Andrew Wood ajw...@theiet.org wrote:
Im getting an error saying the database is locked even though no other
process is
On 15-09-2010 03:42, Pavel Ivanov wrote:
Did you by any chance introduced some unique constraint or unique
index on a set of columns one of which is primary key? AFAIK, there
was a problem in SQLite until some recent versions in processing of
redundant unique constraints in conjunction with
I've seen this kind of issue before - after closing the sqlite3
database, I can't delete the file (I would want to do this if I opened
an sqlite3 database and found it to be corrupt). As sqlite's connection
handle has closed, I assume sqlite should no longer have any handles
open to the database;
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/15/2010 01:43 AM, Nick Shaw wrote:
I assume sqlite should no longer have any handles
open to the database; however Windows (which I'm running under) may well
still have open handles to the file waiting to flush cached changes to
disk. The
On Tue, Sep 14, 2010 at 23:41, Stef Mientki stef.mien...@gmail.com wrote:
until a few moments ago, this worked perfectly
select Header from vraag
natural join vraaglist
where Nr = 0 and vraaglist.Name = 'eortc_br23'
but now it returns an empty string (while the string shouldn't be
On 15-09-2010 11:36, Benoit Mortgat wrote:
On Tue, Sep 14, 2010 at 23:41, Stef Mientki stef.mien...@gmail.com wrote:
until a few moments ago, this worked perfectly
select Header from vraag
natural join vraaglist
where Nr = 0 and vraaglist.Name = 'eortc_br23'
but now it returns an empty
On Wed, Sep 15, 2010 at 08:05:26PM +0200, Stef Mientki wrote:
On 15-09-2010 11:36, Benoit Mortgat wrote:
Are you sure that after altering your tables adding columns, natural
join still only joins on vlid?
no, very stupid of me !!
I added a column to each of the tables, with the same
--- On Tue, 9/14/10, Simon Slavin slav...@bigfraud.org wrote:
From: Simon Slavin slav...@bigfraud.org
Subject: Re: [sqlite] SQL Logic error for in-memory database
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date: Tuesday, September 14, 2010, 9:51 PM
On 15 Sep 2010,
The error occurs while calling sqlite3_step().
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 9/15/10, Roger Binns rog...@rogerbinns.com wrote:
From: Roger Binns rog...@rogerbinns.com
Subject: Re: [sqlite] SQL Logic error for in-memory database
To: General Discussion of SQLite Database
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/15/2010 11:53 AM, Hemant Shah wrote:
The error occurs while calling sqlite3_step().
Call sqlite3_reset and then get the error message text.
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with
On 15-09-2010 20:12, Nicolas Williams wrote:
On Wed, Sep 15, 2010 at 08:05:26PM +0200, Stef Mientki wrote:
On 15-09-2010 11:36, Benoit Mortgat wrote:
Are you sure that after altering your tables adding columns, natural
join still only joins on vlid?
no, very stupid of me !!
I added a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've got a large third party data set I imported into SQLite. Queries are
surprising fast especially since I haven't created any indices yet. The
reason turned out to be because of the automatic index functionality.
When doing an explain query
FWIW, there is a second edition of the Definitive Guide to SQLite,
apparently coming out in Nov:
http://www.amazon.com/Definitive-Guide-SQLite-Mike-Owens/dp/1430232250/
Allen Grant is the author doing the work. I don't have any details other
than that. I hear he's a good guy for the job though.
On Wed, Sep 15, 2010 at 5:46 PM, Roger Binns rog...@rogerbinns.com wrote:
I've got a large third party data set I imported into SQLite. Queries are
surprising fast especially since I haven't created any indices yet. The
reason turned out to be because of the automatic index functionality.
After executing sqlite3_step(), I check to see if the return code is SQLITE_OK
if (rc != SQLITE_OK)
{
printf(%s\n, sqlite3_errmsg(dbhandle);
}
I will add sqlite3_reset() before calling sqlite3_errmsg().
Hemant Shah
E-mail: hj...@yahoo.com
--- On Wed, 9/15/10, Roger Binns
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/15/2010 06:00 PM, Cory Nelson wrote:
SQLite doesn't support automatic indexing,
And your basis for that claim is?
The basis of mine is that it did for me.
And this page:
http://www.sqlite.org/optoverview.html#autoindex
And these
On Wed, Sep 15, 2010 at 8:25 PM, Roger Binns rog...@rogerbinns.com wrote:
On 09/15/2010 06:00 PM, Cory Nelson wrote:
SQLite doesn't support automatic indexing,
And your basis for that claim is?
This might not be doing what you think it is.
When you have a query that will do a full table
Quoth Cory Nelson phro...@gmail.com, on 2010-09-15 20:58:24 -0700:
It sounds like you already know which columns will be queried against.
You should probably be creating permanent indexes.
I'm pretty sure his question was asking whether he could verify the
set of relevant columns empirically
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/15/2010 08:58 PM, Cory Nelson wrote:
This might not be doing what you think it is.
It does exactly what I think it does and as is documented.
When you have a query that will do a full table scan multiple times,
SQLite can sometimes create
20 matches
Mail list logo