Raymond Nathan (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b16054...
) *created* an issue
Hibernate ORM (
https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTQ1ZmJhNDEy...
) / Bug (
https://hibernate.atlassian.net/browse/HHH-15623?atlOrigin=eyJpIjoiNTQ1Zm...
) HHH-15623 (
https://hibernate.atlassian.net/browse/HHH-15623?atlOrigin=eyJpIjoiNTQ1Zm...
) JPA Hibernate float value not taking from Column precision for DDL Generation (
https://hibernate.atlassian.net/browse/HHH-15623?atlOrigin=eyJpIjoiNTQ1Zm...
)
Issue Type: Bug Affects Versions: 6.1.4 Assignee: Unassigned Attachments:
image-20221025-082844.png Components: hibernate-orm-modules Created: 25/Oct/2022 01:30 AM
Environment: Framework -> Spring-Boot 3
DB -> Postgres Priority: Major Reporter: Raymond Nathan (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5b16054...
)
Hi I am getting this error when trying to generate DDL from Entity, only occurring for
Double values with precision 53.
org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create
table <table> (value float (177))" via JDBC Statement
.
.
org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146)
~[spring-boot-3.0.0-RC1.jar:3.0.0-RC1]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:730)
~[spring-boot-3.0.0-RC1.jar:3.0.0-RC1]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:432)
~[spring-boot-3.0.0-RC1.jar:3.0.0-RC1]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:308)
~[spring-boot-3.0.0-RC1.jar:3.0.0-RC1]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1302)
~[spring-boot-3.0.0-RC1.jar:3.0.0-RC1]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1291)
~[spring-boot-3.0.0-RC1.jar:3.0.0-RC1]
at com.Application.main(Application.java:8) ~[classes/:na]
Caused by: org.postgresql.util.PSQLException: ERROR: precision for type float must be less
than 54 bits
As shown here the generated entity (From JOOQ) has the correct precision 53,image
All double precision seems to be translating to 177 bits instead of using the defined 53
bits. We are trying to upgrade from Spring-Boot v2 to v3. This was working fine in Spring
Boot v2.
(
https://hibernate.atlassian.net/browse/HHH-15623#add-comment?atlOrigin=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-15623#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#100209- sha1:9aa9d1d )