Opened 5 years ago
Last modified 4 years ago
#32502 closed Cleanup/optimization
Replace SQLite schema table rebuild by ALTER functions when supported — at Initial Version
| Reported by: | Simon Charette | Owned by: | nobody |
|---|---|---|---|
| Component: | Migrations | Version: | dev |
| Severity: | Normal | Keywords: | |
| Cc: | Triage Stage: | Accepted | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Per https://www.sqlite.org/lang_altertable.html
ALTER TABLE RENAME COLUMNis supported since 3.25 but had issues with unique columns until 3.27ALTER TABLE ADD COLUMNis supported since 3.2.0 not sure why it wasn't used in the first place since 3.2 was released in 2005?ALTER TABLE DROP COLUMNwill be supported by 3.35
This will leave only ALTER COLUMN and ADD/REMOVE CONSTRAINT that must be emulated on SQLite 3.35+
Note:
See TracTickets
for help on using tickets.