[Python-Dev] sqlite, DDL, and transactions (original) (raw)

Michael Foord fuzzyman at voidspace.org.uk
Mon Dec 20 18:03:51 CET 2010

On 20/12/2010 16:48, Scott Urban wrote:

Hi

The python sqlite module automatically commits open transactions when it encounters a DDL statement. This is unnecessary; DDL is transaction in my testing (see attached).

Hello Scott,

Please post your patch to the Python bug tracker.

http://bugs.python.org/

All the best,

Michael Foord

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

Thanks Scott

Python-Dev mailing list Python-Dev at python.org http://mail.python.org/mailman/listinfo/python-dev Unsubscribe:http://mail.python.org/mailman/options/python-dev/fuzzyman%40voidspace.org.uk

--

http://www.voidspace.org.uk/

May you do good and not evil May you find forgiveness for yourself and forgive others May you share freely, never taking more than you give. -- the sqlite blessinghttp://www.sqlite.org/different.html

-------------- next part -------------- An HTML attachment was scrubbed... URL: <http://mail.python.org/pipermail/python-dev/attachments/20101220/b73e3c3d/attachment.html>

More information about the Python-Dev mailing list