New submission from Scott Urban scott.ur...@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
Scott Urban scott.ur...@isilon.com added the comment:
Here are some tests.
--
Added file: http://bugs.python.org/file20119/test_sqlite_ddl.py
___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue10740
Scott Urban scott.ur...@isilon.com added the comment:
I find the way that the sqlite3 module handles transactions pretty
surprising in general, but I agree that someone who got used
to DDL not rolling back could in theory find this patch surprising.
We will apply this patch to our python build