Create a Unique Key case/accent insensitive to AD_Table.TableName (FHCA-1005)

Description

Create a Unique Key case/accent insensitive to AD_Table.TableName, to prevent problems of 2 records with the same name but different case.

Environment

None

Activity

Show:
Carlos Ruiz
August 1, 2019, 12:19 PM

Added database object name validations to:

  • AD_Element.ColumnName

  • AD_Column.ColumnName

  • AD_Column.FKConstraintName

  • AD_InfoColumn.ColumnName

  • AD_Table.TableName

  • AD_TableIndex.Name

  • AD_ViewColumn.ColumnName

Added UPPER(...Name) indexes to:

  • AD_Table (UPPER(TableName))

  • AD_Column (AD_Table_ID,UPPER(ColumnName))

  • AD_Column (UPPER(FKConstraintName))

  • AD_TableIndex (UPPER(Name))

Fixed

Assignee

Carlos Ruiz

Reporter

Carlos Ruiz

Labels

None

Tested By

None

Priority

Major
Configure