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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0051331
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2023-01-11 15:362023-01-11 15:44
ReporteralostaleView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0051331: IndexesTest does not check FKs from external modules

DescriptionIndexesTest, 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 Reproduce1. 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 SolutionCurrent 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0145262)
alostale (manager)
2023-01-11 15:37

See https://gitlab.com/openbravo/product/pmods/org.openbravo.pos2/-/merge_requests/1379#note_1235794851 [^]
(0145263)
alostale (manager)
2023-01-11 15:44

Before merging this fix, we'd need to ensure CI for all mods is not completely broken.

- 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 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker