New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

oracle id sequence trigger does not handle manual id inserts #906

helios1138 opened this Issue Jul 23, 2015 · 0 comments


None yet
1 participant

helios1138 commented Jul 23, 2015

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.

@elhigu elhigu closed this in #1526 Sep 12, 2016

elhigu added a commit that referenced this issue Sep 12, 2016

Fix #906 Oracle auto increment manual insert id (#1526)
* Oracle sequence trigger handle manual id inserts

* Update schema tests
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment