Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
ID | ||||||||||||
0045919 | ||||||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
defect | [Retail Modules] Web POS | major | have not tried | 2021-02-18 14:11 | 2021-02-25 14:25 | |||||||
Reporter | ALopetegui | View Status | public | |||||||||
Assigned To | rqueralta | |||||||||||
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 | RR20Q3.1 | SCM revision | ||||||||||
Review Assigned To | ||||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0045919: Extra join of product table in master.product | |||||||||||
Description | In posterminal master.Product.java 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 Reproduce | In any query of the product search or master data load. | |||||||||||
Proposed Solution | Join OBRETCO_Prol_Product with m_product first, and then left join with images. Patch attached. | |||||||||||
Tags | NOR, Performance | |||||||||||
Attached Files | ![]() | |||||||||||
![]() |
|||||||||||||||||||||||||||||||||||||||||
|
![]() |
|||
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 |