Using Sqlite as database backend causes list_filter and date_hierarchy misbehave in Admin pages
|Reported by:||amiroff||Owned by:||nobody|
|Component:||Core (Management commands)||Version:||master|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
list_filter and date_hierarchy in Admin do not work properly when using Sqlite as a db backend and filtering by DateField / DateTimeField field types.
To see the bug in action:
- Create a Django project and an app
2 Set sqlite as db backend
- Create a test model with DateTimeField
- Sync the database
- Add some entries.
- Observe how clicking "Today" or "This month" does not reveal the entries that were just created.
- Also, date_hierarchy behaves wierd too, displaying Current month's name and returning no results when clicked.
I came across this bug while following the official tutorial at http://www.djangoproject.com/documentation/tutorial01/
Switching to Mysql as a db backend solves the problem.
Using latest (1.0-beta_1-SVN-8437) SVN checkout
Sqlite bundled with Python 2.5.2
Windows XP Pro SP2