[Chicken-users] Re: sqlite3 and "drop table if exists"

[Thomas Chust]

On Thu, 16 Feb 2006, Zbigniew wrote:

> Thomas, I ran into some odd behaviour while using the sqlite3 egg.  It 
> seems that executing the SQL statement "DROP TABLE IF EXISTS" throws an 
> error when the table does not exist.  The same is true for "CREATE TABLE 
> IF NOT EXISTS".  Apparently, sqlite3_step is returning the error code 
> for "misuse", although the error message reported is "not an error" 
> (basically an impossible "error 0" message). [...]

Hello,

currently I cannot reproduce this problem. "DROP TABLE IF EXISTS" and 
"CREATE TABLE IF NOT EXISTS" both don't exist in the version of SQLite3 on 
my machine, which is slightly older. But I'm a bit reluctant to update, 
because it is part of the standard MacOS X distribution and used by a few 
programs. It may even contain some Apple specific patches, so I'll have to 
be really careful not to break half of my system when updating. For such 
operations it's too late at night now ;)

Although I will try to look into this again, you may want to create a 
workaround for your problem in the meantime. I would suggest to explicitly 
check the sqlite_master table for the presence of the table in question 
with a query like
   SELECT count(name) FROM sqlite_master
    WHERE type = 'table' AND name = 'my_table';

This would also be backwards compatible with my antique SQLite3 library ;)

Concerning your other problem with large integers, I uploaded a new 
fixed version of the sqlite3 egg to my website:
   http://www.chust.org/projects/sqlite3.html
   http://www.chust.org/projects/sqlite3.egg

cu,
Thomas