ArcadeDB: 25.3.1

Preconditions:

1. Up and running ArcadeDB server with available empty database

Steps to reproduce:

1. Open ArcadeDB Studio and execute next commands
2. SQL: CREATE VERTEX TYPE zone;
3. SQL: CREATE PROPERTY zone.id STRING;
4. SQL: CREATE VERTEX TYPE device;
5. SQL: CREATE PROPERTY device.id STRING;
6. SQL: CREATE EDGE TYPE zone_device;
7. SQL: CREATE PROPERTY zone_device.from_id STRING;
8. SQL: CREATE PROPERTY zone_device.to_id STRING;
9. SQL: CREATE INDEX ON zone_device (from_id, to_id) UNIQUE;
10. SQL: CREATE VERTEX zone SET id='zone1';
11. SQL: CREATE VERTEX zone SET id='zone2';
12. SQL: CREATE VERTEX device SET id='device1';
13. SQL: CREATE EDGE zone_device FROM (SELECT FROM zone WHERE id='zone1') TO (SELECT FROM device WHERE id='device1') SET from_id='zone1', to_id='device1';
14. SQL_SCRIPT (Important to run next commands under the same transaction:

DELETE FROM zone_device WHERE from_id='zone1' and to_id='device1';
CREATE EDGE zone_device FROM (SELECT FROM zone WHERE id='zone2') TO (SELECT FROM device WHERE id='device1') SET from_id='zone2', to_id='device1';
CREATE EDGE zone_device FROM (SELECT FROM zone WHERE id='zone1') TO (SELECT FROM device WHERE id='device1') SET from_id='zone1', to_id='device1';

Actual behaviour:
Found duplicate key in index Duplicated key [zone1, device1] found on index 'zone_device[from_id,to_id]' already assigned to record #7:0

Expected behaviour:
Command successfully executed without error.