Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0043264 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | always | 2020-02-19 13:40 | 2020-02-26 10:49 | |||
| Reporter | ALopetegui | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 3.0PR20Q2 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | b130c2f44f08 | ||||
| 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 | dmiguelez | |||||||
| OBNetwork customer | Gold | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0043264: Duplicate Indexes in some core table definitions | |||||||
| Description | There are some core tables which have duplicate index because the column indexed, is also indexed in other combined columns on first position. The first element in a combined column, have the same effect as individual index. | |||||||
| Steps To Reproduce | This is the list of duplicate index detected: ./database/model/tables/C_ORDER.xml "c_order_docno" btree (documentno) "c_order_documentno_id" btree (documentno, c_order_id) ./database/model/tables/M_INOUT.xml "m_inout_bp_movementdate" btree (c_bpartner_id, movementdate) "m_inout_bpartner" btree (c_bpartner_id) ./database/model/tables/M_COSTING.xml "m_costing_m_product_id" btree (m_product_id) "m_costing_product_date" btree (m_product_id, datefrom, dateto) ./database/model/tables/C_PERIODCONTROL.xml "c_periodcontrol_docbase" btree (c_period_id, docbasetype, ad_org_id) "c_periodcontrol_period" btree (c_period_id) "c_periodcontrol_periodorg" btree (c_period_id, ad_org_id) ./database/model/tables/MRP_RUN_PURCHASELINE.xml "mrp_run_purchline_purchase_id" btree (mrp_run_purchase_id) "mrp_run_purhcline_purch_prod" btree (mrp_run_purchase_id, m_product_id) ./database/model/tables/MRP_RUN_PRODUCTIONLINE.xml "mrp_productionline_id_prod_id" btree (mrp_run_production_id, m_product_id) "mrp_run_prodline_production_id" btree (mrp_run_production_id) ./database/model/tables/M_OFFER_BPARTNER.xm "m_offer_bpartner_cbpartner_id" btree (m_offer_id, c_bpartner_id, m_offer_bpartner_id) "m_offerbp_offer_idx" btree (m_offer_id) | |||||||
| Proposed Solution | Delete individual indexes, because the combined index having the column in the first position, produces the same index. Attached diff solution. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  duplicateIndexes.diff [^] (4,725 bytes) 2020-02-19 13:40 [Show Content]
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0118111) hgbot (developer) 2020-02-26 10:46 |
Repository: erp/devel/pi Changeset: b130c2f44f08e45ad23da49db0904f643e5a6282 Author: Atul Gaware <atul.gaware <at> openbravo.com> Date: Thu Feb 20 23:28:00 2020 +0530 URL: http://code.openbravo.com/erp/devel/pi/rev/b130c2f44f08e45ad23da49db0904f643e5a6282 [^] Fixes BUG-0043264:Duplicate Indexes in some core table definitions **Remove duplicate indexes for **Documentno in C_ORDER **C_Period_ID in C_PERIODCONTROL **MRP_RUN_PRODUCTION_ID in MRP_RUN_PRODUCTIONLINE **MRP_RUN_PURCHASE_ID in MRP_RUN_PURCHASELINE **M_PRODUCT_ID in M_COSTING **C_BPARTNER_ID in M_INOUT **M_OFFER_ID in M_OFFER_BPARTNER --- M src-db/database/model/tables/C_ORDER.xml M src-db/database/model/tables/C_PERIODCONTROL.xml M src-db/database/model/tables/MRP_RUN_PRODUCTIONLINE.xml M src-db/database/model/tables/MRP_RUN_PURCHASELINE.xml M src-db/database/model/tables/M_COSTING.xml M src-db/database/model/tables/M_INOUT.xml M src-db/database/model/tables/M_OFFER_BPARTNER.xml --- |
|
(0118114) dmiguelez (viewer) 2020-02-26 10:49 |
Code Review + Testing Ok |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2020-02-19 13:40 | ALopetegui | New Issue | |
| 2020-02-19 13:40 | ALopetegui | Assigned To | => platform |
| 2020-02-19 13:40 | ALopetegui | File Added: duplicateIndexes.diff | |
| 2020-02-19 13:40 | ALopetegui | OBNetwork customer | => Gold |
| 2020-02-19 13:40 | ALopetegui | Modules | => Core |
| 2020-02-19 13:40 | ALopetegui | Triggers an Emergency Pack | => No |
| 2020-02-19 13:45 | ALopetegui | Summary | Duplicate Indexes in some core tables definition => Duplicate Indexes in some core table definitions |
| 2020-02-20 14:24 | AtulOpenbravo | Status | new => scheduled |
| 2020-02-20 14:24 | AtulOpenbravo | Assigned To | platform => AtulOpenbravo |
| 2020-02-26 10:46 | hgbot | Checkin | |
| 2020-02-26 10:46 | hgbot | Note Added: 0118111 | |
| 2020-02-26 10:46 | hgbot | Status | scheduled => resolved |
| 2020-02-26 10:46 | hgbot | Resolution | open => fixed |
| 2020-02-26 10:46 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/b130c2f44f08e45ad23da49db0904f643e5a6282 [^] |
| 2020-02-26 10:49 | dmiguelez | Review Assigned To | => dmiguelez |
| 2020-02-26 10:49 | dmiguelez | Note Added: 0118114 | |
| 2020-02-26 10:49 | dmiguelez | Status | resolved => closed |
| 2020-02-26 10:49 | dmiguelez | Fixed in Version | => 3.0PR20Q2 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |