Hello fellows,

I've just found a curious thing - running same select with and without
ORDER BY clause returns different number of rows. It looks like DISTINCT
clause forced somehow select statement to return only the first row for
each set of values in ORDER BY:
select domain_name,set_name,class_name from bu_copygroups order by
class_name
works fine - just as it ought to.

However the result of the same with DISTINCT is not so good:
select distinct domain_name,set_name,class_name from bu_copygroups order
by class_name

If the ORDER BY clause contains all the fields it returns good results:
select distinct domain_name,set_name,class_name from bu_copygroups -
order by class_name,domain_name,set_name

Again good results if we omit ORDER BY clause:
select distinct domain_name,set_name,class_name from bu_copygroups

Environment:
TSM server 4.1.4.1 on AIX 4.3.3ML6 or TSM server 4.2.1.15 on W2k SP2
TSM client 4.1.3.0 on AIX or 4.2.1.32 on W2k

PMR opened with IBM/Tivoli. Can someone try it on ISM v5.1?


Zlatko Krastev
IT Consultant