Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006378Openbravo ERPA. Platformpublic2008-12-05 11:042012-01-30 10:37
Reportermtaal 
Assigned Tomarvintm 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionduplicate 
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
Summary0006378: Foreign Key ID fields have wrong fieldlength of 12, should be 32
DescriptionI noticed that there are many foreign key id fields which have their field length set to 12. With uuid's the correct length is 32.
You can find all columns with fieldlength 12 like this:
select * from ad_column where fieldlength=12

Note, this query will also return non-foreign-key fields for which it can make sense to have fieldlength=12, this needs to be analyzed.

The same issue occurred with primary key fields which had their fieldlength set to 12, but I will solve this later today.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of design defect 0006401 acknowledged marvintm Many foreign key ID fields have fieldlength set to 22, Is this correct? Afaik ID's are uuid which are always 32 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-05 11:04mtaalNew Issue
2008-12-05 11:04mtaalAssigned To => rafaroda
2008-12-05 11:04mtaalsf_bug_id0 => 2392262
2008-12-05 11:04mtaalRegression testing => No
2008-12-09 13:02pheenanAssigned Torafaroda => Hennadzi
2008-12-09 14:31PavelPonomarevAssigned ToHennadzi => pheenan
2008-12-09 23:31pheenanStatusnew => acknowledged
2008-12-18 10:20rafarodaRelationship addedrelated to 0006401
2008-12-18 10:20rafarodaAssigned Topheenan => rafaroda
2009-01-10 17:41rafarodaAssigned Torafaroda => marvintm
2012-01-30 10:36marvintmStatusacknowledged => scheduled
2012-01-30 10:36marvintmfix_in_branch => pi
2012-01-30 10:37marvintmRelationship replacedduplicate of 0006401
2012-01-30 10:37marvintmNote Added: 0044683
2012-01-30 10:37marvintmStatusscheduled => closed
2012-01-30 10:37marvintmResolutionopen => duplicate

Notes
(0044683)
marvintm   
2012-01-30 10:37   
This is a duplicate of issue 6401