[sqlite] Different kind of db locking behaviour on Unix(Linux) vs. Windows?

[Iulian Popescu]

Hello,

 

I have the following scenario that fails on Linux and executes fine on
Windows XP. Suppose the following SQL statement is executed by calling
sqlite3_exec:

 

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. However
the following statement runs fine on both systems:

 

DELETE FROM MyTempTable

 

Would somebody know why is that happening?

 

Thanks,

Iulian