[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2021-05-19 Thread Erlend E. Aasland
Change by Erlend E. Aasland : -- nosy: +erlendaasland ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe:

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2017-12-05 Thread Antoine Pitrou
Change by Antoine Pitrou : -- assignee: ghaering -> versions: +Python 3.7 -Python 2.7, Python 3.2, Python 3.3, Python 3.4, Python 3.5 ___ Python tracker

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2017-12-05 Thread Antoine Pitrou
Change by Antoine Pitrou : -- nosy: +berker.peksag ___ Python tracker ___ ___

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2017-12-05 Thread Antoine Pitrou
Antoine Pitrou added the comment: See https://bugs.python.org/issue32215 for what seems to be a related bug. Also note that pysqlite now seems to be using a different logic: https://github.com/ghaering/pysqlite/blob/master/src/cursor.c#L537-L548 Also this changeset:

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2017-12-02 Thread Allen Li
Change by Allen Li : -- nosy: +Allen Li ___ Python tracker ___ ___ Python-bugs-list

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2017-01-20 Thread Aviv Palivoda
Changes by Aviv Palivoda : -- nosy: +palaviv ___ Python tracker ___ ___ Python-bugs-list

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2016-03-23 Thread Rian Hunter
Rian Hunter added the comment: This bug can also lead to subtle and unintuitive "database is locked" bugs, even when a large timeout is set on the connection. Many, many people are affected by this bug (search the web for "python sqlite database is locked"). I've attached code that

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2016-03-23 Thread Rian Hunter
Changes by Rian Hunter : -- versions: +Python 3.2, Python 3.5, Python 3.6 ___ Python tracker ___

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2015-01-10 Thread Gerhard Häring
Changes by Gerhard Häring g...@ghaering.de: -- assignee: - ghaering ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue9924 ___ ___ Python-bugs-list

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2014-01-09 Thread mike bayer
mike bayer added the comment: see also http://bugs.python.org/issue10740, which also relates to pysqlite attempting to make guesses as to when transactions should begin and end. -- ___ Python tracker rep...@bugs.python.org

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2014-01-09 Thread Antoine Pitrou
Changes by Antoine Pitrou pit...@free.fr: -- versions: +Python 3.3, Python 3.4 -Python 3.1, Python 3.2 ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue9924 ___

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2011-02-22 Thread dholth
dholth dho...@fastmail.fm added the comment: What should this option be called? connect(strict=True) ? -- nosy: +dholth ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue9924 ___

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2010-09-23 Thread Ned Deily
Changes by Ned Deily n...@acm.org: -- nosy: +ghaering versions: -Python 2.5, Python 2.6, Python 3.3 ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue9924 ___

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2010-09-23 Thread Gerhard Häring
Gerhard Häring g...@ghaering.de added the comment: Yes Mike. Avoiding unnecessary locks was exactly the reason for this behaviour. I agree that for serializable transactions I'd need to make some changes. -- ___ Python tracker rep...@bugs.python.org

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2010-09-23 Thread Randall Nortman
Changes by Randall Nortman rnpythonb...@wonderclown.net: -- nosy: +rnortman ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue9924 ___ ___

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2010-09-22 Thread mike bayer
New submission from mike bayer mike...@zzzcomputing.com: Copying this bug from the pysqlite tracker, at http://code.google.com/p/pysqlite/issues/detail?id=21 , as the issue has been opened for two days with no reply. (side node - should sqlite3 bugs be reported here or on the pysqlite tracker

[issue9924] sqlite3 SELECT does not BEGIN a transaction, but should according to spec

2010-09-22 Thread mike bayer
mike bayer mike...@zzzcomputing.com added the comment: My own comment here is that I'm supposing the late BEGIN behavior is to cut down on SQLite's file locking.I think a way to maintain that convenience for most cases, while allowing the stricter behavior that makes SERIALIZABLE