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

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2021-02-18 14:112021-02-25 14:25
ReporterALopeteguiView Statuspublic 
Assigned Torqueralta 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionRR20Q3.1SCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0045919: Extra join of product table in master.product

DescriptionIn posterminal class, the regular product hql makes and extra join with the table m_product.

There is a first condition to left join OBRETCO_Prol_Product with productImages through product table, and then there is again a join with product.
Steps To ReproduceIn any query of the product search or master data load.
Proposed SolutionJoin OBRETCO_Prol_Product with m_product first, and then left join with images.

Patch attached.
TagsNOR, Performance
Attached Filespatch file icon masterProduct.patch [^] (892 bytes) 2021-02-18 14:11 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
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 
has duplicate defect 0044911 closedranjith_qualiantech_com Retail Modules Incremental refresh of Product cannot use index on updated 
related to defect 0045922 newplatform Openbravo ERP Extra self-join with main table when using computed columns 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2021-02-18 14:11 ALopetegui New Issue
2021-02-18 14:11 ALopetegui Assigned To => Retail
2021-02-18 14:11 ALopetegui File Added: masterProduct.patch
2021-02-18 14:11 ALopetegui Triggers an Emergency Pack => No
2021-02-18 18:05 ALopetegui Tag Attached: Performance
2021-02-22 00:20 rqueralta Assigned To Retail => rqueralta
2021-02-22 10:44 rafaroda Tag Attached: NOR
2021-02-22 10:46 rafaroda Relationship added related to 0045922
2021-02-22 10:47 rafaroda Relationship added has duplicate 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker