[Developers] South Carolina weirdness

[Jason Douglas]

On Jun 4, 2008, at 10:51 AM, Arthur van Hoff wrote:

> Hi Will,
>
> I've seen this happen in our code several times. Although the schema
> allows you to specify properties to have unique values, there does not
> appear to be strict enforcement of this rule.
>
> It is very annoying to write all queries assuming that any property
> (even when it is marked unique) can return multiple values. However,  
> if
> you don't do this your code is fragile, and will trip up easily in  
> case
> of a bad insert. I wish there was a better solution.

I share this frustration, although I've ended up making liberal use of  
"limit":1 in my queries for what, in theory, are unique properties   
rather than accommodating multiple values in the presentation code.

-jason