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 |