Unique constraint

CrateDB SQL
1

How do I define a unique constraint that is not the primary key (aka alternate keys)? Converting from MariaDB…

 id              BIGINT             PRIMARY KEY,
 logonId         VARCHAR(100)       NOT NULL,
 firstName       VARCHAR(60),
 middleName      VARCHAR(40),
 lastName        VARCHAR(60),

 UNIQUE IX_Users_LogonId (logonId),
 UNIQUE IX_Users_Name (lastName, firstName, middleName)

In this use case, I have a primary key that is generated. Their logonId and name must be unique.

1 Like
2

Hi @openstandards

Unfortunately we don’t support unique constraints right now. This is a trade off a fully distributed database :confused:

also see Unique Index · Issue #10279 · crate/crate · GitHub.