Skip to content

Support NULLS NOT DISTINCT #115836

@kylepl

Description

@kylepl

Postgres 15 release added support for NULLS NOT DISTINCT.

For instance:

CREATE TABLE IF NOT EXISTS usage_tracking4 (
  a INT PRIMARY KEY,
  b INT,

  UNIQUE NULLS NOT DISTINCT (a, b)
);

this currently fails because of a syntax error, but works fine on Postgres proper.

I tried to see if there was an on-going FR for this, but did not find it.

Jira issue: CRDB-34239

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-sql-pgcompatSemantic compatibility with PostgreSQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)O-communityOriginated from the communityT-sql-queriesSQL Queries Team

    Type

    No type

    Projects

    Status

    Backlog

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions