id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
28274	"Django OperationalError near ""?"": Syntax error"	Adama Camara	nobody	"I am running some test, but I keep getting this error: 

self = <django.db.backends.sqlite3.base.SQLiteCursorWrapper object at 0x7f619aa32d38>
query = '        SELECT cust.id, cust.name, inv.currency_id, SUM(inv.total)\n        FROM\n          v3_customer as cust\n    ...        and inv.invoice_date < ?\n        GROUP BY cust.id, inv.currency_id\n        ORDER BY cust.id, inv.currency_id'
params = [(1, 2, 3, 4), '2016-12-08']

def execute(self, query, params=None):
        if params is None:
            return Database.Cursor.execute(self, query)
        query = self.convert_query(query)
>       return Database.Cursor.execute(self, query, params)
E       django.db.utils.OperationalError: near ""?"": syntax error

../../../environments/tracerenv/lib/python3.4/site-packages/django/db/backends/sqlite3/base.py:337: OperationalError

When looking at the SQL statements and trying to find the ""?"" symbol it does not appear:
WHERE
          cust.id IN %s
          and inv.type = 'i'
          and inv.invoice_date < %s  ---->  ""comment: It is here the ""?"" should have appeared""
        GROUP BY cust.id, inv.currency_id
        ORDER BY cust.id, inv.currency_id

 Could there be some incompatibilities between Postgre and SQLite?"	Bug	new	Uncategorized	1.11	Normal		SQLite pytest		Unreviewed	0	0	0	0	0	0