[SQL] Bug with DISTINCT?

[Ruslan Zasukhin]

on 1/16/04 11:14 AM, Martin Kloss at martin.kloss at gmx.de wrote:

> 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?

Yes.

> 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.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------