Uploaded image for project: 'Hibernate ORM'
  1. HHH-11923

hibernate_sequence table is missing a PK column.

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 5.2.10
    • Fix Version/s: None
    • Component/s: hibernate-core
    • Environment:
      MySQL / MariaDB with Galera cluster and required setting "innodb_force_primary_key = 1"
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

    • Last commented by a user?:
      true
    • Sprint:

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              robertoschwald Robert Oschwald
              Participants:
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: