Opened 4 years ago
Last modified 3 years ago
#32502 closed Cleanup/optimization
Replace SQLite schema table rebuild by ALTER functions when supported — at Version 6
Reported by: | Simon Charette | Owned by: | Mariusz Felisiak |
---|---|---|---|
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 (last modified by )
Per https://www.sqlite.org/lang_altertable.html
ALTER TABLE RENAME COLUMN
is supported since 3.25 but had issues with unique columns until 3.27ALTER TABLE ADD COLUMN
is supported since 3.2.0 not sure why it wasn't used in the first place since 3.2 was released in 2005? (added in 2f73e5406d54cb8945e187eff302a3a3373350be)ALTER TABLE DROP COLUMN
will be supported by 3.35
This will leave only ALTER COLUMN
and ADD/REMOVE CONSTRAINT
that must be emulated on SQLite 3.35+
Change History (6)
comment:1 by , 4 years ago
Triage Stage: | Unreviewed → Someday/Maybe |
---|---|
Version: | 3.1 → master |
comment:2 by , 4 years ago
Triage Stage: | Someday/Maybe → Accepted |
---|
comment:6 by , 3 years ago
Description: | modified (diff) |
---|---|
Has patch: | unset |
Note:
See TracTickets
for help on using tickets.
Thanks Simon!
Marking as "Someday/Maybe" because it can we fully implemented after 3.35.0 release (such as #32501).