Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006401Openbravo ERPA. Platformpublic2008-12-08 21:052012-04-26 13:13
Reportermtaal 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
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
Summary0006401: Many foreign key ID fields have fieldlength set to 22, Is this correct? Afaik ID's are uuid which are always 32
DescriptionThere are many foreign key fields which have their fieldlength set to 22. I think this is incorrect, foreign keys are uuid's which have a length of 32.

You can find the fields by doing a query like this:
select * from ad_column where fieldlength=22 and columnname like '%ID%'
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate defect 0006378 closed marvintm Foreign Key ID fields have wrong fieldlength of 12, should be 32 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-08 21:05mtaalNew Issue
2008-12-08 21:05mtaalAssigned To => rafaroda
2008-12-08 21:06mtaalsf_bug_id0 => 2407424
2008-12-08 21:06mtaalRegression testing => No
2008-12-09 12:30pheenanAssigned Torafaroda => Hennadzi
2008-12-09 14:31PavelPonomarevAssigned ToHennadzi => PavelPonomarev
2008-12-09 14:31PavelPonomarevAssigned ToPavelPonomarev => pheenan
2008-12-09 23:31pheenanStatusnew => acknowledged
2008-12-18 09:57rafarodaAssigned Topheenan => rafaroda
2008-12-18 10:20rafarodaRelationship addedrelated to 0006378
2009-01-10 17:41rafarodaAssigned Torafaroda => marvintm
2012-01-30 10:37marvintmRelationship replacedhas duplicate 0006378
2012-04-26 13:13alostaleTypedefect => design defect

There are no notes attached to this issue.