Ticket #389 (closed defect: fixed)
SQLite provider: executing Delete after an aborted Select fails to COMMIT
|Reported by:||traianstanev||Owned by:||traianstanev|
Here is the sequence that produces the problem:
* Execute a Select * Close the FdoFeatureReader? returned by the select before the reader is finished. * Execute a delete command
Result: The delete fails because it cannot commit its transaction. The reason it can't is because of a bug in the SQLite implementation of FdoIFeatureReader::Close() -- it does not reset the SQLite execution engine in the case of a premature call to Close().