Invalid SQL generated when using list_filter with search_fields

It would seem that it's sensitive to the ordering clause ordering = ('topic', 'team',) works where as ordering = ('team', 'topic', ) does not.

It would also seem the error rears it's head when using ordering = ('topic', 'team',) you then click on the team column to sort.

Checking my other models it seems you can't use list_filter with search_fields at the same time, as in you can't do a search and then click the filter or click the filter then search.

Seems that this might have been fixed at some point along the way.

Using the models:

class Person(models.Model):
    name = models.CharField(maxlength=50)
    
    class Admin:
        pass
    
    def __str__(self):
        return self.name

class Team(models.Model):
    name = models.CharField(maxlength=50)
    
    class Admin:
        pass
    
    def __str__(self):
        return self.name

class Discussion(models.Model):
    topic = models.CharField(maxlength=200)
    body = models.TextField()
    person = models.ForeignKey(Person, null=False)
    team = models.ForeignKey(Team, null=False)
    
    def __str__(self):
       return self.team.__str__() + " thread " + self.topic
    
    class Admin:
       list_per_page = 100
       list_display = ('team', 'topic', 'person', 'body', )
       list_filter = ('team', )
       ordering = ('topic', 'team')
       search_fields = ('body', 'topic')

I don't get any errors when using any combinations of sorting columns, searching, and using the filter.