Skip to content

sql: partial unique indexes and unique expression indexes should be given the _idx suffix, not _key #73556

Open
Open
sql: partial unique indexes and unique expression indexes should be given the _idx suffix, not _key#73556
Labels
C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.E-quick-winLikely to be a quick win for someone experienced.T-sql-queriesSQL Queries Team
@mgartner

Description

@mgartner
mgartner
opened on Dec 7, 2021

In Postgres, anonymous partial unique indexes are given a suffix of _idx. CRDB currently gives these indexes a suffix of _key. We should match Postgres's behavior.

Related to #65825

Jira issue: CRDB-11642

Metadata

Metadata

Assignees

No one assigned

    Labels

    C-bugCode not up to spec/doc, specs & docs deemed correct. Solution expected to change code/behavior.E-quick-winLikely to be a quick win for someone experienced.T-sql-queriesSQL Queries Team

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    SQL Queries
    Status
    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions