August 2022 - hibernate-issues - Jboss List Archives

[JIRA] (HSEARCH-4676) Use .and() syntax by default with .where(BiFunction) and .nested() predicate

by Yoann Rodière (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HSEARCH-4676) Use .and() syntax by default with .where(BiFunction) and .nested() predicate?

by Yoann Rodière (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HSEARCH-4676) Use .and() syntax by default with .where(BiFunction) and .nested() predicate?

by Yoann Rodière (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HHH-304) Subselect fetching with setMaxResults()

by Christian Beikov (JIRA)

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-304 ( https://hibernate.atlassian.net/browse/HHH-304?atlOrigin=eyJpIjoiNzQwY2Q1... ) Re: Subselect fetching with setMaxResults() ( https://hibernate.atlassian.net/browse/HHH-304?atlOrigin=eyJpIjoiNzQwY2Q1... ) I’m not sure it’s a good idea to do this by default as this will only work safely if you use the SNAPSHOT or SERIALIZABLE transaction isolation level. With READ_COMMITTED, new rows might pop into existence between the first query and the subselect fetch (according to the order by clause) which will cause certain collections to be empty. Imagine the simplest case from Order o order by o.id desc limit 1. When orderItems is SUBSELECT fetched, but between the first and the second query a new order is committed, the subselect fetch query will return results that are not related to the originally fetched orders. Now, we could detect this scenario by checking if the result contains keys that have no correspondence and then execute another query, without order by and limit, to make sure we load all the data, but not sure if that is so great. Overall, I think we need to at least discuss the scenario before implementing this. Maybe introduce some config option, I know it sucks, which controls whether we want to ignore the possible READ_COMMITTED issue or not, and by default, handle it transparently in the way I described. ( https://hibernate.atlassian.net/browse/HHH-304#add-comment?atlOrigin=eyJp... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-304#add-comment?atlOrigin=eyJp... ) 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#100206- sha1:1c596f6 )

2 years, 4 months

1
0
0 / 0

[JIRA] (HHH-304) Subselect fetching with setMaxResults()

by Christian Beikov (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HHH-15359) Hibernate doesn't store a @ManyToMany relation when the collection resides in @Embeddable

by Andrea Boriero (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HHH-15454) Primitive type requested from tuple throws exception

by Christian Beikov (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HHH-15453) java.lang.NullPointerException: Cannot invoke "org.hibernate.engine.spi.EntityEntry.getEntityKey()" because "ownerEntry" is null

by Christian Beikov (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HHH-15449) @ManyToOne associations not loaded correctly with default EAGER and batch fetch property set when using TypedQuery.resultStream

by Andrea Boriero (JIRA)

2 years, 4 months

1
0
0 / 0

[JIRA] (HHH-15460) Review use case for disable_delayed_identity_inserts

by Wilson Gee (JIRA)

Wilson Gee ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6305789... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNzFlYjFlYzg4... ) / Task ( https://hibernate.atlassian.net/browse/HHH-15460?atlOrigin=eyJpIjoiNzFlYj... ) HHH-15460 ( https://hibernate.atlassian.net/browse/HHH-15460?atlOrigin=eyJpIjoiNzFlYj... ) Review use case for disable_delayed_identity_inserts ( https://hibernate.atlassian.net/browse/HHH-15460?atlOrigin=eyJpIjoiNzFlYj... ) Issue Type: Task Assignee: Unassigned Created: 23/Aug/2022 18:23 PM Priority: Minor Reporter: Wilson Gee ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=6305789... ) We upgraded from 5.2.17.Final to 5.4.32.Final and discovered an issue with violation of foreign key constraints in MySQL InnoDB tables running 5.7.mysql_aurora.2.09.2. We discovered in the 5.4 Migration Guide ( https://github.com/hibernate/hibernate-orm/blob/5.4/migration-guide.adoc#... ) that we can revert the behavior introduced in 5.3 with the disable_delayed_identity_inserts property and that we should report our use case. > > > > If you find you need to use this configuration setting, be sure to report > the mapping to us in a JIRA issue so that we can review it and determine > if the mapping corner case should be included in our algorithm since the > configuration setting is meant to bridge behavior support for this across > a few releases. > > An example of our logged error: 2022-02-11T21:10:11,699 severity=ERROR class=SqlExceptionHelper Cannot add or update a child row: a foreign key constraint fails (`profiles`.`profile_attributes`, CONSTRAINT `fk_type_namespace_user` FOREIGN KEY (`profile_type`, `namespace_id`, `namespace_user_id`) REFERENCES `profiles` (`profile_type`, `namespace_id`, `n) The table schemas in question (with extraneous details omitted): CREATE TABLE `profiles` ( `profile_type` tinyint(4) NOT NULL, `namespace_id` int(11) NOT NULL, `namespace_user_id` bigint(20) NOT NULL, ... PRIMARY KEY (`profile_type`,`namespace_id`,`namespace_user_id`), ... ) ENGINE=InnoDB DEFAULT CHARSET=utf8 CREATE TABLE `profile_attributes` ( `profile_type` tinyint(4) NOT NULL, `namespace_id` int(11) NOT NULL, `namespace_user_id` bigint(20) NOT NULL, ... PRIMARY KEY (`profile_type`,`namespace_id`,`namespace_user_id`), CONSTRAINT `fk_type_namespace_user` FOREIGN KEY (`profile_type`, `namespace_id`, `namespace_user_id`) REFERENCES `profiles` (`profile_type`, `namespace_id`, `namespace_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ( https://hibernate.atlassian.net/browse/HHH-15460#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15460#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#100205- sha1:4a5192e )

2 years, 4 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

hibernate-issues August 2022