Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#27324 closed Cleanup/optimization (fixed)

Simplify get_constraints on Oracle

Reported by: Mariusz Felisiak 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

I propose to remove unnecessary sql with check constraints (​1) and optimization of another one that will return PKs, uniques and checks (​2) in ​get_constraints on Oracle.

Change History (5)

comment:1 by Mariusz Felisiak, 9 years ago

Has patch: set

comment:2 by Simon Charette, 9 years ago

Triage Stage: Unreviewed → Accepted

​PR

comment:3 by Tim Graham, 9 years ago

Triage Stage: Accepted → Ready for checkin

Looks good, pending feedback from anyone interested in Oracle.

comment:4 by Tim Graham <timograham@…>, 9 years ago

Resolution: → fixed
Status: assigned → closed

In 5a772a0:

Fixed #27324 -- Simplified DatabaseIntrospection.get_constraints() on Oracle.

comment:5 by Tim Graham <timograham@…>, 9 years ago

In 2d259e6:

Refs #27324 -- Optimized DatabaseIntrospection.get_constraints() for foreign keys on Oracle.

Note: See TracTickets for help on using tickets.
Back to Top