Evens Fortuné <evens.fort...@gmail.com> added the comment:

I don't think this is a bug. As I have explained in the answer I have provided 
on StackOverflow 
(https://stackoverflow.com/posts/comments/112539410?noredirect=1), it seems 
that sqlite3 uses by default the qmark parameter substitution style for their 
query which uses a tuple to provide it with its values. So it makes sense that 
the error message only does reference the index number since the matching is 
done on the order where a parameter appear on the SQL query and the same order 
in the tuple provided.

Here @Wolfgang seems to try to use the named parameter substitution style 
because he is using a dictionary to provide the values to the query. You have 
to set it globally before doing that (sqlite3.paramstyle = 'named').

So from my point of view there is no bug here.

----------
nosy: +EvensF

_______________________________________
Python tracker <rep...@bugs.python.org>
<https://bugs.python.org/issue41638>
_______________________________________
_______________________________________________
Python-bugs-list mailing list
Unsubscribe: 
https://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com

Reply via email to