Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0036327Retail ModulesRetail Configurationpublic2017-06-23 14:162017-06-27 08:55
Reportermigueldejuana 
Assigned Tomigueldejuana 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q3 
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
Summary0036327: 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
Proposed Solution
Additional Information
TagsApproved
Relationships
related to defect 0036312 closed migueldejuana Improve performance of ProducePrice masterdata loading 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-06-23 14:16migueldejuanaNew Issue
2017-06-23 14:16migueldejuanaAssigned To => migueldejuana
2017-06-23 14:16migueldejuanaOBNetwork customer => No
2017-06-23 14:16migueldejuanaTriggers an Emergency Pack => No
2017-06-23 14:16migueldejuanaAssigned Tomigueldejuana => dmitry_mezentsev
2017-06-23 14:20dmitry_mezentsevTag Attached: Approved
2017-06-23 14:20dmitry_mezentsevAssigned Todmitry_mezentsev => migueldejuana
2017-06-23 14:21migueldejuanaRelationship addedrelated to 0036312
2017-06-26 15:40hgbotCheckin
2017-06-26 15:40hgbotNote Added: 0097663
2017-06-26 15:40hgbotStatusnew => resolved
2017-06-26 15:40hgbotResolutionopen => fixed
2017-06-26 15:40hgbotFixed in SCM revision => http://code.openbravo.com/retail/api-checks-retail/rev/26ec4b14582916b26760f3e036de9f49ed9d4afd [^]
2017-06-27 08:55marvintmReview Assigned To => marvintm
2017-06-27 08:55marvintmStatusresolved => closed
2017-06-27 08:55marvintmFixed in Version => RR17Q3

Notes
(0097663)
hgbot   
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
---