Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2020-02-19 13:402020-02-26 10:49
ReporterALopeteguiView Statuspublic 
Assigned ToAtulOpenbravo 
PrioritynormalResolutionfixedFixed in Version3.0PR20Q2
StatusclosedFix in branchFixed in SCM revisionb130c2f44f08
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Todmiguelez
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0043264: Duplicate Indexes in some core table definitions

DescriptionThere 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 ReproduceThis is the list of duplicate index detected:
    "c_order_docno" btree (documentno)
    "c_order_documentno_id" btree (documentno, c_order_id)

    "m_inout_bp_movementdate" btree (c_bpartner_id, movementdate)
    "m_inout_bpartner" btree (c_bpartner_id)

    "m_costing_m_product_id" btree (m_product_id)
    "m_costing_product_date" btree (m_product_id, datefrom, dateto)

    "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)

    "mrp_run_purchline_purchase_id" btree (mrp_run_purchase_id)
    "mrp_run_purhcline_purch_prod" btree (mrp_run_purchase_id, m_product_id)

    "mrp_productionline_id_prod_id" btree (mrp_run_production_id, m_product_id)
    "mrp_run_prodline_production_id" btree (mrp_run_production_id)

    "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 SolutionDelete individual indexes, because the combined index having the column in the first position, produces the same index.

Attached diff solution.
TagsNo tags attached.
Attached Filesdiff file icon duplicateIndexes.diff [^] (4,725 bytes) 2020-02-19 13:40 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
hgbot (developer)
2020-02-26 10:46

Repository: erp/devel/pi
Changeset: b130c2f44f08e45ad23da49db0904f643e5a6282
Author: Atul Gaware <atul.gaware <at>>
Date: Thu Feb 20 23:28:00 2020 +0530
URL: [^]

Fixes BUG-0043264:Duplicate Indexes in some core table definitions

**Remove duplicate indexes for
**Documentno in C_ORDER

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
dmiguelez (developer)
2020-02-26 10:49

Code Review + Testing Ok

- 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 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 => [^]
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker