Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006378
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2008-12-05 11:042012-01-30 10:37
ReportermtaalView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionduplicateFixed in Version
StatusclosedFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006378: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of design defect 0006401 acknowledgedmarvintm Many foreign key ID fields have fieldlength set to 22, Is this correct? Afaik ID's are uuid which are always 32 

-  Notes
(0044683)
marvintm (developer)
2012-01-30 10:37

This is a duplicate of issue 6401

- Issue History
Date Modified Username Field Change
2008-12-05 11:04 mtaal New Issue
2008-12-05 11:04 mtaal Assigned To => rafaroda
2008-12-05 11:04 mtaal sf_bug_id 0 => 2392262
2008-12-05 11:04 mtaal Regression testing => No
2008-12-09 13:02 pheenan Assigned To rafaroda => Hennadzi
2008-12-09 14:31 PavelPonomarev Assigned To Hennadzi => pheenan
2008-12-09 23:31 pheenan Status new => acknowledged
2008-12-18 10:20 rafaroda Relationship added related to 0006401
2008-12-18 10:20 rafaroda Assigned To pheenan => rafaroda
2009-01-10 17:41 rafaroda Assigned To rafaroda => marvintm
2012-01-30 10:36 marvintm Status acknowledged => scheduled
2012-01-30 10:36 marvintm fix_in_branch => pi
2012-01-30 10:37 marvintm Relationship replaced duplicate of 0006401
2012-01-30 10:37 marvintm Note Added: 0044683
2012-01-30 10:37 marvintm Status scheduled => closed
2012-01-30 10:37 marvintm Resolution open => duplicate


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker