[issue4995] sqlite3 module gives SQL logic error only in transactions

Muayyad Alsadi added the comment: a fedora-devel fellow gave me a solution cn=sqlite3.connect(':memory:', isolation_level=None) and it worked I hope that does not affect other versions $ python Python 2.5.2 (r252:60911, Sep 30 2008, 15:41:38) [GCC 4.3.2 20080917 (Red Hat 4.3.2-4)] on linux2

[issue4995] sqlite3 module gives SQL logic error only in transactions

Antoine Pitrou added the comment: Well I'm no sqlite expert, but here are the values I get on the 2.6 branch: >>> sqlite3.apilevel '2.0' >>> sqlite3.sqlite_version '3.6.1' >>> sqlite3.sqlite_version_info (3, 6, 1) >>> sqlite3.version '2.4.1' >>> sqlite3.version_info (2, 4, 1) _

[issue4995] sqlite3 module gives SQL logic error only in transactions

Muayyad Alsadi added the comment: can you please tell me how to detect the version so that my application will not crash on Python 2.5.2 (r252:60911, Sep 30 2008, 15:41:38) which of these values should I use apilevel = '2.0' sqlite_version = '3.5.9' sqlite_version_info = (3, 5, 9)

[issue4995] sqlite3 module gives SQL logic error only in transactions

Antoine Pitrou added the comment: Ok, I've just tried. While it fails in Python 2.5.2, it works in 2.6.1 and in trunk (what will become 2.7). So I suggest you upgrade to 2.6.1, or simply drop the "BEGIN TRANSACTION" statement in this particular case. -- resolution: -> rejected status:

[issue4995] sqlite3 module gives SQL logic error only in transactions

Muayyad Alsadi added the comment: same thing [als...@pc1 ~]$ python Python 2.5.2 (r252:60911, Sep 30 2008, 15:41:38) [GCC 4.3.2 20080917 (Red Hat 4.3.2-4)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import sqlite3 >>> cn=sqlite3.connect(':memory:') >>>

[issue4995] sqlite3 module gives SQL logic error only in transactions

Antoine Pitrou added the comment: What if you commit before the insert? -- nosy: +pitrou ___ Python tracker ___ ___ Python-bugs-list m

[issue4995] sqlite3 module gives SQL logic error only in transactions

Changes by Muayyad Alsadi : -- type: -> behavior ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.py

[issue4995] sqlite3 module gives SQL logic error only in transactions

New submission from Muayyad Alsadi : when I use transactions I got errors I won't get with sqlite3 cli [als...@pc1 ~]$ python Python 2.5.2 (r252:60911, Sep 30 2008, 15:41:38) [GCC 4.3.2 20080917 (Red Hat 4.3.2-4)] on linux2 Type "help", "copyright", "credits" or "license" for more information.