假设我有一个带有 jsonfield 的Django模型：
class Event(models.Model):
data = models.JSONField()
并且我创建以下对象：
event1 = Event.objects.create(data={"key": None})
event2 = Event.objects.create(data={"key": "null"})
在Django 3.2.13中，以下查询返回一些结果：
Event.objects.filter(data__key=Value("null"))
# [event1]
Event.objects.filter(data__key="null")
# [event2]
在Django 4.0.5中，相同的查询返回不同的结果。 ：
Event.objects.filter(data__key=Value("null"))
# [event1, event2]
Event.objects.filter(data__key="null")
# [event1, event2]
django docs 不清楚哪些结果是正确的。我会倾向于V3结果。
知道哪一个是正确的吗？这是V4中的错误吗？我在此处在Django Bug Tracker中提交了一张票：
Let's say I have a Django model with a JSONField:
class Event(models.Model):
data = models.JSONField()
And I create the following objects:
event1 = Event.objects.create(data={"key": None})
event2 = Event.objects.create(data={"key": "null"})
In Django 3.2.13, the following queries return some results:
Event.objects.filter(data__key=Value("null"))
# [event1]
Event.objects.filter(data__key="null")
# [event2]
In Django 4.0.5, the same queries return different results:
Event.objects.filter(data__key=Value("null"))
# [event1, event2]
Event.objects.filter(data__key="null")
# [event1, event2]
The Django docs aren't clear which results are correct. I would lean towards the v3 results.
Any idea which one is correct? Is this a bug in v4? I filed a ticket in the Django bug tracker here: https://code.djangoproject.com/ticket/33820#ticket
发布评论
评论（1）
事实证明，这是Django中的一个错误。有关更多信息，请参见票证： https://code.djangoproject.com/ticket.com/ticket/ticket/ticket/33820#ticket/33820#ticket/33820#ticket
Turns out this is a bug in Django. See the ticket for more information: https://code.djangoproject.com/ticket/33820#ticket