Hi all

This is very minor, but I thought I would mention it.

I have a function that returns a complex SQL query and a tuple of parameters. The query is stored inside the function as a triple-quoted string, and the parameters are derived depending on the input arguments.

Sometimes while testing I will comment out some of the SQL using '--'. If those lines happen to contain a parameter placeholder ('%s') I expected to remove the parameter from the tuple as well.

pyodbc and sqlite3 both work this way, but psycopg2 raises the exception 'tuple index out of range'.

I can live with it, but it means that I have to adjust the parameter tuple differently depending on which database I am testing with.

If it can be fixed, that would be nice. If it can't, no problem.

Frank Millman


Reply via email to