SimilarQuerySet specifies the field name in an ambiguous manner

[ishirav]

Let's say you do something like:

Person.objects.filter_o(name__similar='Bobby').select_related('Employer')

if the Employer model also has a name field, you'll get an exception:

Exception Value: column reference "name" is ambiguous
LINE 1: SELECT (similarity(name, 'Bobby')) AS "name_distance...

The SimilarQuerySet class does not include the table name when specifying the field to filter on. To solve this problem you need something like this:

    def filter_o(self, **kwargs):
        qs = super(SimilarQuerySet, self).filter(**kwargs)
        for lookup, query in kwargs.items():
            if lookup.endswith('__similar'):
                field =  lookup.replace('__similar', '')
                select = {'%s_distance' % field: "similarity(%s.%s, '%s')" % (self.model._meta.db_table, field, query)}
                qs = qs.extra(select=select).order_by('-%s_distance' % field)
        return qs

(notice the addition of self.model._meta.db_table).

[jleivaizq]

Thanks. It's pretty easy to update.