[New-bugs-announce] [issue10740] sqlite3 module should allow DDL statements in transactions

Scott Urban 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)
files: pysql-transactions.2.diff
keywords: patch
messages: 124392
nosy: scott.urban
priority: normal
severity: normal
status: open
title: sqlite3 module should allow DDL statements in transactions
type: behavior
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 mailing list