Greetings all. I hope you are doing well.
I came across very unusual issue with auto increment-ed values whereby it jumped up by 999 instead of 1. I have checked to make sure that column in the table is setup to auto increment and that the seed value is 1 so it should only increment by 1 at a time.
To illustrate the point I had three records in the database with respective ID value of 1, 2 and 3. The next record I inserted gained an ID of 1002!? instead of 4.
Thats not all. I have my code setup so that it creates a content item just before it creates a record in my table. Looking at content item records I have and increment of 995 between two records (1559 to 2554). And Content item metadata records also jumped up from 1228 to 2223 (995).
As funny as it may sound next few records went in just fine with proper increments.
I also haven't noticed anything strange with increment values in Files and Journal tables.
After a quick search I found a few reference where people were having issue with auto incremented values using DAL2. But all I came across pointed to code throwing errors. That is not the case here. Everything is working away happily, no errors, no warnings.
Has anyone else came across this rather strange behaviour with increment values? This the second time I've had this issue. While it is not a game breaker but I'd like to know what I am doing wrong or why this is happening.
BTW I am working with DNN 7.3.1 and DNN 7.3.3