New submission from Scott Urban :
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
Scott Urban added the comment:
Here are some tests.
--
Added file: http://bugs.python.org/file20119/test_sqlite_ddl.py
___
Python tracker
<http://bugs.python.org/issue10
Scott Urban 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 because having DDL
