[SQL] Bug with DISTINCT?

[Martin Kloss]

At 08:39 16.01.2004, you wrote:
> >> RecID field not works correctly if you use it in ORDER BY.
> >
> > So when I query "SELECT DISTINCT RecID ..." there is in implicit "ORDER BY
> > RecID"? Is it what you means?
>
>Yes.
>
>DISTINCT always must sort records at first.
>
>Then it throw out the same records.

Will this bug be fixed in the next release?

Because sorting by RecID seems the natural thing to do,
even though it will be sorted by RecID if no sort order is given.
But it should definitely not return 0 records if you sort by
RecID in this case.

Martin.