Opened 4 years ago

Closed 4 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: master
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 Changed 4 years ago by Akshesh Doshi

Component: MigrationsDatabase layer (models, ORM)
Triage Stage: UnreviewedAccepted

comment:3 Changed 4 years ago by Tim Graham <timograham@…>

Resolution: fixed
Status: newclosed

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