ArcadeDB Version: v23.1.1 (build aa687e4/1673895089679/main)

JDK Version: openjdk 11.0.17 2022-10-18

OS: MacOS 12.6

Given a unique index on a property, there is no error posted for a single insert with a duplicate value.

Expected behavior

Error message

Actual behavior

RID is assigned

Steps to reproduce

CREATE DOCUMENT TYPE doc;
CREATE PROPERTY doc.uni LONG;
CREATE INDEX ON doc (uni) UNIQUE;
INSERT INTO doc SET uni = 0;
INSERT INTO doc SET uni = 1;

This does not produce an error:

INSERT INTO doc SET uni = 0;

This produces the expected error:

INSERT INTO doc SET uni = 2;
INSERT INTO doc SET uni = 2;

This does not:

INSERT INTO doc SET uni = 3;
INSERT INTO doc SET uni = 1;