@SequenceGenerator: allocationSize versus INCREMENT BY

I don’t know if the JPA TCK has anything to say about the allocationSize, but the spec document says:

The amount
to increment by when
allocating numbers
from the generator/sequence.

What should hbm2ddl update do in such a case where increment size > allocation size?

This is a pretty special use case for which it IMO is ok to require a user to write/configure a custom optimizer. I don’t think it is very common to intentionally introduce gaps in sequence values. Hope you understand this.