Currently, memsql has auto-increment capabilities to define a synthetic primary key. While it is guaranteed to be unique, it is not sequential.
The non-sequential behavior of auto-increment can causes problems to certain downstream applications which depend on a sequential order and starting from 1 with no gaps.
It would be useful if MemSQL Supported a
create sequence command of some sort to create a sequence that generates unique integer. It can be used to automatically generate primary key values and create a more deterministic behavior.
Note: A member of the MemSQL team has filed this feature request. We are adding in several features to this forum that we believe are popular with our users to engage and better understand the needs of the MemSQL community.