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
1226
April 21, 2021 05:38AM
Re: About AUTO-INC In different mode (1,2 or 3)
447
April 21, 2021 10:13AM
448
April 21, 2021 11:50PM
411
April 22, 2021 12:13AM
465
April 22, 2021 02:31AM
417
April 22, 2021 07:30AM
456
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.