[MDEV-17503] CREATE SEQUENCE failed with innodb_force_primary_key =1 - Jira

SEQUENCE can't created with innodb_force_primary_key =1

set global innodb_force_primary_key =1;

CREATE SEQUENCE s2 START WITH 100 INCREMENT BY 10;

Create with a key or alter is not possible, because
"SQL Error (4086) Seqeuence s2 table structure is invalid
(Sequence tables cannot have any keys"

Only workaround is

set global innodb_force_primary_key =0;

and create the sequence.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server