Opened 4 years ago
Closed 3 years ago
#32502 closed Cleanup/optimization (fixed)
Replace SQLite schema table rebuild by ALTER functions when supported
| 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 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 (11)
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 |
comment:7 by , 3 years ago
| Owner: | removed |
|---|---|
| Status: | assigned → new |
comment:8 by , 3 years ago
| Description: | modified (diff) |
|---|
comment:11 by , 3 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
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).