Ticket #8039: bug.py

#encoding= utf-8
from django.db import models
from django.contrib.auth.models import User

Order(models.Model):
    created_by = models.ForeignKey(User)
    text = models.TextField()

searchstring = 'Lara' #some user that exists and has orders

orders = Order.objects.all()
orders = orders.extra(where=[u"((first_name||' '||last_name) ILIKE '%%'|| %s ||'%%' or username = %s)",
                                             u"(auth_user.id = core_order.created_by_id OR auth_user.id = core_order.last_modified_by_id)"],
                                      params=[searchstring, searchstring],
                                      tables=['auth_user'])

print orders.query.as_sql()
orders = orders.order_by('-created_by')

print orders #This works fine

orders = Order.objects.all()
orders = orders.extra(where=[u"((first_name||' '||last_name) ILIKE '%%'|| %s ||'%%' or username = %s)",
                                             u"(auth_user.id = core_order.created_by_id OR auth_user.id = core_order.last_modified_by_id)"],
                                      params=[searchstring, searchstring],
                                      tables=['auth_user'])
#Omitting as_sql() this time
orders = orders.order_by('-created_by')

print orders
Traceback (most recent call last):
  File "<console>", line 1, in <module>
...
ProgrammingError: column "first_name" does not exist
LINE 1: ..."."last_modified_by_id" FROM "core_order" WHERE ((first_name...