Re: [sqlite] Why is 'database schema has changed' being reported?

2004-08-06 Thread Tito Ciuro 
Hello again,
Following the email I sent yesterday, I've discovered why I get a 
SQLITE_SCHEMA error: VACUUM changes the schema version numbering. The 
question is why? The schema is exactly the same, it has the same 
tables, columns and indexes. Sure, the data is now compacted, but what 
has this to do with the schema? Am I missing something?

Thanks again,
-- Tito
On 5 ago 2004, at 3:39, Tito Ciuro wrote:
Hello,
This happens with SQLite 3.0.3 on Mac OS X 10.3.4.
I'm issuing a simple 'SELECT * FROM people' on my database. When I 
reach 'sqlite3VdbeExec', it falls on the following error:

if( rc==SQLITE_OK && iMeta!=pOp->p2 ){
sqlite3SetString(&p->zErrMsg, "database schema has changed", 
(char*)0);
rc = SQLITE_SCHEMA;
  }

In my code, I execute the query like this:
int result = sqlite3_prepare(db, query, strlen(query), &_vm, 
&query_tail);

I get SQLITE_OK back. '_vm' is also set. Then I call:
result = sqlite3_step(_vm);
and I get result == 1. The error string tells me "database schema has 
changed". The weird thing is that if I inspect the database, all 
records in the people table are there! What's going on?

Any ideas?
Thanks,
-- Tito

[sqlite] Why is 'database schema has changed' being reported?

2004-08-06 Thread Tito Ciuro 
Hello,

This happens with SQLite 3.0.3 on Mac OS X 10.3.4.

I'm issuing a simple 'SELECT * FROM people' on my database. When I reach 'sqlite3VdbeExec', it falls on the following error:

if( rc==SQLITE_OK && iMeta!=pOp->p2 ){
sqlite3SetString(&p->zErrMsg, "database schema has changed", (char*)0);
rc = SQLITE_SCHEMA;
}

In my code, I execute the query like this:

int result = sqlite3_prepare(db, query, strlen(query), &_vm, &query_tail);

I get SQLITE_OK back. '_vm' is also set. Then I call:

result = sqlite3_step(_vm);

and I get result == 1. The error string tells me "database schema has changed". The weird thing is that if I inspect the database, all records in the people table are there! What's going on?

Any ideas?

Thanks,

-- Tito

smime.p7s
Description: S/MIME cryptographic signature