New subject: [Issue 9679] On mariadb 10.5 the sql for creating the main definitions fails with errno: 150 "Foreign key constraint is incorrectly formed

10 Sep 2021


      https://bugs.openldap.org/show_bug.cgi?id=9679
Issue ID: 9679
           Summary: On mariadb 10.5 the sql for creating the main
                    definitions fails with errno: 150 "Foreign key
                    constraint is incorrectly formed
           Product: OpenLDAP
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: ---
         Component: slapd
          Assignee: bugs@openldap.org
          Reporter: lukav@lukav.com
  Target Milestone: ---
Created attachment 841
  --> https://bugs.openldap.org/attachment.cgi?id=841&action=edit
Attached patch that fixes the issue
When you try to execute
servers/slapd/back-sql/rdbms_depend/mysql/backsql_create.sql in mariadb 10.5
you get an error: Fix Can't create table `ldap`.`ldap_entry_objclasses` (errno:
150 "Foreign key constraint is incorrectly formed")
That is because entry_id column is not declared unsigned as the
ldap_entries(id) column.
This patch fixed the definition.
-- 
You are receiving this mail because:
You are on the CC list for the issue.

[Issue 9679] New: On mariadb 10.5 the sql for creating the main definitions fails with errno: 150 "Foreign key constraint is incorrectly formed