Opened 4 years ago
Closed 4 years ago
#31999 closed Uncategorized (invalid)
Sqlite and datetime aggregates.
Reported by: | Gordon Wrigley | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 3.1 |
Severity: | Normal | Keywords: | |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
With reference to this documentation: https://docs.djangoproject.com/en/3.1/ref/models/querysets/#id5
Specifically "SQLite can’t handle aggregation on date/time fields out of the box." what does "out of the box" mean?
I ask because this seems to be working perfectly fine for me on Ubuntu with Django 2.0 and up and Python 3.6 and up (I haven't tested on earlier versions of either).
It also worked on Windows with Django 3.1.1, Python 3.8.0 and the version of the Sqlite DLL with JSONField support per https://docs.djangoproject.com/en/3.1/ref/databases/#enabling-json1-extension-on-sqlite
Change History (1)
comment:1 by , 4 years ago
Component: | Uncategorized → Database layer (models, ORM) |
---|---|
Resolution: | → invalid |
Status: | new → closed |
It's still not supported on SQLite, see check_expression_support() and tests.backends.sqlite.tests.Tests.test_aggregation().