On 06/17/2017 12:56 PM, Robert M. Münch wrote:
Hi, if the DB scheme was changed with ATLER TABLE (like adding a column to a table) it's no longer possible to apply a changeset from before this ALTER TABLE change.
I think that changed for ALTER TABLE ADD COLUMN in 3.17.0. As of 3.17, if the changeset contains fewer columns than the database tables it is being applied to, trailing columns are populated with their default values.
If I'm reverting this ALTER TABLE change manually somehow, would it be possible to apply the changeset then? Or does SQLite count scheme changes incrementally, so that even then it's not possible to apply the changeset?
It would be possible. When applying a changeset, sessions just checks that the target table has the same number or more columns than the table the changeset was generated for, and that the PK columns are all present and in the same positions.
Dan.
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
