[sqlite] Different behaviour on 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 statements are executed

through calls to sqlite3_exec:

 

CREATE TEMP TABLE MyTempTable AS SELECT 'foo'

 

Then a:

 

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.

What would be a reason for that?

 

Thanks,

 

Iulian.