Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0035206 | Openbravo ERP | A. Platform | public | 2017-02-08 16:45 | 2017-04-06 18:01 |
|
| Reporter | alostale | |
| Assigned To | marvintm | |
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | duplicate | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | 3.0PR17Q2 | |
| Merge Request Status | |
| Review Assigned To | marvintm |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0035206: define partial indexes for not null values |
| Description | Review 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 Reproduce | See http://wiki.openbravo.com/wiki/Constraints_and_Triggers#Partial_indexes [^] |
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | duplicate of | defect | 0035267 | | closed | marvintm | Retail Modules | Some indexes can be improved | | related to | feature request | 0035204 | 3.0PR17Q2 | closed | inigosanchez | Openbravo ERP | define partial indexes for not null values | | related to | feature request | 0035205 | | closed | vmromanos | Openbravo ERP | define partial indexes for not null values | | depends on | feature request | 0032211 | | closed | caristu | Openbravo ERP | support for partial indexes | | related to | defect | 0038722 | | new | Retail | Retail Modules | Change to partial index em_obrcifp_bpartner index |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2017-02-08 16:45 | alostale | New Issue | |
| 2017-02-08 16:45 | alostale | Assigned To | => marvintm |
| 2017-02-08 16:45 | alostale | Modules | => Core |
| 2017-02-08 16:45 | alostale | Triggers an Emergency Pack | => No |
| 2017-02-08 16:45 | alostale | Issue generated from | 0035205 |
| 2017-02-08 16:45 | alostale | Relationship added | related to 0035204 |
| 2017-02-08 16:45 | alostale | Relationship added | related to 0035205 |
| 2017-02-08 16:45 | alostale | Relationship added | depends on 0032211 |
| 2017-04-06 18:01 | marvintm | Review Assigned To | => marvintm |
| 2017-04-06 18:01 | marvintm | Relationship added | duplicate of 0035267 |
| 2017-04-06 18:01 | marvintm | Status | new => closed |
| 2017-04-06 18:01 | marvintm | Resolution | open => duplicate |
| 2017-04-06 18:01 | marvintm | Fixed in Version | => 3.0PR17Q2 |
| 2018-06-07 16:29 | Sandrahuguet | Relationship added | related to 0038722 |