Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0056900Retail ModulesWeb POSpublic2024-10-25 09:002024-10-25 10:29
Reporterguillermogil 
Assigned Toguillermogil 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerGold
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0056900: Missing index in m_ch_value_id on m_product_ch_org
DescriptionMissing index in m_ch_value_id on m_product_ch_org is making Characteristic Value query slow
Steps To ReproduceN/A
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0056901RR24Q4 closed guillermogil Missing index in m_ch_value_id on m_product_ch_org 
depends on backport 0056902RR24Q3.3 closed guillermogil Missing index in m_ch_value_id on m_product_ch_org 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2024-10-25 09:00guillermogilNew Issue
2024-10-25 09:00guillermogilAssigned To => guillermogil
2024-10-25 09:00guillermogilOBNetwork customer => Gold
2024-10-25 09:00guillermogilTriggers an Emergency Pack => No
2024-10-25 09:00guillermogilStatusnew => scheduled
2024-10-25 09:08hgbotMerge Request Status => open
2024-10-25 09:08hgbotNote Added: 0170936
2024-10-25 10:29hgbotMerge Request Statusopen => approved
2024-10-25 10:29hgbotResolutionopen => fixed
2024-10-25 10:29hgbotStatusscheduled => closed
2024-10-25 10:29hgbotFixed in Version => PR25Q1
2024-10-25 10:29hgbotNote Added: 0170950
2024-10-25 10:29hgbotNote Added: 0170951

Notes
(0170936)
hgbot   
2024-10-25 09:08   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1406 [^]
(0170950)
hgbot   
2024-10-25 10:29   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 1407d904c206338ea06e8bd00424354cde30a953
Author: Guillermo Gil <g.gil@orisha.com>
Date: 25-10-2024 09:06:52
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/1407d904c206338ea06e8bd00424354cde30a953 [^]

Fixed ISSUE-56900: Missing index in m_ch_value_id on m_product_ch_org

---
M src-db/database/model/tables/M_PRODUCT_CH_ORG.xml
---
(0170951)
hgbot   
2024-10-25 10:29   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/1406 [^]