go-sqlite3 icon indicating copy to clipboard operation
go-sqlite3 copied to clipboard

Upgrade built-in SQLite version to 3.35.0 to support ALTER TABLE DROP COLUMN

Open c9845 opened this issue 4 years ago • 2 comments

SQLite update 3.35.0 (2021-03-12) supports the ALTER TABLE DROP COLUMN query. See links for info below. This is a pretty huge change in SQLite behavior and brings it inline with other SQL engines.

https://sqlite.org/changes.html https://sqlite.org/lang_altertable.html#altertabdropcol

c9845 avatar Mar 17 '21 15:03 c9845

https://github.com/mattn/go-sqlite3/pull/926

otoolep avatar Mar 17 '21 15:03 otoolep

Version 3.35.5 fixes a database corruption defect related to the newly added ALTER TABLE DROP COLUMN support.

https://sqlite.org/releaselog/3_35_5.html

It would be excellent to have this version supported by go-sqlite3.

Thanks!

tobbe303 avatar Jun 02 '21 15:06 tobbe303

Has this problem been fixed? @mattn Thank you in advance for the answer!

TsvetkovP avatar Sep 10 '22 10:09 TsvetkovP

Yes.

c9845 avatar Sep 10 '22 14:09 c9845