July 2020 - hibernate-issues - Jboss List Archives

[JIRA] (HV-1766) Make performance tests compatible with BV 2.0 and BV 3.0

by Guillaume Smet (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14111) Upgrade build dependencies to test JDK15/JDK16

by Yoann Rodière (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14111) Upgrade build dependencies to tests JDK15/JDK16

by Yoann Rodière (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3891) Allow POJO mapper implementations to pass explicit routing keys when indexing

by Fabio Massimo Ercoli (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3966) Configuration properties for merge-on-commit with Lucene 8.6

by Yoann Rodière (JIRA)

Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate Search ( https://hibernate.atlassian.net/browse/HSEARCH?atlOrigin=eyJpIjoiMTU4ODZi... ) / Improvement ( https://hibernate.atlassian.net/browse/HSEARCH-3966?atlOrigin=eyJpIjoiMTU... ) HSEARCH-3966 ( https://hibernate.atlassian.net/browse/HSEARCH-3966?atlOrigin=eyJpIjoiMTU... ) Configuration properties for merge-on-commit with Lucene 8.6 ( https://hibernate.atlassian.net/browse/HSEARCH-3966?atlOrigin=eyJpIjoiMTU... ) Issue Type: Improvement Assignee: Unassigned Components: backend-lucene Created: 19/Jul/2020 23:13 PM Fix Versions: 6.0.0.Beta-backlog Priority: Major Reporter: Yoann Rodière ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) New in Lucene 8.6: > > > > New: IndexWriter merge-on-commit feature to selectively merge small > segments on commit, subject to a configurable timeout, to improve search > performance by reducing the number of small segments for searching. > > ( https://hibernate.atlassian.net/browse/HSEARCH-3966#add-comment?atlOrigin... ) Add Comment ( https://hibernate.atlassian.net/browse/HSEARCH-3966#add-comment?atlOrigin... ) 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:8ba02c9 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HSEARCH-3965) Upgrade to Lucene 8.6.0

by Yoann Rodière (JIRA)

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-13174) L1 Cache object updating issue

by Stefan Möller (JIRA)

Stefan Möller ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5caa8b8... ) *commented* on HHH-13174 ( https://hibernate.atlassian.net/browse/HHH-13174?atlOrigin=eyJpIjoiMzQ1YT... ) Re: L1 Cache object updating issue ( https://hibernate.atlassian.net/browse/HHH-13174?atlOrigin=eyJpIjoiMzQ1YT... ) Not a solution but a simple workaround: Instead of SELECT u from User u LEFT JOIN FETCH u.childrenList as s WHERE s.id = 1 the query must be SELECT u from User u LEFT JOIN u.childrenList as s JOIN FETCH u.childrenList WHERE s.id = 1 ( https://hibernate.atlassian.net/browse/HHH-13174#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13174#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:d093d11 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-13410) "order_inserts = true" causes FK Violation when inserting with a special case of Unidirectional Relations between 4 Entities

by Gajendra Kumar (JIRA)

Gajendra Kumar ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *commented* on HHH-13410 ( https://hibernate.atlassian.net/browse/HHH-13410?atlOrigin=eyJpIjoiYjcxYm... ) Re: "order_inserts = true" causes FK Violation when inserting with a special case of Unidirectional Relations between 4 Entities ( https://hibernate.atlassian.net/browse/HHH-13410?atlOrigin=eyJpIjoiYjcxYm... ) PR: https://github.com/hibernate/hibernate-orm/pull/3470 ( https://hibernate.atlassian.net/browse/HHH-13410#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-13410#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:d093d11 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14112) Invalid Pagination COUNT query generated with @Inheritance(strategy = InheritanceType.JOINED)

by Ganesh Tiwari (JIRA)

Ganesh Tiwari ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ee7797... ) *updated* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzkxM2E3NmUw... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14112?atlOrigin=eyJpIjoiYzkxM2... ) HHH-14112 ( https://hibernate.atlassian.net/browse/HHH-14112?atlOrigin=eyJpIjoiYzkxM2... ) Invalid Pagination COUNT query generated with @Inheritance(strategy = InheritanceType.JOINED) ( https://hibernate.atlassian.net/browse/HHH-14112?atlOrigin=eyJpIjoiYzkxM2... ) Change By: Ganesh Tiwari ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ee7797... ) This bug might be related to [ https://hibernate.atlassian.net/browse/HHH-13712 |https://hibernate.atlassian.net/browse/HHH-13712] * Whats the issue?* If you run the [ http://localhost:8080/subobj, |http://localhost:8080/subobj,] the select query generates fine. But the count query doesn't contain JOIN statement so making the ' where ( subobject0_1_.DELETED = 0)' clause invalid. ```sql Hibernate: {noformat}// select query --- is valid select subobject0_.id as id1_1_, subobject0_1_.deleted as deleted2_1_, subobject0_.age as age1_0_, subobject0_.name as name2_0_ from sub_object subobject0_ inner join super subobject0_1_ on subobject0_.id=subobject0_1_.id where ( subobject0_1_.DELETED = 0) limit ? Hibernate: //count query does't have join select count(subobject0_.id) as col_0_0_ from sub_object subobject0_ where ( subobject0_1_.DELETED = 0) {noformat} ``` Which results in following exception: ``` {noformat} org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "SUBOBJECT0_1_.DELETED" not found; SQL statement: select count(subobject0_.id) as col_0_0_ from sub_object subobject0_ where ( subobject0_1_.DELETED = 0) [42122-200] {noformat} ``` * How to reproduce:* Clone and run [ https://github.com/gtiwari333/hibernate-inheritance-JOINED-with-where-bug |https://github.com/gtiwari333/hibernate-inheritance-JOINED-with-where-bug] then open [ http://localhost:8080/subobj |http://localhost:8080/subobj] on your browser * Notes:* * - It appears the issue is only with InheritanceType.JOINED. Other types works fine (see ``bug.entity.Super.java``) * * No issue when hibernate.version = 5.4.4.Final * Stackoverflow question: [ https://stackoverflow.com/questions/62826016/spring-data-jpa-page-does-no... |https://stackoverflow.com/questions/62826016/spring-data-jpa-page-does-not-work-when-the-entity-has-a-soft-delete-and-is-in] * Related JIRA issue [ https://hibernate.atlassian.net/browse/HHH-13712?jql=text%20~%20%22Inheri... |https://hibernate. atlassian.net/browse/HHH-13712?jql=text%20~%20%22Inheritance%20count%20wh...]. Looks like its not fixed for JOINED with @Where * AST for both issues AST for select query ``` {noformat} 2020-07-17 13:46:53.856 DEBUG 15860 --- [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : --- SQL AST --- \-[SELECT] QueryNode: 'SELECT' querySpaces (super,sub_object) +-[SELECT_CLAUSE] SelectClause: '{select clause}' | +-[ALIAS_REF] IdentNode: 'subobject0_.id as id1_1_' {alias=generatedAlias0, className=bug.entity.SubObject, tableAlias=subobject0_} | \-[SQL_TOKEN] SqlFragment: 'subobject0_1_.deleted as deleted2_1_, subobject0_.age as age1_0_, subobject0_.name as name2_0_' +-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[generatedAlias0], fromElementByTableAlias=[subobject0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]} | \-[FROM_FRAGMENT] FromElement: 'sub_object subobject0_ inner join super subobject0_1_ on subobject0_.id=subobject0_1_.id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=generatedAlias0,role=null,tableName=sub_object,tableAlias=subobject0_,origin=null,columns={,className=bug.entity.SubObject}} \-[WHERE] SqlNode: 'WHERE' \-[FILTERS] SqlNode: '{filter conditions}' \-[SQL_TOKEN] SqlFragment: '( subobject0_1_.DELETED = 0)' ``` {noformat} AST for count query ``` {noformat} 2020-07-17 13:46:53.895 DEBUG 15860 --- [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : --- SQL AST --- \-[SELECT] QueryNode: 'SELECT' querySpaces (super,sub_object) +-[SELECT_CLAUSE] SelectClause: '{select clause}' | +-[COUNT] CountNode: 'count' | | \-[ALIAS_REF] IdentNode: 'subobject0_.id' {alias=generatedAlias0, className=bug.entity.SubObject, tableAlias=subobject0_} | \-[SELECT_COLUMNS] SqlNode: ' as col_0_0_' +-[FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[generatedAlias0], fromElementByTableAlias=[subobject0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]} | \-[FROM_FRAGMENT] FromElement: 'sub_object subobject0_' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=generatedAlias0,role=null,tableName=sub_object,tableAlias=subobject0_,origin=null,columns={,className=bug.entity.SubObject}} \-[WHERE] SqlNode: 'WHERE' \-[FILTERS] SqlNode: '{filter conditions}' \-[SQL_TOKEN] SqlFragment: '( subobject0_1_.DELETED = 0)' ``` {noformat} ( https://hibernate.atlassian.net/browse/HHH-14112#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14112#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:d093d11 )

3 years, 11 months

1
0
0 / 0

[JIRA] (HHH-14112) Invalid Pagination COUNT query generated with @Inheritance(strategy = InheritanceType.JOINED)

by Ganesh Tiwari (JIRA)

Ganesh Tiwari ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ee7797... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiOTYyYjE4ZTZm... ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14112?atlOrigin=eyJpIjoiOTYyYj... ) HHH-14112 ( https://hibernate.atlassian.net/browse/HHH-14112?atlOrigin=eyJpIjoiOTYyYj... ) Invalid Pagination COUNT query generated with @Inheritance(strategy = InheritanceType.JOINED) ( https://hibernate.atlassian.net/browse/HHH-14112?atlOrigin=eyJpIjoiOTYyYj... ) Issue Type: Bug Assignee: Unassigned Components: hibernate-core Created: 17/Jul/2020 12:14 PM Priority: Major Reporter: Ganesh Tiwari ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5ee7797... ) This bug might be related to https://hibernate.atlassian.net/browse/HHH-13712 * Whats the issue?* If you run the http://localhost:8080/subobj , the select query generates fine. But the count query doesn't contain JOIN statement so making the ' where ( subobject0_1_.DELETED = 0)' clause invalid. ```sql Hibernate: select subobject0_.id as id1_1_, subobject0_1_.deleted as deleted2_1_, subobject0_.age as age1_0_, subobject0_.name as name2_0_ from sub_object subobject0_ inner join super subobject0_1_ on subobject0_.id=subobject0_1_.id where ( subobject0_1_.DELETED = 0) limit ? Hibernate: select count(subobject0_.id) as col_0_0_ from sub_object subobject0_ where ( subobject0_1_.DELETED = 0) ``` Which results in following exception: ``` org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "SUBOBJECT0_1_.DELETED" not found; SQL statement: select count(subobject0_.id) as col_0_0_ from sub_object subobject0_ where ( subobject0_1_.DELETED = 0) [42122-200] ``` * How to reproduce:* Clone and run https://github.com/gtiwari333/hibernate-inheritance-JOINED-with-where-bug then open http://localhost:8080/subobj on your browser * Notes:* * - It appears the issue is only with InheritanceType.JOINED. Other types works fine (see ``bug.entity.Super.java``) * * No issue when hibernate.version = 5.4.4.Final * Stackoverflow question: https://stackoverflow.com/questions/62826016/spring-data-jpa-page-does-no... * Related JIRA issue https://hibernate.atlassian.net/browse/HHH-13712?jql=text%20~%20%22Inheri.... Looks like its not fixed for JOINED with @Where * AST for both issues AST for select query ``` 2020-07-17 13:46:53.856 DEBUG 15860 — [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : — SQL AST — - [SELECT] QueryNode: 'SELECT' querySpaces (super,sub_object) +- [SELECT_CLAUSE] SelectClause: ' {select clause}' | +- [ALIAS_REF] IdentNode: 'subobject0_.id as id1_1_' {alias=generatedAlias0, className=bug.entity.SubObject, tableAlias=subobject0_} | - [SQL_TOKEN] SqlFragment: 'subobject0_1_.deleted as deleted2_1_, subobject0_.age as age1_0_, subobject0_.name as name2_0_' +- [FROM] FromClause: 'from' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[generatedAlias0], fromElementByTableAlias=[subobject0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]} | - [FROM_FRAGMENT] FromElement: 'sub_object subobject0_ inner join super subobject0_1_ on subobject0_.id=subobject0_1_.id' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=generatedAlias0,role=null,tableName=sub_object,tableAlias=subobject0_,origin=null,columns={,className=bug.entity.SubObject}} - [WHERE] SqlNode: 'WHERE' - [FILTERS] SqlNode: '{filter conditions}' - [SQL_TOKEN] SqlFragment: '( subobject0_1_.DELETED = 0)' ``` AST for count query ``` 2020-07-17 13:46:53.895 DEBUG 15860 — [nio-8080-exec-1] o.h.h.internal.ast.QueryTranslatorImpl : — SQL AST — - [SELECT] QueryNode: 'SELECT' querySpaces (super,sub_object) +- [SELECT_CLAUSE] SelectClause: '{select clause} ' +- [COUNT] CountNode: 'count' - [ALIAS_REF] IdentNode: 'subobject0_.id' {alias=generatedAlias0, className=bug.entity.SubObject, tableAlias=subobject0_} - [SELECT_COLUMNS] SqlNode: ' as col_0_0_' +- [FROM] FromClause: 'from' FromClause {level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[generatedAlias0], fromElementByTableAlias=[subobject0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]} - [FROM_FRAGMENT] FromElement: 'sub_object subobject0_' FromElement Unknown macro: {explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=generatedAlias0,role=null,tableName=sub_object,tableAlias=subobject0_,origin=null,columns={,className=bug.entity.SubObject}} - [WHERE] SqlNode: 'WHERE' - [FILTERS] SqlNode: ' {filter conditions} ' - [SQL_TOKEN] SqlFragment: '( subobject0_1_.DELETED = 0)' ``` ( https://hibernate.atlassian.net/browse/HHH-14112#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14112#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:d093d11 )

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