Skip to Content.
Sympa Menu

grouper-dev - Re: [grouper-dev] changing lenght of attribute value column

Subject: Grouper Developers Forum

List archive

Re: [grouper-dev] changing lenght of attribute value column

Chronological Thread 
  • From: David Langenberg <>
  • To: Chris Hyzer <>
  • Cc: Grouper Dev <>
  • Subject: Re: [grouper-dev] changing lenght of attribute value column
  • Date: Thu, 6 Mar 2008 13:04:15 -0600 (CST)

----- "Chris Hyzer"

> That is also an option, thanks. I don’t see this issue in Jira, is
> there an issue number?
> If we really care that it is unique, this might not work since
> multiple inputs can hash to the same value, so I would lean toward one
> of the previous options... but if those aren’t ok, then this would be
> better than now I guess

Well, your constraint is on the triplet group_id, field_name, hash_value so
collisions shouldn't happen anymore than they do now. If you're referring to
the MD5/SHA1 specific collision issues you're chances of a random collision
(sha1) are about 1 in 9 quintillion. You've got a better chance of winning
the lottery and being hit with lightning than getting a random collision.
Attacks are another thing, but honestly, if someone with malicious intent is
in your RDBMS and able to exploit what should be a private, unexposed column
by the API, via direct SQL you've got bigger problems.


David Langenberg
Network Based Services
The University of Chicago

Archive powered by MHonArc 2.6.16.

Top of Page