Re: Examples of SQL anomalies?
Date: Thu, 03 Jul 2008 12:14:04 -0300
>>David Cressey wrote: >> >> >>>>MIN, MAX and AVG are meaningless when applied to an empty bag, but it seems >> >>Bullshit! The identity element for min is the largest representable >>value. The identity element for max is the smallest representable element.
> I don't entirely agree.
> Certainly for mathematical integers, there is no largest representable
> element. In more practical terms, one can imagine an "arbitrary"
> precision integer, which starts with a 32 bit length value followed
> by that many 32 bit quantities of bits. Although one *could*,
> on attempting to evaluation MIN of an empty set/bag, return
> the smallest representable number,
That would be largest not smallest.
it's not clear that allocating
> the 16 gigabytes of RAM that are necessary to do so is a good
> For fixed-size integer values, there are no implementation
> However, I'm not sure that semantically, this is entirely what we
> want, even though there is the very strong argument that the
> smallest int is the identity for the operation.
Largest int is the identity for MIN. Received on Thu Jul 03 2008 - 17:14:04 CEST