[issue8689] sqlite3 parameter substitution breaks with multiple parameters

Terry J. Reedy added the comment: Given that this is a real, and disconcerting problem, and not a failure to read the doc, no apology needed. At least one solution is recorded here for anyone else hitting the same problem. If anyone thinks there should be a change to the sqlite3 module, they

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

Simon Jagoe added the comment: Sorry for the waste of time. I have compiled Python 2.6.5 against sqlite3 3.6.22 (Lucid version) and 3.6.16-1ubuntu1 (Karmic version). The test I posted originally fails with sqlite3 3.6.22 and passes with sqlite3 3.6.16-1ubuntu1, so it would appear to be a chan

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

Terry J. Reedy added the comment: The next question is whether there is any bug in the Python interface module or whether c.execute(s,t) is properly passing s and t to sqlite3 for processing and converting the return to a Python tuple. If the latter, then this should be closed as invalid (bec

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

angri added the comment: This thread contains some observations of versions affected: http://groups.google.com/group/python-sqlite/browse_thread/thread/a53a5e5282e29318 -- ___ Python tracker __

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

Simon Jagoe added the comment: I will try to test this with the different combinations of python and sqlite versions. -- ___ Python tracker ___ _

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

Terry J. Reedy added the comment: You appear to be saying that the same code gives different results on 2.6.4 and 2.6.5. Correct? If so, did the version of sqlite change? In any case, 3.1.2 on WinXP consistently gives (2,) >>> sqlite3.version '2.4.1' -- nosy: +tjreedy ___

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

Marcin Bachry added the comment: I wrote a Perl script testing this issue and it fails too, so it's most probably a bug in sqlite itself. I think the bug is already reported under id 26ff0c82d1 in sqlite bug tracker: http://www.sqlite.org/src/rptview?rn=2 -- nosy: +marcin.bachry ___

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

Changes by angri : -- nosy: +angri ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailma

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

New submission from Simon Jagoe : I have been using sqlalchemy and sqlamp in a project for a while with Python 2.5.x and Python 2.6.4. With a recent upgrade to Python 2.6.5 (on Ubuntu Lucid Lynx), a particular operation began to fail when using sqlite. I have tracked this to using the sqlite3