Repository navigation
Studio doesn't show errors from duplicated key #786
Description
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;
Activity
gramian commentedon Jan 23, 2023
@lvca This also does not work if I do
between
INSERTs.gramian commentedon Jan 29, 2023
This seems to be a studio / console issue(?). So, the unique index seems to work correctly but in case of a single insert no error is reported back. However, the server logs a duplicate entry error.
[-]Unique Index does not error on single non-unique insert[/-][+]Studio doesn't show errors from duplicated key[/+]lvca commentedon Jan 29, 2023
I reopened the issue and changed the name. You're right, the problem is with Studio, or better, with the HTTP layer. The duplicated key is thrown at commit time after the error code 200 is already sent back. What it's needed is a refactoring on that part to send the HTTP response code after the commit.
fix: http api, fixed duplicated exception thrown after http status co…
chore(deps): bump org.apache.maven.plugins:maven-shade-plugin from 3.…
fix: http api, fixed duplicated exception thrown after http status co…
chore(deps): bump org.apache.maven.plugins:maven-shade-plugin from 3.…