#26682 closed New feature (fixed)
Support Oracle 12c identity columns
| Reported by: | Emma Arandjelovic | Owned by: | Mariusz Felisiak |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | dev |
| Severity: | Normal | Keywords: | Oracle |
| Cc: | Triage Stage: | Ready for checkin | |
| Has patch: | yes | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Oracle 12c introduced the ability to create an identity column which avoids the need for triggers:
https://oracle-base.com/articles/12c/identity-columns-in-oracle-12cr1
This mechanism performs better than the trigger based approach and is now the recommended best practice. Would it be possible for the migrations framework to support the generation of tables using this new syntax?
Change History (8)
comment:1 by , 9 years ago
| Triage Stage: | Unreviewed → Accepted |
|---|---|
| Version: | 1.9 → master |
comment:3 by , 8 years ago
One option could be adding this as a flag to database settings stating that this uses 12c identity columns.
To handle old triggers I think it would be enough to document upgrade path if someone wants to turn this feature on after some of the models are generated.
comment:4 by , 8 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:6 by , 8 years ago
| Triage Stage: | Accepted → Ready for checkin |
|---|
Note:
See TracTickets
for help on using tickets.
I suppose yes. We'd still have to figure out what to do with the existing tables using triggers.