Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] I. Performanceminoralways2016-02-04 11:292016-02-04 11:29
ReporteraferrazView Statuspublic 
Assigned ToTriage Finance 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionProfessional ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0032121: Some computed columns should not be computed

DescriptionSome computed columns should be reviewed and updated in case they could be a normal column instead of a computed one:

- processed_logic column in S_TimeExpense table:
select processed from S_TimeExpense TE where TE.S_TimeExpense_id=S_TimeExpense_id

- closedStat column in MA_WorkRequirement table:
select closed from dual

- date_end column in OBRE_Reservation table:
(select end_time from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

- time_end in OBRE_Reservation table:
(select to_char(end_time, 'HH12:MI:SS') from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

- date_start in OBRE_Reservation table:
(select start_time from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

- time_start in OBRE_Reservation table:
(select to_char(start_time, 'HH12:MI:SS') from obre_reservation r where r.obre_reservation_id = obre_reservation_id)

Also some sqllogic of them could be improved:

- lastreconciliation column in FIN_Financial_Account table:
(select max(fr.dateto) from fin_financial_account ff , fin_reconciliation fr where ff.fin_financial_account_id=fr.fin_financial_account_id and ff.fin_financial_account_id=fin_financial_account_id)
Steps To ReproduceN/A
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2016-02-04 11:29 aferraz New Issue
2016-02-04 11:29 aferraz Assigned To => Triage Finance
2016-02-04 11:29 aferraz Modules => Core
2016-02-04 11:29 aferraz Triggers an Emergency Pack => No

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker