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

Relationships [ Relation Graph ] [ Dependency Graph ]

related to	defect	0045919	new	rqueralta	Retail Modules	Extra join of product table in master.product
related to	defect	0044911	closed	ranjith_qualiantech_com	Retail Modules	Incremental refresh of Product cannot use index on updated
related to	defect	0045055	closed	ranjith_qualiantech_com	Retail Modules	Incremental refresh of ProductCharacteristic cannot use index on updated
related to	defect	0045144	closed	prakashmurugesan88	Retail Modules	Fix incremental and full refresh with Multi Tax Category module
related to	defect	0045467	closed	prakashmurugesan88	Retail Modules	Performance issues on the model CharacteristicValue

Notes
(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.