Openbravo Issue Tracking System - Retail Modules |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0045919 | Retail Modules | Web POS | public | 2021-02-18 14:11 | 2021-03-04 12:55 |
|
| Reporter | ALopetegui | |
| Assigned To | rqueralta | |
| Priority | normal | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | RR20Q3.1 | |
| Target Version | | Fixed in Version | RR21Q2 | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Support ticket | |
| 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. |
| Additional Information | |
| Tags | NOR, Performance |
| Relationships | | 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 | | related to | feature request | 0045056 | | new | Retail | Retail Modules | Faster insertion of big amounts of data in full refresh in indexedDB | | has duplicate | defect | 0044911 | | closed | ranjith_qualiantech_com | Retail Modules | Incremental refresh of Product cannot use index on updated | | related to | design defect | 0045922 | | acknowledged | Triage Platform Base | Openbravo ERP | Extra self-join with main table when using computed columns |
|
| Attached Files |  masterProduct.patch (892) 2021-02-18 14:11
https://issues.openbravo.com/file_download.php?file_id=15333&type=bug |
|
| 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 | Resolution time | => 1617400800 |
| 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 |
| 2021-02-24 09:53 | rafaroda | Resolution time | 1617400800 => 1614726000 |
| 2021-02-28 03:34 | hgbot | Note Added: 0126384 | |
| 2021-03-01 07:40 | hgbot | Resolution | open => fixed |
| 2021-03-01 07:40 | hgbot | Status | new => closed |
| 2021-03-01 07:40 | hgbot | Fixed in Version | => RR21Q2 |
| 2021-03-01 07:40 | hgbot | Note Added: 0126397 | |
| 2021-03-01 07:40 | hgbot | Note Added: 0126398 | |
| 2021-03-04 12:55 | rafaroda | Relationship added | related to 0045056 |