auto-increment-offset shouldn't be allowed to be greater than auto-increment-increment
Bug #682967 reported by
Arjen Lentz
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Undecided
|
Unassigned |
Bug Description
Apart from both of these variables not allowed to be 0, auto-increment-
For startup, this could be checked after the config/cmdline params are all processed - this to prevent chucking an error in case they're specified with offset first and increment second.
For live changes, it could be checked on the spot - although I'd question the sense/need of changing such params live.
description: | updated |
To post a comment you must log in.
Hi, Arjen! offset should not be allowed to be greater than increment as that would by definition create an invalid
>
> auto-increment-
> auto-increment-
> scenario.
It is not at all obvious to me that this situation "should not" be
allowed, and that it creates "by definition an invalid scenario".
Somehow I cannot derive A < B from the formula X = A + N*B.
Regards,
Sergei