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 8218 extra() with params and filter() does not return results valankar@… nobody "I'm seeing some strange behavior with the latest 1.0 alpha when using extra() with params and filter(). Here is an example based on the Polls app created in the tutorial. {{{ >>> from mysite.polls.models import Poll, Choice >>> p = Poll(question=""What's up?"", pub_date=datetime.datetime.now()) >>> p.save() >>> polls = Poll.objects.extra(select={'blah': 'select count(*) from polls_poll where id=%s'}, params=[1]) >>> [p for p in polls] [] >>> [p.blah for p in polls] [1] }}} Looks good so far, but as soon as I add a filter() to it that should return results, I get none: {{{ >>> polls = Poll.objects.extra(select={'blah': 'select count(*) from polls_poll where id=%s'}, params=[1]) >>> polls = polls.filter(question=""What's up?"") >>> [p for p in polls] [] }}} Note that the filter by itself works fine: {{{ >>> polls = Poll.objects.filter(question=""What's up?"") >>> [p for p in polls] [] }}} If I take out the extra() params it also works ok: {{{ >>> polls = Poll.objects.extra(select={'blah': 'select count(*) from polls_poll where id=1'}) >>> polls = polls.filter(question=""What's up?"") >>> [p for p in polls] [] >>> [p.blah for p in polls] [1] }}} It's only when I combine with an extra() AND params that the problem shows up. I am using sqlite3. Thanks. " closed Database layer (models, ORM) dev worksforme extra filter params Unreviewed 0 0 0 0 0 0