Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0040377
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Contact Info for Productmajoralways2019-03-14 10:432019-03-21 12:42
ReporterguillermogilView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in VersionRR19Q2
StatusclosedFix in branchFixed in SCM revisionec95baab0c31
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tojorge-garcia
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040377: em_obrcifp_bpartner index should be partial

Descriptionem_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 ReproduceN/A
Proposed SolutionSee attached patch
TagsPerformance
Attached Filesdiff file icon 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 (developer)
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 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
Powered by Mantis Bugtracker