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

ImplicitCompositeKeyJoinTest#testImplicitCompositeJoin fails due to dialect-specific differences in generated SQL string

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0.4
    • Fix Version/s: 5.0.5
    • Component/s: testsuite
    • Labels:
      None
    • Bug Testcase Reminder (view):

      Bug reports should generally be accompanied by a test case!

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

      Description

      ImplicitCompositeKeyJoinTest#testImplicitCompositeJoin fails due to dialect-specific differences in generated SQL string for Oracle, Sybase, and MySQL.

      Expected SQL:

      create table Employee (age varchar(15) not null, birthday varchar(255) not null, name varchar(20) not null, manager_age varchar(15), manager_birthday varchar(255), manager_name varchar(20), primary key (age, birthday, name))

      oracle12c:
      create table Employee (age varchar2(15 char) not null, birthday varchar2(255 char) not null, name varchar2(20 char) not null, manager_age varchar2(15 char), manager_birthday varchar2(255 char), manager_name varchar2(20 char), primary key (age, birthday, name))

      sybase 15.7
      create table Employee (age varchar(15) not null, birthday varchar(255) not null, name varchar(20) not null, manager_age varchar(15) null, manager_birthday varchar(255) null, manager_name varchar(20) null, primary key (age, birthday, name)) lock datarows

      mysql 5.7
      create table Employee (age varchar(15) not null, birthday varchar(255) not null, name varchar(20) not null, manager_age varchar(15), manager_birthday varchar(255), manager_name varchar(20), primary key (age, birthday, name)) ENGINE=InnoDB

        Attachments

          Issue links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: