Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2021-02-18 18:042021-02-25 14:25
ReporterALopeteguiView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionPR20Q3.1SCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0045922: Extra self-join with main table when using computed columns

DescriptionAdding new hql properties with computed columns, there is an extra join with the main table instead of using the existing one.
Steps To ReproduceAdd a new hql property to master product for example, the query of search product will add an extra join with m_product to use the computed column.
Proposed SolutionIt seems a bug or design defect of hibernate , the way hql makes the query with computed columns.
TagsNOR, Performance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0045919 newrqueralta Retail Modules Extra join of product table in master.product 
related to defect 0044911 closedranjith_qualiantech_com Retail Modules Incremental refresh of Product cannot use index on updated 
related to defect 0045055 closedranjith_qualiantech_com Retail Modules Incremental refresh of ProductCharacteristic cannot use index on updated 
related to defect 0045144 closedprakashmurugesan88 Retail Modules Fix incremental and full refresh with Multi Tax Category module 
related to defect 0045467 closedprakashmurugesan88 Retail Modules Performance issues on the model CharacteristicValue 

-  Notes
shuehner (administrator)
2021-02-22 15:01

There is known cases (fixes several times) that this happens if the HQL of the columns is written poorly.
Typical cases:
- Either adding new from clause for main table again
- 2nd referencing to main table pk via "= object" and not ".id =" which avoids the extra self-join.

Adding as a note as unclear if your concrete case if just +1 of that known topic or a seperate unavoidable one.

- Issue History
Date Modified Username Field Change
2021-02-18 18:04 ALopetegui New Issue
2021-02-18 18:04 ALopetegui Assigned To => platform
2021-02-18 18:04 ALopetegui Modules => Core
2021-02-18 18:04 ALopetegui Triggers an Emergency Pack => No
2021-02-18 18:05 ALopetegui Tag Attached: Performance
2021-02-18 18:16 ALopetegui Steps to Reproduce Updated View Revisions
2021-02-22 10:44 rafaroda Tag Attached: NOR
2021-02-22 10:46 rafaroda Relationship added related to 0045919
2021-02-22 10:47 rafaroda Relationship added related to 0044911
2021-02-22 10:47 rafaroda Relationship added related to 0045055
2021-02-22 10:47 rafaroda Relationship added related to 0045144
2021-02-22 10:48 rafaroda Relationship added related to 0045467
2021-02-22 15:01 shuehner Note Added: 0126272
2021-02-22 15:02 shuehner Issue Monitored: shuehner

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker