April 2023 - hibernate-issues - Jboss List Archives

[JIRA] (HHH-16321) Hibernate maps NCLOB to ntext on Sybase

by Steve Ebersole (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16321) Hibernate maps NCLOB to ntext on Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16321 ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiNmM5Mz... ) Re: Hibernate maps NCLOB to ntext on Sybase ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiNmM5Mz... ) Actually we don’t have access to the metadata at that point. I’ll need to think about this some more. Worst case we can fall back to streaming like we do currently for non-jTDS ( https://hibernate.atlassian.net/browse/HHH-16321#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16321#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#100223- sha1:cdc0af3 )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Tassilo Karge (JIRA)

Tassilo Karge ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f50ce4... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZDliNjc0NTlh... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiZDliNj... ) HHH-16512 ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiZDliNj... ) Bidirectional OneToOne association produces wrong isNull predicate in criteria query ( https://hibernate.atlassian.net/browse/HHH-16512?atlOrigin=eyJpIjoiZDliNj... ) Change By: Tassilo Karge ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5f50ce4... ) The same fails in Hibernate 5.6 and 6.2 Setup: Two classes A, B declaring a bidirectional OneToOne relation to one another (attributes A.b, B.a), class A declares relation with a join column (named B ) and class B declares relation as mappedBy b. Hibernate 5.6: A query that checks {{isNull('a')}} on B (alias b0) produces the where-clause {{b0.id is null}} instead of joining with A (alias a0, join criterion {{a0.b = b0.id}}) and querying {{a0.id is null}}. When writing a query that checks isNull(A_.b), everything is fine. Hibernate 6.2 A query that checks {{isNull('a')}} on B (alias b0) produces an inner join with A (alias a0, join criterion {{a0.b = b0.id}}) and querying {{a0.id is null}}. The inner join filters all b0 which are not connected to a0. It should be a {{left join}} in order to fulfill the query. ( https://hibernate.atlassian.net/browse/HHH-16512#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16512#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#100223- sha1:cdc0af3 )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16512) Bidirectional OneToOne association produces wrong isNull predicate in criteria query

by Tassilo Karge (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16321) Hibernate maps NCLOB to ntext on Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16321 ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiMTg1OG... ) Re: Hibernate maps NCLOB to ntext on Sybase ( https://hibernate.atlassian.net/browse/HHH-16321?atlOrigin=eyJpIjoiMTg1OG... ) Ugh… https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter... So this comes down to configuration with potential bad juju. Personally I think we should expect this ENABLE_LOB_LOCATORS setting to be enabled (I mean we *are* talking about JDBC here). I’ll see if they properly expose this though JDBC metadata.. ( https://hibernate.atlassian.net/browse/HHH-16321#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16321#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#100223- sha1:cdc0af3 )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16306) CountExpressionTest.testCountDistinctTuple fails on Sybase

by Steve Ebersole (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16314) Skip NativeQueryResultTypeAutoDiscoveryTest#dateTimeTypes for Sybase

by Steve Ebersole (JIRA)

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16514) bad bug resulting from column sorting

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiZjVkOWQ2MjIw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16514?atlOrigin=eyJpIjoiZjVkOW... ) HHH-16514 ( https://hibernate.atlassian.net/browse/HHH-16514?atlOrigin=eyJpIjoiZjVkOW... ) bad bug resulting from column sorting ( https://hibernate.atlassian.net/browse/HHH-16514?atlOrigin=eyJpIjoiZjVkOW... ) Change By: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given: {code:java} @Entity public static class B { @Id @Column(length = 12) String code; @Id @Column(precision = 10, scale = 0) BigDecimal cost; @Id @Enumerated(EnumType.STRING) Enum type; @Id long id; } @Entity public static class A { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id") private int id; @ManyToOne(cascade = CascadeType.PERSIST) B b; }{code} The generated DDL is: {code:sql}create table "EnumTest$B" ( type varchar(255) not null check (type in ('A','B')), id bigint not null, cost numeric(10,0) not null, code varchar(12) not null, primary key (code, cost, id, type) ) create table A ( id integer generated by default as identity, "b_code" varchar(255), "b_cost" bigint, "b_id" numeric(38,2), "b_type" varchar(12), primary key (id) ) alter table if exists A add constraint FK60kjd2qxbg6infjjee27fhvjp foreign key ("b_type", "b_id", "b_cost", "b_code") references "EnumTest$B"{code} which is very wrong in multiple ways! ( https://hibernate.atlassian.net/browse/HHH-16514#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16514#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#100223- sha1:cdc0af3 )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16314) Skip NativeQueryResultTypeAutoDiscoveryTest#dateTimeTypes for Sybase

by Steve Ebersole (JIRA)

Steve Ebersole ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-16314 ( https://hibernate.atlassian.net/browse/HHH-16314?atlOrigin=eyJpIjoiNmRkOT... ) Re: Skip NativeQueryResultTypeAutoDiscoveryTest#dateTimeTypes for Sybase ( https://hibernate.atlassian.net/browse/HHH-16314?atlOrigin=eyJpIjoiNmRkOT... ) Add an additional skip to this test for SybaseDialect. Like the others it does not return a java.sql.Date but a full java.sql.Timestamp ( https://hibernate.atlassian.net/browse/HHH-16314#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16314#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#100223- sha1:cdc0af3 )

1 year, 2 months

1
0
0 / 0

[JIRA] (HHH-16514) bad bug resulting from column sorting

by Gavin King (JIRA)

Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOWI1MmJkYTY1... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-16514?atlOrigin=eyJpIjoiOWI1Mm... ) HHH-16514 ( https://hibernate.atlassian.net/browse/HHH-16514?atlOrigin=eyJpIjoiOWI1Mm... ) bad bug resulting from column sorting ( https://hibernate.atlassian.net/browse/HHH-16514?atlOrigin=eyJpIjoiOWI1Mm... ) Change By: Gavin King ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Given: {code:java} @Entity public static class B { @Id @Column(length = 12) String code; @Id @Column(precision = 10, scale = 0) BigDecimal cost; @Id @Enumerated(EnumType.STRING) Enum type; @Id long id; } @Entity (name = "A") public static class A { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) @Column(name = "id") private int id; @ManyToOne(cascade = CascadeType.PERSIST) B b; }{code} The generated DDL is: {code:sql}create table "EnumTest$B" ( type varchar(255) not null check (type in ('A','B')), id bigint not null, cost numeric(10,0) not null, code varchar(12) not null, primary key (code, cost, id, type) ) create table A ( id integer generated by default as identity, "b_code" varchar(255), "b_cost" bigint, "b_id" numeric(38,2), "b_type" varchar(12), primary key (id) ) alter table if exists A add constraint FK60kjd2qxbg6infjjee27fhvjp foreign key ("b_type", "b_id", "b_cost", "b_code") references "EnumTest$B"{code} which is very wrong in multiple ways! ( https://hibernate.atlassian.net/browse/HHH-16514#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-16514#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#100223- sha1:cdc0af3 )

1 year, 2 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 April 2023