4 ms·
In case it's not obvious: new auto increment IDs are skipped forever whenever a transaction is rolled back. This isn't really an issue at all but can upset tho
by j_s 9y ago
In case it's not obvious: new auto increment IDs are skipped forever whenever a transaction is rolled back.
This isn't really an issue at all but can upset those with OCD-ish tendencies.
- corobo 9y agothose with OCD-ish tendencies best hope they never lose any customers then.
- btschaegg 9y agoThis. There's so much in software development that relies on guarantees that can only be upheld by behavior like this that I _sincerely_ doubt that anyone having issues with skipped rows is in the right place. There are arguments for and against any technique, but this one seems really ridiculous to me, especially if you consider what any "countermeasure" would do to the code (which is usually much more important than the data in the long run!).
- j_s 9y agoUPDATE tbl SET deleted=1