Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0023892 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | have not tried | 2013-05-23 01:39 | 2013-05-27 13:27 | |||
Reporter | egoitz | View Status | public | |||||
Assigned To | shankarb | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | 3.0MP24 | |||
Status | closed | Fix in branch | pi | Fixed in SCM revision | ba62d08c2411 | |||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | AugustoMauch | |||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0023892: Index missing on fin_payment_schedule table | |||||||
Description | The following index is missing: CREATE INDEX fin_paym_sch_ord_idx ON fin_payment_schedule USING btree (c_order_id ); | |||||||
Steps To Reproduce | Check the tables acceses sequencialy when completing a order before and after create the index | |||||||
Tags | Performance | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(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 (viewer) 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 (administrator) 2013-05-27 13:27 |
Code reviewed and verified in pi@20388faf6420 |
![]() |
|||
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 | OBNetwork customer | => Yes |
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 |