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
15914	F-expressions used with iexact lookup produces invalid SQL	Łukasz Rekucki	nobody	"Example queries generated from {{{Employee.objects.filter(firstname__iexact=F('lastname'))}}}:

{{{#!sql
-- 1. PostgreSQL

SELECT ""expressions_employee"".""id"", ""expressions_employee"".""firstname"", ""expressions_employee"".""lastname"" 
FROM ""expressions_employee"" WHERE UPPER(""expressions_employee"".""firstname""::text) = UPPER() ""expressions_employee"".""lastname""
-- DatabaseError: syntax error at or near """"expressions_employee""""
-- LINE 1: ...xpressions_employee"".""firstname""::text) = UPPER() ""expressio...

-- 2. SQLite

SELECT ""expressions_employee"".""id"", ""expressions_employee"".""firstname"", ""expressions_employee"".""lastname"" 
FROM ""expressions_employee"" WHERE ""expressions_employee"".""firstname"" LIKE  ESCAPE '\' ""expressions_employee"".""lastname""
-- DatabaseError: near ""ESCAPE"": syntax error
}}}

I found the error on Django 1.2. Reproduced on trunk (see attachment)"	Bug	closed	Database layer (models, ORM)	1.2	Normal	duplicate			Unreviewed	0	0	0	0	0	0