Re: About AUTO-INC In different mode (1,2 or 3)
Conceivably I might could, but I'd have a hard time finding motivation to fuss so about sequentiality. Autoinc guarantees uniqueness not sequentiality. Sequence is an issue for statement-based replication:
"Statement-based replication requires the consecutive auto-increment lock mode to ensure that auto-increment values are assigned in a predictable and repeatable order for a given sequence of SQL statements, whereas row-based replication is not sensitive to the execution order of SQL statements."
Subject
Views
Written By
Posted
841
April 21, 2021 05:38AM
Re: About AUTO-INC In different mode (1,2 or 3)
347
April 21, 2021 10:13AM
351
April 21, 2021 11:50PM
319
April 22, 2021 12:13AM
350
April 22, 2021 02:31AM
302
April 22, 2021 07:30AM
358
April 22, 2021 09:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.