[hibernate-issues] [JIRA] (HHH-14105) JoinColumn for composite key requires alphabetical order

Mikhail Mayorov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cd931e... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzZmYzU3Mjcz... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14105?atlOrigin=eyJpIjoiYzZmYz... ) HHH-14105 ( https://hibernate.atlassian.net/browse/HHH-14105?atlOrigin=eyJpIjoiYzZmYz... ) JoinColumn for composite key requires alphabetical order ( https://hibernate.atlassian.net/browse/HHH-14105?atlOrigin=eyJpIjoiYzZmYz... ) Issue Type: Bug Assignee: Unassigned Attachments: joincolumn_demo.zip Created: 13/Jul/2020 22:48 PM Priority: Major Reporter: Mikhail Mayorov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cd931e... ) *********** Description *********** In the following example JoinColumn annotations are order sensitive: Schema - two tables, one of them has composite key *(name, last_name)* : create table product ( id int primary key not null , name varchar (255) not null , last_name uuid not null ); create table profile ( name varchar (255) not null , last_name uuid not null , age int not null ); alter table profile add constraint profile_pkey primary key ( name , last_name); Entities: @Entity @Table @NoArgsConstructor @AllArgsConstructor @Data public class Profile { @EmbeddedId private Id id; private int age; @Embeddable @NoArgsConstructor @AllArgsConstructor @Data public static class Id implements Serializable { private String name; private UUID lastName; } } @Entity @Table @NoArgsConstructor @AllArgsConstructor @Data public class Product { @Id private int id; @ManyToOne(fetch = FetchType.LAZY, optional = false ) @JoinColumn(name = "name" ) @JoinColumn(name = "last_name" ) private Profile profile; } In Product entity it is impossible to specify a relation with the order of *name* and *last_name*. After debugging I've found it must be alphabetically sorted, i.e. *last_name* and *name*. It would be better to make JoinColumn order independent or depend on natural order at worst, because the order of *name* and *last_name* is everywhere: in schema.sql, in composite key Product.Id. Why does it require alphabetical order? *********** Environment *********** Spring Boot 2.3.1.RELEASE Hibernate 5.4.17.Final Postgres 42.2.14 **************** How to reproduce **************** * Download joincolumn_demo.zip ( https://hibernate.atlassian.net/secure/attachment/49712/49712_joincolumn_... ) * `./mvnw test` - this run should pass * Switch JoinColumn annotations in src/main/java/com/example/demo/Product.java the following way: @ManyToOne(fetch = FetchType.LAZY, optional = false ) @JoinColumn(name = "name" ) @JoinColumn(name = "last_name" ) private Profile profile; * `./mvnw test` As a result it fails with the error: ERROR: column "last_name" is of type uuid but expression is of type character varying Hint: You will need to rewrite or cast the expression ( https://hibernate.atlassian.net/browse/HHH-14105#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14105#add-comment?atlOrigin=ey... ) Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100133- sha1:cb30471 )