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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0036327
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Retail Configurationminoralways2017-06-23 14:162017-06-27 08:55
ReportermigueldejuanaView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionfixedFixed in VersionRR17Q3
StatusclosedFix in branchFixed in SCM revision26ec4b145829
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036327: Api-change: Change obretco_prol_product_un unique constraint

DescriptionCurrent for access of obretco_prol_product it uses the auto-created index for the unique constraint:
    "obretco_prol_product_un" UNIQUE CONSTRAINT, btree (ad_client_id, m_product_id, obretco_productlist_id)
The part ad_client_id seems functionally useless. as no data can be created for this table in ad_client_id=0 and no normal uuid for products or assortment is possible to be re-used cross-client.
So extra adding ad_client_id does not change anything.

The order of the remaining columns should be swapped to be
obretco_productlist_id, m_product_id
because in ProductPrice.java we are filtering by obretco_productlist_id but not by m_product_id, so we need swap them to make useful the auto-created index.
Steps To ReproduceSee Description
TagsApproved
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0036312 closedmigueldejuana Improve performance of ProducePrice masterdata loading 

-  Notes
(0097663)
hgbot (developer)
2017-06-26 15:40

 Repository: retail/api-checks-retail
Changeset: 26ec4b14582916b26760f3e036de9f49ed9d4afd
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Mon Jun 26 15:40:05 2017 +0200
URL: http://code.openbravo.com/retail/api-checks-retail/rev/26ec4b14582916b26760f3e036de9f49ed9d4afd [^]

Fixed issue 0036327: Api-change: Change obretco_prol_product_un unique constraint. Approved Api change. Related to issue 36312

---
M model/modules/org.openbravo.retail.config/src-db/database/model/tables/OBRETCO_PROL_PRODUCT.xml
---

- Issue History
Date Modified Username Field Change
2017-06-23 14:16 migueldejuana New Issue
2017-06-23 14:16 migueldejuana Assigned To => migueldejuana
2017-06-23 14:16 migueldejuana OBNetwork customer => No
2017-06-23 14:16 migueldejuana Triggers an Emergency Pack => No
2017-06-23 14:16 migueldejuana Assigned To migueldejuana => dmitry_mezentsev
2017-06-23 14:20 dmitry_mezentsev Tag Attached: Approved
2017-06-23 14:20 dmitry_mezentsev Assigned To dmitry_mezentsev => migueldejuana
2017-06-23 14:21 migueldejuana Relationship added related to 0036312
2017-06-26 15:40 hgbot Checkin
2017-06-26 15:40 hgbot Note Added: 0097663
2017-06-26 15:40 hgbot Status new => resolved
2017-06-26 15:40 hgbot Resolution open => fixed
2017-06-26 15:40 hgbot Fixed in SCM revision => http://code.openbravo.com/retail/api-checks-retail/rev/26ec4b14582916b26760f3e036de9f49ed9d4afd [^]
2017-06-27 08:55 marvintm Review Assigned To => marvintm
2017-06-27 08:55 marvintm Status resolved => closed
2017-06-27 08:55 marvintm Fixed in Version => RR17Q3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker