Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010546Openbravo ERPZ. Otherspublic2009-09-10 14:042009-09-19 00:00
Reportershuehner 
Assigned Toalostale 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010546: API check build 135 fails
DescriptionThis api check build fails:

http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/135/console [^]

This issue tracks the following problem:

  Check Constraint addition: table: AD_MODULE - Constraint: AD_MODULE_ISCOMMERCIAL_CHCK
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to defect 0010363 closed alostale AD_MODULE table has new column iscommerical, but is missing check constraint for boolean type 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-10 14:04shuehnerNew Issue
2009-09-10 14:04shuehnerAssigned To => alostale
2009-09-10 14:04shuehnerOBNetwork customer => No
2009-09-10 14:05shuehnerNote Added: 0019724
2009-09-10 14:06shuehnerNote Added: 0019725
2009-09-10 14:06shuehnerRelationship addedrelated to 0010363
2009-09-17 11:19pjuvaraNote Added: 0020129
2009-09-17 11:19pjuvaraStatusnew => scheduled
2009-09-17 11:19pjuvarafix_in_branch => pi
2009-09-17 11:46hgbotCheckin
2009-09-17 11:46hgbotNote Added: 0020132
2009-09-17 11:46hgbotStatusscheduled => resolved
2009-09-17 11:46hgbotResolutionopen => fixed
2009-09-17 11:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/cc3876f420a353139cdb9c286360667b77b87226 [^]
2009-09-17 12:01alostaleStatusresolved => closed
2009-09-19 00:00anonymoussf_bug_id0 => 2861734

Notes
(0019724)
shuehner   
2009-09-10 14:05   
This commit adds a missing unique constraint (Y,N for a boolean column) which was forgotten when the columns was recently added.

changeset: 4869:4019c5011d70
user: Asier Lostalé <asier.lostale@openbravo.com>
date: Fri Sep 04 11:16:28 2009 +0200
files: src-db/database/model/tables/AD_MODULE.xml
description:
fixed bug 0010363: AD_MODULE table has new column iscommerical, but is missing check constraint for boolean type
(0019725)
shuehner   
2009-09-10 14:06   
@pjuvara: Suggestion: ack without notice as exception, as boolean values entered from the UI can only contain Y,N
(0020129)
pjuvara   
2009-09-17 11:19   
Please acknowledge as exception but also send a notice, specifying that the risk is null for the reason above and the fact that up to now this column has not been used.
(0020132)
hgbot   
2009-09-17 11:46   
Repository: erp/devel/api-checks
Changeset: cc3876f420a353139cdb9c286360667b77b87226
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Sep 17 11:45:46 2009 +0200
URL: http://code.openbravo.com/erp/devel/api-checks/rev/cc3876f420a353139cdb9c286360667b77b87226 [^]

fixed bug 0010546: API check build 135 fails

---
M model/model/tables/AD_MODULE.xml
---