I have a table with an productID column, it is a sequence number. It will increment by 1, cache 50.
I see the last _number is 259259 for this sequencenumber, but if I do a select max(productionID) from mytable , it is 259708, it is entered today.
How come the productionID is already bigger than the last_number?
We did not change the definition of the sequence recently.