Chaining KeyTransform with 'contains' lookup uses builtin lookup instead of overridden lookup

[Sage Abdullah]

The previous implementation of django.contrib.postgres.fields.JSONField, when chained with a KeyTransform and a contains lookup, uses the overridden contains lookup that is JSON-based and not the builtin one that is pattern-based.

Using the example model in the 3.1 release notes,

class ContactInfo(models.Model):
    data = models.JSONField()

obj = ContactInfo.objects.create(data={
    'name': 'John',
    'cities': ['London', 'Cambridge'],
    'pets': {'dogs': ['Rufus', 'Meg']},
})
ContactInfo.objects.filter(
    data__cities__contains='Cambridge',
)

The query returns a queryset with obj in it, which is expected.

However, the following query:

ContactInfo.objects.filter(
    data__cities__contains='bridge',
)

Also returns a queryset with obj in it. Using the previous implementation, obj doesn't match the query because contains uses JSON-based containment checking. That is, it checks whether the array in data__cities contains an element that's exactly "bridge".

[Sage Abdullah]

​PR

[Mariusz Felisiak <felisiak.mariusz@…>]

In 2d8dcba0:

Fixed #31829 -- Used JSONField contains lookup on key transforms.

[Mariusz Felisiak <felisiak.mariusz@…>]

In 23ce3d8:

[3.1.x] Fixed #31829 -- Used JSONField contains lookup on key transforms.

Backport of 2d8dcba03aae200aaa103ec1e69f0a0038ec2f85 from master

[GitHub <noreply@…>]

In 184a6eeb:

Refs #31829 -- Added DatabaseFeatures.json_key_contains_list_matching_requires_list.

CockroachDB's behavior matches PostgreSQL.

[Mariusz Felisiak <felisiak.mariusz@…>]

In 32cb1fe1:

[3.1.x] Refs #31829 -- Added DatabaseFeatures.json_key_contains_list_matching_requires_list.

CockroachDB's behavior matches PostgreSQL.
Backport of 184a6eebb0ef56d5f1b1315a8e666830e37f3f81 from master