Opened 8 years ago

Closed 8 years ago

#26833 closed Bug (fixed)

alter_field() fails to drop indexes on columns with mixed case on Oracle

Reported by: Jon Dufresne Owned by: nobody
Component: Database layer (models, ORM) 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

On fields that set db_column with mixed case, alter_field() fails to drop indexes on Oracle.

Due to Oracle's uppercases_column_names feature, ​get_constraints() returns all columns as lower case. However, alter_field() use of ​_constraint_names() compares the column name as set by db_column. This must be accounted for on Oracle for the index to be properly dropped.

Change History (3)

comment:2 by Akshesh Doshi, 8 years ago

Component: Migrations → Database layer (models, ORM)
Triage Stage: Unreviewed → Accepted

comment:3 by Tim Graham <timograham@…>, 8 years ago

Resolution: → fixed
Status: new → closed

In 3410820:

Fixed #26833 -- Fixed SchemaEditor._constraint_names() to handle features.uppercases_column_names.

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