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
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
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
