Modify

Ticket #272 (closed defect: fixed)

Opened 4 years ago

Last modified 3 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:

Description

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.

Attachments

Change History

comment:1 Changed 4 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 4 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.

View

Add a comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.