-1 on this
I think a sequence number, when used as an ID, should be called only once, and then thrown away even if it is not used.
It may not be a huge coding problem, but it could lead to a huge error, if someones private data was exposed to someone else. Why take the risk? If you have grabbed a number and then released it, why return it? It costs nothing. There are lots of numbers. What about if the number 6 is returned and the high number is already 15? Will the sequence function find 6 and use it again? It would be lots of overhead to find the blank spots, and for what reason?
Re:
"For example, if we add 1, 2, and 3 and then 3 is deleted, auto_increment
will add 4. Our new functionality will add 3 instead (it doesn't keep
track of that stuff). Possible problem? Only if a module developer did not remove all linked material. In other words, a module could have 3 as a linked id because it did not know it was deleted. So it would pull 3's data. Not a huge problem, but one we would have to be wary of while
programming.
|
