Re: [Django] #31755: make temporal subtraction work without ExpressionWrapper
Django
-------------------------------------+-------------------------------------
Reporter: Sergey Fedoseev | Owner: Sergey
| Fedoseev
Type: Uncategorized | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Sergey Fedoseev):
* owner: nobody => Sergey Fedoseev
* status: new => assigned
--
Ticket URL: <https://code.djangoproject.com/ticket/31755#comment:1>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
-------------------------------------+-------------------------------------
Fedoseev |
Type: | Status: new
Uncategorized |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
class Experiment(models.Model):
start = models.DateTimeField()
end = models.DateTimeField()
Experiment.objects.annotate(
delta=F('end') - F('start') + Value(datetime.timedelta(),
output_field=DurationField())
)
}}}
This gives:
{{{
django.core.exceptions.FieldError: Expression contains mixed types:
DateTimeField, DurationField. You must set output_field.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/31755>
Django
-------------------------------------+-------------------------------------
| Fedoseev
Type: Uncategorized | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* stage: Unreviewed => Accepted
Comment:
Hi Sergey. Thanks — yes, it would be nice it that worked.
--
Ticket URL: <https://code.djangoproject.com/ticket/31755#comment:3>
Django
-------------------------------------+-------------------------------------
Type: | Fedoseev
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* type: Uncategorized => Cleanup/optimization
--
Ticket URL: <https://code.djangoproject.com/ticket/31755#comment:4>
Django
-------------------------------------+-------------------------------------
Type: | Fedoseev
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* stage: Accepted => Ready for checkin
--
Ticket URL: <https://code.djangoproject.com/ticket/31755#comment:5>
Django
-------------------------------------+-------------------------------------
Type: | Fedoseev
Component: Database layer | Version: master
(models, ORM) |
Keywords: | Triage Stage: Ready for
| checkin
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* status: assigned => closed
* resolution: => fixed
Comment:
In [changeset:"9d519d3dc4e5bd1d9ff3806b44624c3e487d61c1" 9d519d3]:
{{{
#!CommitTicketReference repository=""
revision="9d519d3dc4e5bd1d9ff3806b44624c3e487d61c1"
Fixed #31755 -- Made temporal subtraction resolve output field.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/31755#comment:6>