[issue10513] sqlite3.InterfaceError after commit
report at bugs.python.org
Wed Nov 24 11:08:17 CET 2010
Anders Blomdell <anders.blomdell at control.lth.se> added the comment:
The culprit seems to be 'pysqlite_do_all_statements(self, ACTION_RESET, 0)' in pysqlite_connection_commit, which resets all active statements, but subsequent fetch/fetchall seems to trash the sqlite3 state in the statements. Removing the ACTION_RESET seems to bring back old behaviour (if it's the correct fix is, however, beyond me).
Slightly modified testprogram that shows more wierdness; output from:
c = cursor.execute(' select k from t where k == ?;', (0,))
which is not what I would expect with a primary key...
Added file: http://bugs.python.org/file19794/sqlite_bug.py
Python tracker <report at bugs.python.org>
More information about the Python-bugs-list