[MDEV-17503] CREATE SEQUENCE failed with innodb_force_primary_key =1 Created: 2018-10-19  Updated: 2020-08-25  Resolved: 2018-10-29

Status: Closed
Project: MariaDB Server
Component/s: Sequences
Affects Version/s: 10.3
Fix Version/s: 10.3.11

Type: Bug Priority: Critical
Reporter: Richard Stracke Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: None


 Description   

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.

 Comments   
Comment by Michael Widenius [ 2018-10-29 ]

Fixed by introducing HA_WANTS_PRIMARY_KEY

Generated at Thu Feb 08 08:36:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.