summaryrefslogtreecommitdiff
path: root/tests/postgres_tests
diff options
context:
space:
mode:
Diffstat (limited to 'tests/postgres_tests')
-rw-r--r--tests/postgres_tests/test_hstore.py8
-rw-r--r--tests/postgres_tests/test_json.py8
2 files changed, 14 insertions, 2 deletions
diff --git a/tests/postgres_tests/test_hstore.py b/tests/postgres_tests/test_hstore.py
index 3ac68e1e69..acad950fbb 100644
--- a/tests/postgres_tests/test_hstore.py
+++ b/tests/postgres_tests/test_hstore.py
@@ -5,7 +5,7 @@ import json
from django.core import exceptions, serializers
from django.db import connection
-from django.db.models.expressions import RawSQL
+from django.db.models.expressions import OuterRef, RawSQL, Subquery
from django.forms import Form
from django.test.utils import CaptureQueriesContext, modify_settings
@@ -189,6 +189,12 @@ class TestQuerying(HStoreTestCase):
queries[0]['sql'],
)
+ def test_obj_subquery_lookup(self):
+ qs = HStoreModel.objects.annotate(
+ value=Subquery(HStoreModel.objects.filter(pk=OuterRef('pk')).values('field')),
+ ).filter(value__a='b')
+ self.assertSequenceEqual(qs, self.objs[:2])
+
class TestSerialization(HStoreTestCase):
test_data = ('[{"fields": {"field": "{\\"a\\": \\"b\\"}"}, '
diff --git a/tests/postgres_tests/test_json.py b/tests/postgres_tests/test_json.py
index ead2c68df7..b8b5dd481f 100644
--- a/tests/postgres_tests/test_json.py
+++ b/tests/postgres_tests/test_json.py
@@ -7,7 +7,7 @@ from decimal import Decimal
from django.core import exceptions, serializers
from django.core.serializers.json import DjangoJSONEncoder
from django.db import connection
-from django.db.models import F
+from django.db.models import F, OuterRef, Subquery
from django.db.models.expressions import RawSQL
from django.db.models.functions import Cast
from django.forms import CharField, Form, widgets
@@ -222,6 +222,12 @@ class TestQuerying(PostgreSQLTestCase):
[self.objs[7], self.objs[8]]
)
+ def test_obj_subquery_lookup(self):
+ qs = JSONModel.objects.annotate(
+ value=Subquery(JSONModel.objects.filter(pk=OuterRef('pk')).values('field')),
+ ).filter(value__a='b')
+ self.assertSequenceEqual(qs, [self.objs[7], self.objs[8]])
+
def test_deep_lookup_objs(self):
self.assertSequenceEqual(
JSONModel.objects.filter(field__k__l='m'),