Hi again, To answer the question in the title : - yes, the "autocommit" bug is buggy with "with", http://bugs.python.org/issue21718 - it is also buggy with comments at the beginning of the 'select'.
The "autocommit" feature was a false good idea, but as sqlite3 arrived like that in the standard library, they can't "change" this default. If I understood well, the "autocommit" idea was to not "hold" the database file by default, and ease multi-user access to the file database. I tested your example with Python 2.7.5 and SQLite3.8.4, works nicely. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users