> I have the following scenario that fails on Linux and executes fine on
> Windows XP. Suppose the following SQL statement is executed by calling
> SELECT mySqlFunction()
> Inside the body of the mySqlFuntion() the following statement is executed
> through a call to sqlite3_exec:
> CREATE TEMP TABLE MyTempTable AS SELECT 'foo'
> Followed by the statement:
> DROP TABLE MyTempTable
> The last statement execution fails on Linux (Fedora Core 4) with the
> following error "database table is locked" but not on Windows XP.
> Would somebody know why is that happening?
I wrote the code and I do not know why it is doing what you
observe. So I'm guessing not many other people know either.
I do know that RedHat has fcntl() locking bugs that
SQLite has to go to considerable trouble to work around.
Perhaps the same bugs exit in Fedora and the work-around
code isn't working quite right. Just a guess....