Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#24744 closed Bug (fixed)

Missing relabeled_clone methods are causing fails in subqueries

Reported by: mrAdm Owned by: Andriy Sokolovskiy
Component: contrib.postgres Version: 1.8
Severity: Release blocker Keywords: hstore
Cc: me@… Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no


There are two models:

from django.db import models
from django.contrib.postgres.fields import HStoreField

class A(Model):
    test = models.CharField(max_length=100)
    hstore = HStoreField()

class B(Model):
    a = models.ForeignKey(A)

Execute the query:

print B.objects.filter(a__in=A.objects.filter(hstore__field=1))

I get the following exception:

Traceback (most recent call last):
  File "/vagrant/", line 10, in <module>
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/", line 338, in execute_from_command_line
  File "/usr/local/lib/python2.7/dist-packages/django/core/management/", line 312, in execute
  File "/usr/local/lib/python2.7/dist-packages/django/", line 18, in setup
  File "/usr/local/lib/python2.7/dist-packages/django/apps/", line 115, in populate
  File "/vagrant/st/", line 18, in ready
    print str(B.objects.filter(a__in=A.objects.filter(hstore__field=1)).query)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/", line 127, in manager_method
    return getattr(self.get_queryset(), name)(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/", line 679, in filter
    return self._filter_or_exclude(False, *args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/", line 697, in _filter_or_exclude
    clone.query.add_q(Q(*args, **kwargs))
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/", line 1301, in add_q
    clause, require_inner = self._add_q(where_part, self.used_aliases)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/", line 1328, in _add_q
    current_negated=current_negated, connector=connector, allow_joins=allow_joins)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/", line 1150, in build_filter
    value, lookups, used_joins = self.prepare_lookup_value(value, lookups, can_reuse, allow_joins)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/", line 1007, in prepare_lookup_value
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/", line 868, in bump_prefix
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/", line 792, in change_aliases
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/sql/", line 287, in relabel_aliases
    self.children[pos] = child.relabeled_clone(change_map)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/", line 178, in relabeled_clone
    new.lhs = new.lhs.relabeled_clone(relabels)
  File "/usr/local/lib/python2.7/dist-packages/django/db/models/", line 76, in relabeled_clone
    return self.__class__(self.lhs.relabeled_clone(relabels))
  File "/usr/local/lib/python2.7/dist-packages/django/contrib/postgres/fields/", line 76, in __init__
    super(KeyTransform, self).__init__(*args, **kwargs)
TypeError: __init__() takes exactly 3 arguments (1 given)

Attachments (1)

24744-test.diff (2.3 KB ) - added by Tim Graham 9 years ago.

Download all attachments as: .zip

Change History (15)

comment:1 by Tim Graham, 9 years ago

Severity: NormalRelease blocker
Summary: hstore lookup inside subqueryhstore lookup fails inside subquery
Triage Stage: UnreviewedAccepted

Reproduced with the attached test.

by Tim Graham, 9 years ago

Attachment: 24744-test.diff added

comment:2 by Anssi Kääriäinen, 9 years ago

Seems like a case where KeyTransform will need a custom relabeled_clone method. We should check other new lookups, transforms and expressions to see if they contain this same bug.

This is quite common bug, I have seen a variation of missing or broken relabeled_clone method a dozen times. The aliases of a query are not relabeled for normal queries, so normal testing doesn't spot these issues. The author needs to manually write a test for subquery support, and this is too easy to forget.

Any ideas how we could automate testing of expression-likes so that we automatically check relabeled_clone() support? The optimal solution would be that whenever a new expression-like is introduced, we automatically test that for relabeled_clone(). But this needs some sort of magic autodetection, and I don't have any ideas how we could do this without ugly hacks.

The alternate solution is to always test subquery support manually.

comment:3 by Josh Smeaton, 9 years ago

Any ideas how we could automate testing of expression-likes so that we automatically check relabeled_clone() support?

I've had similar thoughts about when we introduce a new field. What are all the tests that should be written? I've got two ideas. The first would be a test code generator. The better idea would be a test case builder. I'm not sure how feasible either would be though.

So far the "gold standard" for expression tests is in expressions_case. If we can generalise the tests there enough (or copy elsewhere then generalise), we might be able to create a list of expressions, and pass each one into the generalised test case to run through common failure scenarios. Not sure if this is practical though, considering the inputs and outputs to each expression can be wildly different.

comment:4 by Marc Tamlyn, 9 years ago

I would love a better list of all the things we should have (and generally a much more accurate set of lookup/transform/expression to field mappings). A possible answer would be to have a TestCase mixin with many test_foo methods raising NotImplementedError. We may also want a metaclass though to be able to explicitly remove test_bar where the feature bar does not apply, rather than skipping it. This would have the advantage that when you add a test to the base mixin for a new generic lookup/expression/whatever then it gets tested on all field types, and you see the ones it fails on (and on which dbs).

AFAIK there are not relabeled_clone methods in contrib.postgres at present, so any Transform therein which takes args is potentially suspect.

comment:5 by Andriy Sokolovskiy, 9 years ago

Cc: me@… added

So, as a conclusion, the goal is:

  • At first, to create testcase with fields->lookup/transform/expressions mapping
  • Fix problematic fields

, right?

I don't fully understand an idea of "A possible answer would be to have a TestCase mixin with many test_foo methods raising NotImplementedError", if you are proposing to create basic tests with declared mapping.
Or this will be a basic testcase, which will be used in different tests modules?

After we will formalize plan, I want to take this ticket.

comment:6 by Andriy Sokolovskiy, 9 years ago

Summary: hstore lookup fails inside subqueryMissing relabeled_clone methods are causing fails in subqueries

comment:7 by Tim Graham, 9 years ago

I think solving the reported failure would be sufficient for this ticket. We could open a new one for the more general method.

My understanding of the mixin idea is to use mixin that would be used in a test subclass for each expressions to ensure the test writer implements all the basic ways an expression should be tested.

comment:8 by Andriy Sokolovskiy, 9 years ago

Owner: set to Andriy Sokolovskiy
Status: newassigned

comment:9 by Anssi Kääriäinen, 9 years ago

I think the base Transform class is actually broken (see __init__ and relabeled_clone()). So, we really need some safety net for this. Maybe we could test directly the relabeled_clone() method for expressions?

comment:11 by Andriy Sokolovskiy, 9 years ago

After several discussions we decided to not making base mixins for now, because it is not so simple formalize common things for all transfroms/functions/aggregates/etc, so I fixed the actual problem.

comment:12 by Anssi Kääriäinen, 9 years ago

Triage Stage: AcceptedReady for checkin

For now, I think the best we can do is do some documentation for common problematic cases.

The patch looks good to me.

comment:13 by Tim Graham <timograham@…>, 9 years ago

Resolution: fixed
Status: assignedclosed

In 08232ef:

Fixed #24744 - Fixed relabeled_clone for the Transform

comment:14 by Tim Graham <timograham@…>, 9 years ago

In b4b1375:

[1.8.x] Fixed #24744 - Fixed relabeled_clone for the Transform

Backport of 08232ef84d4959826ad5136f183c9fc5bedf0599 from master

Note: See TracTickets for help on using tickets.
Back to Top