Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020646Openbravo ERP00. Application dictionarypublic2012-05-30 15:432019-10-22 12:54
Reporterjvazquez 
Assigned Todmiguelez 
PrioritynoneSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020646: Some isactive columns lack check constraint
DescriptionThere are some isactive columns that do not have the CONSTRAINT x_isactive_check CHECK (isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])).
Steps To ReproduceGo to the src-db/database/model/tables directory. Execute grep -ir ISACTIVE . and if a table has the constraint, it will appear twice - the column definition and th constraint itself.
Some example of tables that will only appear once (as they don't have the constraint are: c_remmittanceline, c_order_discount, ad_module_log, c_acct_rpt_group, etc.
Proposed SolutionFirst, create a SQL sentence that allows to clearly identify tables that do not have the constraint.
Then add the constraint to resultant set of tables.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0020647 closed naiaramartinez Fin_payment_run_para has same constraint twice 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-05-30 15:43jvazquezNew Issue
2012-05-30 15:43jvazquezAssigned To => alostale
2012-05-30 15:43jvazquezModules => Core
2012-05-30 15:45jvazquezIssue Monitored: AugustoMauch
2012-05-30 15:52jvazquezRelationship addedrelated to 0020647
2012-05-31 08:51alostaleTypedefect => design defect
2012-09-10 12:50alostaleAssigned Toalostale => dmiguelez
2019-10-22 12:54AugustoMauchIssue End Monitor: AugustoMauch

There are no notes attached to this issue.