SAP ASE picks numbers from a block and only records the block start. On unclean restart the start point is incremented by the block size 1/2
-
-
-
Default size of the block was in the millions which caused all sorts of app fun when identity values became >2^32 after a few restarts 2/2
- 3 more replies
New conversation -
-
-
Best way to fix this bug is FYI upgrade to
#PostgreSQL. With#pgloader it is one command line that you can integrate in your CI/CD.Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
I wonder if
@MariaDB contains the fix or plan to port it?Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Still > postgres.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Fixed in 8.0 only …
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
Their bug site is as reliable as RDBMS itself… BUT MY NEIGHBOUR IS USING MYSQL! That's why you also should! Right? ;))
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
-
-
It could be that Oracle has a bit more competent DB coders. Of course, that is a totally unfounded theory.
Thanks. Twitter will use this to make your timeline better. UndoUndo
-
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.