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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0035204
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminorhave not tried2017-02-08 16:422017-03-15 20:19
ReporteralostaleView Statuspublic 
Assigned Toinigosanchez 
PrioritynormalResolutionfixedFixed in Version3.0PR17Q2
StatusclosedFix in branchFixed in SCM revisiondc6931edb0e1
ProjectionnoneETAnoneTarget Version3.0PR17Q2
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tocaristu
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035204: 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
TagsPerformance
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on feature request 0032211 closedcaristu support for partial indexes 
related to feature request 0035205 closedvmromanos define partial indexes for not null values 
related to feature request 0035206 closedmarvintm define partial indexes for not null values 

-  Notes
(0094439)
hgbot (developer)
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 (developer)
2017-02-24 15:19

 Reviewed
(0095192)
hudsonbot (developer)
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

- Issue History
Date Modified Username Field Change
2017-02-08 16:42 alostale New Issue
2017-02-08 16:42 alostale Assigned To => platform
2017-02-08 16:42 alostale Modules => Core
2017-02-08 16:42 alostale Triggers an Emergency Pack => No
2017-02-08 16:42 alostale Relationship added depends on 0032211
2017-02-08 16:43 alostale Tag Attached: Performance
2017-02-08 16:43 alostale Issue cloned 0035205
2017-02-08 16:43 alostale Relationship added related to 0035205
2017-02-08 16:45 alostale Relationship added related to 0035206
2017-02-08 17:01 alostale Steps to Reproduce Updated View Revisions
2017-02-08 17:01 alostale Proposed Solution updated
2017-02-08 17:01 alostale Status new => acknowledged
2017-02-09 10:27 alostale Status acknowledged => scheduled
2017-02-09 10:27 alostale Assigned To platform => inigosanchez
2017-02-09 10:30 alostale Target Version => 3.0PR17Q2
2017-02-17 08:46 inigosanchez Review Assigned To => caristu
2017-02-17 08:47 hgbot Checkin
2017-02-17 08:47 hgbot Note Added: 0094439
2017-02-17 08:47 hgbot Status scheduled => resolved
2017-02-17 08:47 hgbot Resolution open => fixed
2017-02-17 08:47 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/dc6931edb0e1cfb9cfc8aa4f587c09c52c9dedf9 [^]
2017-02-21 11:55 shuehner Issue Monitored: shuehner
2017-02-24 15:19 caristu Note Added: 0094618
2017-02-24 15:19 caristu Status resolved => closed
2017-02-24 15:19 caristu Fixed in Version => 3.0PR17Q2
2017-03-15 20:19 hudsonbot Checkin
2017-03-15 20:19 hudsonbot Note Added: 0095192

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker