Opened 5 years ago
Last modified 4 years ago
#32502 closed Cleanup/optimization
Replace SQLite schema table rebuild by ALTER functions when supported — at Version 8
| Reported by: | Simon Charette | Owned by: | |
|---|---|---|---|
| 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 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? (added in 2f73e5406d54cb8945e187eff302a3a3373350be)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+
Change History (8)
comment:1 by , 5 years ago
| Triage Stage: | Unreviewed → Someday/Maybe |
|---|---|
| Version: | 3.1 → master |
comment:2 by , 5 years ago
| Triage Stage: | Someday/Maybe → Accepted |
|---|
comment:6 by , 4 years ago
| Description: | modified (diff) |
|---|---|
| Has patch: | unset |
comment:7 by , 4 years ago
| Owner: | removed |
|---|---|
| Status: | assigned → new |
comment:8 by , 4 years ago
| Description: | modified (diff) |
|---|
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).