Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035204Openbravo ERPA. Platformpublic2017-02-08 16:422017-03-15 20:19
Reporteralostale 
Assigned Toinigosanchez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR17Q2Fixed in Version3.0PR17Q2 
Merge Request Status
Review Assigned Tocaristu
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035204: define partial indexes for not null values
DescriptionReview the indexes that should be set as partial for only null values.

Analyzed data in some actual customers: https://docs.google.com/spreadsheets/d/1KYvFTQgRrAUgjwUJj3L-LJQ_VYfiqO6XEcIb8Sq8j6k/edit#gid=109022771 [^]
Steps To ReproduceSee http://wiki.openbravo.com/wiki/Constraints_and_Triggers#Partial_indexes [^]
Proposed SolutionIndexes to be made partial on not null values:
ad_process_run_adprgroup_id
ad_column_process
obuiapp_paramval_file_idx
ad_tab_tabletree_fk
obuiapp_parameter_tab_idx
obuiapp_parameter_attmet_idx
ad_modelobject_reference_idx
ad_modelobject_form_idx
ad_modelobject_callout_idx
ad_modelobject_process_idx
em_obkmo_param_widget
obuiapp_parameter_process
obcql_widget_query_ds
Additional Information
TagsPerformance
Relationships
depends on feature request 0032211 closed caristu support for partial indexes 
related to feature request 0035205 closed vmromanos define partial indexes for not null values 
related to feature request 0035206 closed marvintm define partial indexes for not null values 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-02-08 16:42alostaleNew Issue
2017-02-08 16:42alostaleAssigned To => platform
2017-02-08 16:42alostaleModules => Core
2017-02-08 16:42alostaleTriggers an Emergency Pack => No
2017-02-08 16:42alostaleRelationship addeddepends on 0032211
2017-02-08 16:43alostaleTag Attached: Performance
2017-02-08 16:43alostaleIssue cloned0035205
2017-02-08 16:43alostaleRelationship addedrelated to 0035205
2017-02-08 16:45alostaleRelationship addedrelated to 0035206
2017-02-08 17:01alostaleSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=14524#r14524
2017-02-08 17:01alostaleProposed Solution updated
2017-02-08 17:01alostaleStatusnew => acknowledged
2017-02-09 10:27alostaleStatusacknowledged => scheduled
2017-02-09 10:27alostaleAssigned Toplatform => inigosanchez
2017-02-09 10:30alostaleTarget Version => 3.0PR17Q2
2017-02-17 08:46inigosanchezReview Assigned To => caristu
2017-02-17 08:47hgbotCheckin
2017-02-17 08:47hgbotNote Added: 0094439
2017-02-17 08:47hgbotStatusscheduled => resolved
2017-02-17 08:47hgbotResolutionopen => fixed
2017-02-17 08:47hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dc6931edb0e1cfb9cfc8aa4f587c09c52c9dedf9 [^]
2017-02-21 11:55shuehnerIssue Monitored: shuehner
2017-02-24 15:19caristuNote Added: 0094618
2017-02-24 15:19caristuStatusresolved => closed
2017-02-24 15:19caristuFixed in Version => 3.0PR17Q2
2017-03-15 20:19hudsonbotCheckin
2017-03-15 20:19hudsonbotNote Added: 0095192

Notes
(0094439)
hgbot   
2017-02-17 08:47   
Repository: erp/devel/pi
Changeset: dc6931edb0e1cfb9cfc8aa4f587c09c52c9dedf9
Author: Inigo Sanchez <inigo.sanchez <at> openbravo.com>
Date: Thu Feb 16 09:29:15 2017 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/dc6931edb0e1cfb9cfc8aa4f587c09c52c9dedf9 [^]

Fixed issue 35204: define partial indexes for not null values

The following indexes have been transformed into partial indexes:
-ad_process_run_adprgroup_id
-ad_column_process
-obuiapp_paramval_file_idx
-ad_tab_tabletree_fk
-obuiapp_parameter_tab_idx
-obuiapp_parameter_attmet_idx
-ad_modelobject_reference_idx
-ad_modelobject_form_idx
-ad_modelobject_callout_idx
-ad_modelobject_process_idx
-em_obkmo_param_widget
-obuiapp_parameter_process
-obcql_widget_query_ds

---
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER.xml
M modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_PARAMETER_VALUE.xml
M modules/org.openbravo.client.myob/src-db/database/model/modifiedTables/OBUIAPP_PARAMETER.xml
M modules/org.openbravo.client.querylist/src-db/database/model/tables/OBCQL_WIDGET_QUERY.xml
M src-db/database/model/tables/AD_COLUMN.xml
M src-db/database/model/tables/AD_MODEL_OBJECT.xml
M src-db/database/model/tables/AD_PROCESS_RUN.xml
M src-db/database/model/tables/AD_TAB.xml
---
(0094618)
caristu   
2017-02-24 15:19   
Reviewed
(0095192)
hudsonbot   
2017-03-15 20:19   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/54e102bef53e [^]
Maturity status: Test