hibernate_sequence table is missing a PK column.

Description

hibernate_sequence table on MySQL does not define a Primary Key Column on MySQL / MariaDB and Galera cluster (Using GenerationType.AUTO or GenerationType.TABLE)

Every InnoDB Table on Galera needs a primary key, therefore setting Galera "innodb_force_primary_key = 1" is strongly recommended for a fully functional cluster.
See http://galeracluster.com/documentation-webpages/limitations.html#tables-without-primary-keys

If DDL is executed, you will therefore receive error "This table type requires a primary key".

Using GenerationType.IDENTITY is not always possible (db agnostic applications, TABLE_PER_CLASS hierarchy), so this should be fixed.

Environment

MySQL / MariaDB with Galera cluster and required setting "innodb_force_primary_key = 1"

Assignee

Unassigned

Reporter

Robert Oschwald

Fix versions

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Components

Affects versions

Priority

Major
Configure