RE: [sqlite] Proposed 3.3.0 changes. Was: 5/2==2

For what it is worth… I would NOT be in favor of this change. As was discussed in the original post this would be NON-STANDARD behavior. The SQL-99 spec says that integer math remains an integer. The only time I would like an integer to return a "real" result is if that integer is stored in

RE: [sqlite] On VACUUM I get "constraint failed"

Hard to tell from the schema that you attached where the problem might be... but try doing a .dump from the command line util and re-importing into a clean db, it should where expose the issue is. sqlite> .output db.sql sqlite> .dump sqlite> .exit sqlite3 -init db.sql test.db hope this helps

Re: [sqlite] Infinite loop on sqlite3_close()

From: Jens Miltner <[EMAIL PROTECTED]> Reply-To: sqlite-users@sqlite.org To: sqlite-users@sqlite.org Subject: Re: [sqlite] Infinite loop on sqlite3_close() Date: Fri, 14 Oct 2005 17:38:04 +0200 Am 10.10.2005 um 16:53 schrieb Preston Zaugg: While running some performance tests

Re: [sqlite] drop statement returns SQLITE_ERROR

"Preston Zaugg" <[EMAIL PROTECTED]> wrote: > I have some updates to the schema of my sqlite database that i am trying to > apply. When i run these statements from the command line util they run fine. > when i run them from the API I get a SQLITE_ERROR on the state

[sqlite] Infinite loop on sqlite3_close()

While running some performance tests i ran into a condition where sqlite3_close got caught in an infinite loop. The loop it gets caught in is on line main.c 194: while( pPrev && pPrev->pNext!=db ){ pPrev = pPrev->pNext; } This did not happen until i upgraded to 3.2.7, not the only

Re: [sqlite] SQL logic error when running vacuum;

: "Preston Zaugg" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Tuesday, October 04, 2005 10:58 AM Subject: RE: [sqlite] SQL logic error when running vacuum; Well, based on your comment i tried a vacuum from the API and i still get the error. Original Me

RE: [sqlite] SQL logic error when running vacuum;

interface that much. I suspect it has nothing to do with the engine itself, rather with the command-line tool. > -Original Message----- > From: Preston Zaugg [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 04, 2005 6:35 PM > To: sqlite-users@sqlite.org > Subject: [sqlite] SQL logic

[sqlite] SQL logic error when running vacuum;

I have a database (encrypted w/ encryption extensions from drh). After run a sql file on this database it gives the error "SQL error: SQL logic error or missing database" after running a vacuum. it also seems to give this error sporadically on other statements. the sql file that i run does the