"Between" bug when using SQLite?

[Doug Van Horn]

I'm running into a funny issue when testing with SQLite3 (Python 2.5).

I have a model with the following (simplified):

class Event(models.Model):
    event_title = models.CharField()
    event_from_date = models.DateField()

I create an event on 2008-01-01 (January 1st) and on 2008-01-02
(January 2nd).

I run the following in the shell:

In [10]: Event.objects.filter(event_from_date__year=2008)
Out[10]: [<Event: Event on 2nd.>]

In [11]: Event.objects.filter(event_from_date__month=1)
Out[11]: [<Event: Event On 1st.>, <Event: Event on 2nd.>]

In [12]: Event.objects.filter(event_from_date__year=2008,
event_from_date__month=1)
Out[12]: [<Event: Event on 2nd.>]

Here are the queries (I edited out a bunch of other fields from the
select clause, but nothing from the where clause, so they're not
exactly as output from django):

In [18]: connection.queries
Out[18]:
[{'sql': u'SELECT
"app_event"."id","app_event"."event_from_date","app_event"."title"
FROM "app_event" WHERE ("app_event"."event_from_date" BETWEEN
2008-01-01 00:00:00 AND 2008-12-31 23:59:59.999999) ORDER BY
"app_event"."event_from_date" ASC, "app_event"."title" ASC',
  'time': '0.001'},
 {'sql': u'SELECT
"app_event"."id","app_event"."event_from_date","app_event"."title"
FROM "app_event" WHERE (django_extract("month",
"app_event"."event_from_date") = 1) ORDER BY
"app_event"."event_from_date" ASC, "app_event"."title" ASC',
  'time': '0.001'},
 {'sql': u'SELECT
"app_event"."id","app_event"."event_from_date","app_event"."title"
FROM "app_event" WHERE (django_extract("month",
"app_event"."event_from_date") = 1 AND "app_event"."event_from_date"
BETWEEN 2008-01-01 00:00:00 AND 2008-12-31 23:59:59.999999) ORDER BY
"app_event"."event_from_date" ASC, "app_event"."title" ASC',
  'time': '0.001'}]


Could it be that the 'year' predicate is missing the 'django_extract'
function?


Thanks for any help...


Doug Van Horn
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---