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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0023892
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2013-05-23 01:392013-05-27 13:27
ReporteregoitzView Statuspublic 
Assigned Toshankarb 
PriorityimmediateResolutionfixedFixed in Version3.0MP24
StatusclosedFix in branchpiFixed in SCM revisionba62d08c2411
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023892: Index missing on fin_payment_schedule table

DescriptionThe following index is missing:

CREATE INDEX fin_paym_sch_ord_idx
  ON fin_payment_schedule
  USING btree
  (c_order_id );

Steps To ReproduceCheck the tables acceses sequencialy when completing a order before and after create the index
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0058883)
hgbot (developer)
2013-05-23 08:27

Repository: erp/devel/pi
Changeset: ba62d08c24113b9701f063d9d61290755cec8fba
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu May 23 11:07:17 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/ba62d08c24113b9701f063d9d61290755cec8fba [^]

Fixes Issue 23892 : Index missing on Fin_Payment_Schedule table.

Added an index for c_order_id field in Fin_Payment_Schedule table.

---
M src-db/database/model/tables/FIN_PAYMENT_SCHEDULE.xml
---
(0058915)
hudsonbot (developer)
2013-05-24 01:19

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/758b27652865 [^]

Maturity status: Test
(0058952)
AugustoMauch (manager)
2013-05-27 13:27

Code reviewed and verified in pi@20388faf6420

- Issue History
Date Modified Username Field Change
2013-05-23 01:39 egoitz New Issue
2013-05-23 01:39 egoitz Assigned To => AugustoMauch
2013-05-23 01:39 egoitz Modules => Core
2013-05-23 01:39 egoitz Triggers an Emergency Pack => No
2013-05-23 01:39 egoitz Tag Attached: Performance
2013-05-23 06:07 shankarb Assigned To AugustoMauch => shankarb
2013-05-23 08:26 shankarb Review Assigned To => AugustoMauch
2013-05-23 08:26 shankarb Issue Monitored: AugustoMauch
2013-05-23 08:26 shankarb Status new => scheduled
2013-05-23 08:26 shankarb fix_in_branch => pi
2013-05-23 08:27 hgbot Checkin
2013-05-23 08:27 hgbot Note Added: 0058883
2013-05-23 08:27 hgbot Status scheduled => resolved
2013-05-23 08:27 hgbot Resolution open => fixed
2013-05-23 08:27 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/ba62d08c24113b9701f063d9d61290755cec8fba [^]
2013-05-24 01:19 hudsonbot Checkin
2013-05-24 01:19 hudsonbot Note Added: 0058915
2013-05-27 13:27 AugustoMauch Note Added: 0058952
2013-05-27 13:27 AugustoMauch Status resolved => closed
2013-05-27 13:27 AugustoMauch Fixed in Version => 3.0MP24


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker