add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
NODE_ID ANCESTOR_ID
5 4
5 3
4 3
5 1
4 1
3 1
2 1
[IBM][CLI Driver][DB2/LINUXX8664] SQL0803N  One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "2" constrains table "FIDDLE_MBFLCVJFBAMVJEOWYDNK.PARENT_NODES" from having duplicate values for the index key.  SQLSTATE=23505 SQLCODE=-803
NODE_ID ANCESTOR_ID
5 4
5 3
4 3
5 1
4 1
3 1
2 1
NODE_ID ANCESTOR_ID
5 4
3 1
2 1