Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0051331 | Openbravo ERP | A. Platform | public | 2023-01-11 15:36 | 2023-01-11 15:44 |
| Reporter | alostale | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0051331: IndexesTest does not check FKs from external modules | ||||
| Description | IndexesTest, that looks for missing indexes in tables used in subtabs, does not take into account FKs if the column is added from a different module than the table. | ||||
| Steps To Reproduce | 1. Create a new module with some dbprefix (ie. TEST) 2. In that module define a FK column in a table existing in some other module (ie. AD_ALERT.EM_TEST_C_ORDER_ID) 3. Create a subtab making use of that column. (ie. Sales Order > Alert) 4. Run IndexesTest Got: no error Expected: the test should fail as there is no index in the new FK column | ||||
| Proposed Solution | Current query depends on some compat ORA-PG view, which makes things slow and complicated. There might no need to used this, we could be PG compatible only if we skip the test in ORA. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2023-01-11 15:36 | alostale | New Issue | |||
| 2023-01-11 15:36 | alostale | Assigned To | => Triage Platform Base | ||
| 2023-01-11 15:36 | alostale | OBNetwork customer | => No | ||
| 2023-01-11 15:36 | alostale | Modules | => Core | ||
| 2023-01-11 15:36 | alostale | Triggers an Emergency Pack | => No | ||
| 2023-01-11 15:37 | alostale | Note Added: 0145262 | |||
| 2023-01-11 15:43 | alostale | Proposed Solution updated | |||
| 2023-01-11 15:44 | alostale | Note Added: 0145263 | |||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||