alter_column on sqlite3 datetime field caused column type to change

[pmclanahan@…]

I altered the default value for a datetime field. The resulting automatic migration contained the following:

# Changing field 'Announcement.pub_date'
# (to signature: django.db.models.fields.DateTimeField())
db.alter_column('areas_announcement', 'pub_date', orm['areas.announcement:pub_date'])

When the migration was run, this was the output:

Running migrations for areas:
 - Migrating forwards to 0003_prefill_html_fields.
 > areas: 0002_add_html_fields
DEBUG - south - south execute "ALTER TABLE "areas_announcement" ADD COLUMN "content_html" text NOT NULL DEFAULT '';" with params "[]"
DEBUG - south - south execute "ALTER TABLE "areas_area" ADD COLUMN "details_html" text NOT NULL DEFAULT '';" with params "[]"
DEBUG - south - south execute "DROP TABLE "areas_announcement";" with params "[]"
DEBUG - south - south execute "ALTER TABLE "areas_announcement_temp" RENAME TO "areas_announcement";" with params "[]"
 > areas: 0003_prefill_html_fields
 - Loading initial data for areas.

After the migration I started seeing errors when trying to edit the announcement models in the admin. Looking at the database I noticed that the "pub_date" column had been changed from a type of "datetime" to a type of "pub_date". Changing the type back manually fixed the issue.

The change I made to the field was from:

pub_date = models.DateTimeField('publication date', blank=True, null=True, editable=False)

to:

pub_date = models.DateTimeField('publication date', default=datetime.datetime.now)

[pmclanahan@…]

This was seen while using rev ae7db65f1d28.

[andrew]

Looks like a problem with our hackish SQLite backend. I'll be rewriting it soon; this should hopefully be fixed when that's done.

[pmclanahan@…]

No problem. SQLite is just my dev db as you may have guessed. I'm sure the PostgreSQL backend will work fine for deploying to production. I'll let you know if not.

Thanks!

Paul

[Frank]

Just to let you know that I have the exact same problem with a UrlField?, which, after changing the max_length attribute, sets the datatype to 'url' (name of my field) instead of varchar. A quick test made me conclude that this also happen to CharField? fields, I am guessing it's the same for every Field type.

[andrew]

The SQLite backend has now been rewritten and fixed in 0.7, and I can't reproduce this, so closing.

[Harry Potter]

Can I clone your article to my blog? Thank you…

<a href="​http://wmoviesonline.com/harry-potter-and-deathly-hallows-2010-watch-online/ "> watch harry potter and deathly hallows free streaming </a>

[Harry Potter]

Can I clone your article to my blog? Thank you…

<a href="​http://wmoviesonline.com/harry-potter-and-deathly-hallows-2010-watch-online/ "> watch harry potter and deathly hallows free streaming </a>