[New-bugs-announce] [issue10740] sqlite3 module should allow DDL statements in transactions
report at bugs.python.org
Mon Dec 20 19:02:15 CET 2010
New submission from Scott Urban <scott.urban at isilon.com>:
The python sqlite module automatically commits open transactions
when it encounters a DDL statement. This is unnecessary; DDL is
transactional in my testing (see attached).
Attached patch addresses the issue. Patch is against 2.6.1, but
looking at Trunk in svn, it seems like the patch is needed and
would apply. One issue I could foresee is that this behavior might
depend on the sqlite version in use (I'm on 3.6.10).
Patch also allows pragma statement.
components: Library (Lib)
title: sqlite3 module should allow DDL statements in transactions
versions: Python 2.6
Added file: http://bugs.python.org/file20118/pysql-transactions.2.diff
Python tracker <report at bugs.python.org>
More information about the New-bugs-announce