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
1027
April 21, 2021 05:38AM
Re: About AUTO-INC In different mode (1,2 or 3)
404
April 21, 2021 10:13AM
402
April 21, 2021 11:50PM
373
April 22, 2021 12:13AM
414
April 22, 2021 02:31AM
372
April 22, 2021 07:30AM
423
April 22, 2021 09:56AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.