Currently increment ids in oracle are working using trigger and a sequence, but if you manually insert a record with an ID, the sequence is not being updated. So if I insert, say, something with ID:4 into an empty table, next insert will be with ID:2, not ID:5. I think the trigger should be changed so that it also sets the lastId in sequence as max id from inserted records.
The text was updated successfully, but these errors were encountered:
Currently increment ids in oracle are working using trigger and a sequence, but if you manually insert a record with an ID, the sequence is not being updated. So if I insert, say, something with ID:4 into an empty table, next insert will be with ID:2, not ID:5. I think the trigger should be changed so that it also sets the lastId in sequence as max id from inserted records.
The text was updated successfully, but these errors were encountered: