Skip to content

1.2.2: Relationship name pattern for FK Index Name ignores {sc} tag on simple (single-column) FKs #2044

@jhardin-accumula

Description

@jhardin-accumula

Bug description
Defining the FK index name pattern for a relationship accepts and highlights the {sc} tag, which suggests it will be used, but does not include the column name in the generated index name per the pattern.

How to reproduce

  1. Create a simple (PK is one column) FK relationship
  2. Define the following FK Index Name pattern for a relationship: ix_fk_{dt}_{sc} - the {sc} will be highlighted
  3. Set the Index Type to something other than None so that the relationship creates the index on the destination table
  4. Apply the relationship
  5. Look at the destination table indexes. The index is created but it is named "ix_fk_{tablename}_" - the column name is omitted.

Expected behavior
For a simple (single-column) FK the {sc} tag should resolve to the first column name.
Doing this on a compound (multi-column) FK is undetermined.

Additional info
Workaround: Maintain the index manually

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions