.annotate() turns datetime fields to unicode with sqlite3

[aminc]

I have two models, joined with a ManyToManyField:

class MainModel(models.Model):
    date = models.DateTimeField(auto_now_add=True)
    others = models.ManyToManyField('OtherModel')

class OtherModel(models.Model):
    pass

I set up a sample dataset:

>>> m = MainModel.objects.create()
>>> for i in range(12):
>>> ... m.others.create()

But when I use queryset annotation, my DateTimeField is giving me the raw unicode value:

>>> MainModel.objects.annotate(num_others=Count('others')).get().date
u'2009-09-08 12:54:17.380000'

>>> MainModel.objects.get().date
datetime.datetime(2009, 9, 8, 12, 54, 17, 380000)

These are my sqlite tables:

sqlite> .schema news_mainmodel
CREATE TABLE "news_mainmodel" (
    "id" integer NOT NULL PRIMARY KEY,
    "date" datetime NOT NULL
);
sqlite> .schema news_othermodel
CREATE TABLE "news_othermodel" (
    "id" integer NOT NULL PRIMARY KEY
);

[aminc]

Just for completeness, here is the join table. All three were created using syncdb.

sqlite> .schema news_mainmodel_others
CREATE TABLE "news_mainmodel_others" (
    "id" integer NOT NULL PRIMARY KEY,
    "mainmodel_id" integer NOT NULL REFERENCES "news_mainmodel" ("id"),
    "othermodel_id" integer NOT NULL REFERENCES "news_othermodel" ("id"),
    UNIQUE ("mainmodel_id", "othermodel_id")
);

[Karen Tracey]

This behavior is due to a bug in sqlite3, see #10031. You need to upgrade to a more recent level of sqlite.