* Greg Stark (gsstark(at)mit(dot)edu) wrote:
> So not many uses of it in MySQL actually *would* be valid if we
> implemented the shortcut. But MySQL doesn't enforce that so it serves
> that purpose as well as what we get out of DISTINCT ON.
That's probably a good thing- if they're valid then we'd probably return
something different which would be a suprise. I'm not really looking at
this from the "help MySQL apps" point of view.. It just strikes me as
something nice to have.
Thanks,
Stephen