[fdo-trac] #389: SQLite provider: executing Delete after an aborted Select fails to COMMIT

[FDO]

#389: SQLite provider: executing Delete after an aborted  Select fails to COMMIT
-------------------------------+--------------------------------------------
   Reporter:  traianstanev     |       Owner:  traianstanev
       Type:  defect           |      Status:  new         
   Priority:  major            |   Milestone:              
  Component:  SQLite Provider  |     Version:  3.2.0       
   Severity:  3                |    Keywords:              
External_id:                   |  
-------------------------------+--------------------------------------------
 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().

-- 
Ticket URL: <http://trac.osgeo.org/fdo/ticket/389>
FDO <http://fdo.osgeo.org/>
Feature Data Objects