Ticket #272 (closed defect: fixed)

Opened 6 years ago

Last modified 4 years ago

Changing column type results in "no changed found" on SQLite

Reported by: daniel@… Owned by: andrew
Priority: major Milestone: 0.7
Component: commands Version: 0.6
Keywords: Cc:


Changing certain field types in a valid way while using SQLite can generate a ValueError: no changed found exception. How I ran into this was changing a IntegerField to a FloatField. SQLite just treats the column as numeric, so it detects no difference. On Postgres, this migration works correctly.

Change History

comment:1 Changed 6 years ago by andrew

  • Status changed from new to assigned
  • Milestone set to 0.7

That looks to be a bug in the SQLite library - it has to manually do a whole series of things to get an ALTER's effects to actually work.

I'll stick this on the list to be fixed - hopefully our sqlite backend rewrite will fix it.

comment:2 Changed 6 years ago by andrew

  • Status changed from assigned to closed
  • Resolution set to fixed

This should be working now on the new SQLite backend we have in 0.7.

Note: See TracTickets for help on using tickets.