Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0040377 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Retail Modules] Contact Info for Product | major | always | 2019-03-14 10:43 | 2019-03-21 12:42 | |||
Reporter | guillermogil | View Status | public | |||||
Assigned To | ranjith_qualiantech_com | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | RR19Q2 | |||
Status | closed | Fix in branch | Fixed in SCM revision | ec95baab0c31 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | jorge-garcia | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0040377: em_obrcifp_bpartner index should be partial | |||||||
Description | em_obrcifp_bpartner index should be partial. It is currently indexing the whole column although in most of the cases it will be null. | |||||||
Steps To Reproduce | N/A | |||||||
Proposed Solution | See attached patch | |||||||
Tags | Performance | |||||||
Attached Files | 40377.diff [^] (523 bytes) 2019-03-14 10:48 [Show Content] | |||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0110437) hgbot (developer) 2019-03-14 12:38 |
Repository: erp/pmods/org.openbravo.retail.contactinfoforproduct Changeset: ec95baab0c31687906586f063fdd1a02e9d0f015 Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Thu Mar 14 17:08:16 2019 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.contactinfoforproduct/rev/ec95baab0c31687906586f063fdd1a02e9d0f015 [^] Fixed issue 40377 : Added Partial Index for Business Partner column in Contact Info For Product Purpose use table --- M src-db/database/model/modifiedTables/C_ORDERLINE.xml --- |
(0110542) jorge-garcia (reporter) 2019-03-21 12:41 |
Code reviewed and tested |
Issue History | |||
Date Modified | Username | Field | Change |
2019-03-14 10:43 | guillermogil | New Issue | |
2019-03-14 10:43 | guillermogil | Assigned To | => Retail |
2019-03-14 10:43 | guillermogil | Resolution time | => 1554328800 |
2019-03-14 10:43 | guillermogil | Triggers an Emergency Pack | => No |
2019-03-14 10:43 | guillermogil | Tag Attached: Performance | |
2019-03-14 10:48 | guillermogil | File Added: 40377.diff | |
2019-03-14 12:21 | ranjith_qualiantech_com | Assigned To | Retail => ranjith_qualiantech_com |
2019-03-14 12:21 | ranjith_qualiantech_com | Status | new => scheduled |
2019-03-14 12:38 | hgbot | Checkin | |
2019-03-14 12:38 | hgbot | Note Added: 0110437 | |
2019-03-14 12:38 | hgbot | Status | scheduled => resolved |
2019-03-14 12:38 | hgbot | Resolution | open => fixed |
2019-03-14 12:38 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.contactinfoforproduct/rev/ec95baab0c31687906586f063fdd1a02e9d0f015 [^] |
2019-03-21 12:41 | jorge-garcia | Review Assigned To | => jorge-garcia |
2019-03-21 12:42 | jorge-garcia | Note Added: 0110542 | |
2019-03-21 12:42 | jorge-garcia | Status | resolved => closed |
2019-03-21 12:42 | jorge-garcia | Fixed in Version | => RR19Q2 |
Copyright © 2000 - 2009 MantisBT Group |