July 2020 - hibernate-issues - Jboss List Archives

Mikhail Mayorov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cd931e... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNmMyNzhhMzIw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14105?atlOrigin=eyJpIjoiNmMyNz... ) HHH-14105 ( https://hibernate.atlassian.net/browse/HHH-14105?atlOrigin=eyJpIjoiNmMyNz... ) JoinColumn for composite key requires alphabetical order ( https://hibernate.atlassian.net/browse/HHH-14105?atlOrigin=eyJpIjoiNmMyNz... ) Change By: Mikhail Mayorov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5cd931e... ) h1. Description In the following example JoinColumn annotations are order sensitive: Schema - two tables, one of them has composite key *(name, last_name)*: {code:sql} 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); {code} Entities: {code:java} @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; } {code} 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? h1. Environment Spring Boot 2.3.1.RELEASE Hibernate 5.4.17.Final Postgres 42.2.14 h1. How to reproduce # 1) Download [^joincolumn_demo.zip] # ` 2) {{./mvnw test ` }} - this run should pass # 3) Switch JoinColumn annotations in src/main/java/com/example/demo/Product.java to natural order *name, last_name* the following way: {code:java} @ManyToOne(fetch = FetchType.LAZY, optional = false) @JoinColumn(name = "name") @JoinColumn(name = "last_name") private Profile profile; {code} # ` 4){{./mvnw test ` }} As a result it fails with the error: {noformat} 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 {noformat} ( 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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100133- sha1:cb30471 )

3 years, 11 months

1
0
0 / 0

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

by Mikhail Mayorov (JIRA)

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=EmailN... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100133- sha1:cb30471 )

3 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues July 2020