Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0045922 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Openbravo ERP] A. Platform | major | have not tried | 2021-02-18 18:04 | 2021-02-25 14:25 | |||||||
Reporter | ALopetegui | View Status | public | |||||||||
Assigned To | platform | |||||||||||
Priority | normal | Resolution | open | Fixed in Version | ||||||||
Status | new | Fix in branch | Fixed in SCM revision | |||||||||
Projection | none | ETA | none | Target Version | ||||||||
OS | Any | Database | Any | Java version | ||||||||
OS Version | Database version | Ant version | ||||||||||
Product Version | PR20Q3.1 | SCM revision | ||||||||||
Review Assigned To | ||||||||||||
Web browser | ||||||||||||
Modules | Core | |||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0045922: Extra self-join with main table when using computed columns | |||||||||||
Description | Adding new hql properties with computed columns, there is an extra join with the main table instead of using the existing one. | |||||||||||
Steps To Reproduce | Add 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 Solution | It seems a bug or design defect of hibernate , the way hql makes the query with computed columns. | |||||||||||
Tags | NOR, Performance | |||||||||||
Attached Files | ||||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||
|
![]() |
|
(0126272) 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 = object.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. |
![]() |
|||
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 |