[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-14 Thread Terry J. Reedy 

Terry J. Reedy tjre...@udel.edu 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

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-14 Thread Simon Jagoe 

Simon Jagoe simon.ja...@pragmagility.com added the comment:

I will try to test this with the different combinations of python and sqlite 
versions.

--

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-14 Thread angri 

angri gene...@angri.ru added the comment:

This thread contains some observations of versions affected: 
http://groups.google.com/group/python-sqlite/browse_thread/thread/a53a5e5282e29318

--

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-14 Thread Terry J. Reedy 

Terry J. Reedy tjre...@udel.edu 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 (because it is a 3rd party problem).

--

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-14 Thread Terry J. Reedy 

Terry J. Reedy tjre...@udel.edu 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 can 
reopen this.

--
resolution:  - invalid
status: open - closed

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-13 Thread Marcin Bachry 

Marcin Bachry hegel...@gmail.com 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

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-11 Thread angri 

Changes by angri gene...@angri.ru:


--
nosy: +angri

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

[issue8689] sqlite3 parameter substitution breaks with multiple parameters

2010-05-11 Thread Simon Jagoe 

New submission from Simon Jagoe azriph...@gmail.com:

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 module and multiple parameter 
substitution. See below for a simple test case.

Set up the database:

  import sqlite3
  conn = sqlite3.connect('test.sqlite3')
  c = conn.cursor()
  c.execute('create table test (col integer)')
  c.execute('insert into test values (1)')
  conn.commit()

Actual result:

  c.execute('SELECT coalesce(max(test.col), ?) + ? AS col FROM test', (0, 1))
  c.fetchone()
 (None,)

Expected result:

  c.execute('SELECT coalesce(max(test.col), ?) + ? AS col FROM test', (0, 1))
  c.fetchone()
 (2,)

The expected result can be simulated like this:

  c.execute('SELECT coalesce(max(test.col), 0) + 1 AS col FROM test')
  c.fetchone()
 (2,)

--
messages: 105525
nosy: azriphale
priority: normal
severity: normal
status: open
title: sqlite3 parameter substitution breaks with multiple parameters
versions: Python 2.6

___
Python tracker rep...@bugs.python.org
http://bugs.python.org/issue8689
___
___
Python-bugs-list mailing list
Unsubscribe: 
http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com