Opened 16 years ago

Closed 16 years ago

#389 closed defect (fixed)

SQLite provider: executing Delete after an aborted Select fails to COMMIT

Reported by: traianstanev Owned by: traianstanev
Priority: major Milestone:
Component: SQLite Provider Version: 3.2.0
Severity: 3 Keywords:
Cc: External ID:

Description

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().

Change History (1)

comment:1 by traianstanev, 16 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.