diff options
| author | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2016-12-06 01:12:37 +0100 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2016-12-05 19:12:37 -0500 |
| commit | 2d259e6badf032fbdc41f4a2c96a545a94a9ec91 (patch) | |
| tree | 14117e70e05bcf50ae8291e3d21dce265897a46f /django/db/backends/oracle/introspection.py | |
| parent | d4822148d09d715b742d290383fe642c0b77faba (diff) | |
| download | django-2d259e6badf032fbdc41f4a2c96a545a94a9ec91.tar.gz | |
Refs #27324 -- Optimized DatabaseIntrospection.get_constraints() for foreign keys on Oracle.
Diffstat (limited to 'django/db/backends/oracle/introspection.py')
| -rw-r--r-- | django/db/backends/oracle/introspection.py | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/django/db/backends/oracle/introspection.py b/django/db/backends/oracle/introspection.py index 2d91cc049f..8b5aec7680 100644 --- a/django/db/backends/oracle/introspection.py +++ b/django/db/backends/oracle/introspection.py @@ -220,14 +220,12 @@ class DatabaseIntrospection(BaseDatabaseIntrospection): SELECT cons.constraint_name, LOWER(cols.column_name) AS column_name, - LOWER(rcons.table_name), + LOWER(rcols.table_name), LOWER(rcols.column_name) FROM user_constraints cons INNER JOIN - user_constraints rcons ON cons.r_constraint_name = rcons.constraint_name - INNER JOIN - user_cons_columns rcols ON rcols.constraint_name = rcons.constraint_name + user_cons_columns rcols ON rcols.constraint_name = cons.r_constraint_name LEFT OUTER JOIN user_cons_columns cols ON cons.constraint_name = cols.constraint_name WHERE |