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 14110 iexact lookup doesn't work with subquery values Alexander Schepanovski Alexander Schepanovski "With PostgreSQL and model {{{ class Category(models.Model): title = models.CharField(max_length=127) }}} we have: {{{ >>> Category.objects.filter(title__icontains=Category.objects.filter(pk=1).values('title')) DatabaseError: syntax error at or near ""("" LINE 1: ...PPER(""board_category"".""title""::text) LIKE UPPER() (SELECT U0... >>> print connection.queries[-1]['sql'] SELECT ""app_category"".""id"", ""app_category"".""title"" FROM ""app_category"" WHERE UPPER(""app_category"".""title""::text) LIKE UPPER() (SELECT U0.""title"" FROM ""app_category"" U0 WHERE U0.""id"" = 1 ) }}} problem with every lookup for which %s is in the middle of connection.operators[lookup] " closed Database layer (models, ORM) 1.2 wontfix sprintdec2010 Unreviewed 1 0 0 0 0 0