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