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"

Status

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

5.2.10

Priority

Major
Configure