Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0028680 | Openbravo ERP | A. Platform | public | 2015-01-19 17:45 | 2015-01-19 17:45 |
| Reporter | egoitz | ||||
| Assigned To | AugustoMauch | ||||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| 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 | 0028680: Create a index for each column used on a foreign key constraint | ||||
| Description | Create a index for each column used on a foreign key constraint. | ||||
| Steps To Reproduce | Check that not all the columns used on a foreign key constraint have an index: Execute on oracle: SELECT p.table_name parent_table, c.table_name || '.' || cc.column_name referenced_by FROM user_constraints c, user_cons_columns cc, user_constraints p WHERE c.constraint_name = cc.constraint_name AND c.constraint_type = 'R' AND c.r_constraint_name = p.constraint_name AND p.constraint_type = 'P' and not exists ( SELECT i.table_name, ic.column_name, ic.column_position FROM user_indexes i, user_ind_columns ic WHERE i.index_name = ic.index_name and i.table_name = c.table_name and ic.column_name = cc.column_name and ic.column_position = cc.position ) ORDER BY cc.table_name, cc.column_name ; | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-01-19 17:45 | egoitz | New Issue | |||
| 2015-01-19 17:45 | egoitz | Assigned To | => AugustoMauch | ||
| 2015-01-19 17:45 | egoitz | Modules | => Core | ||
| 2015-01-19 17:45 | egoitz | Triggers an Emergency Pack | => No | ||
| 2015-01-19 17:45 | egoitz | Note Added: 0073620 | |||
| Notes | |||||
|
|
|||||
|
|
||||