SQLite 3.36.0 update [...] re: "ALTER TABLE DROP COLUMN may corrupt data"

[brodybits]

updated:

SQLite 3.3.6.0 should resolve this potential corruption issue, according to this: https://sqlite.org/forum/forumpost/ac6086ecde66f1c4?t=h

P.S. It now looks to me like they did fix this for SQLite 3.35.5 as well, I have added another comment to the SQLite forum thread.

---

I discovered this ticket today: https://www.sqlite.org/src/tktview?name=c88f3036a2

While I think it is not likely to affect too many users, I would very strongly favor anything we can do to avoid the data corruption risks.

I can think of 2 possible mitigations, which would be breaking changes:

• roll back to an older version of SQLite such as 3.34.1 ... which may leave out some bug fixes as well
• disable DROP COLUMN in the SQLite amalgamation ... perhaps using something like #if 0 or #ifdef

some references:

• https://sqlite.org/chronology.html
• https://www.sqlite.org/src/tktview?name=c88f3036a2
• https://www.sqlite.org/src/rptview?rn=1 - all SQLite tickets

---

outdated:

P.S. I am planning to implement a migration in the near future as I really do not like the data corruption risk, as minor as it may be.

I am extremely hopeful that it may be possible to help get this resolved in SQLite itself in the near future as well.

[brodybits]

I just followed up on the forum in this post: https://sqlite.org/forum/forumpost/6485501bbe

Hello is there anything we can do to help get this resolved?

I would also be grateful if there could be a flag such as SQLITE_OMIT_DROP_COLUMN.

Thanks!

[brodybits]

This update is now done in the default (master) branch, still need to update some other plugin versions

[brodybits]

This update is in cordova-sqlite-evcore-extbuild-free version 0.15.1, update is highly recommended, closing now.