Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!emory!cheung
From: cheung@mathcs.emory.edu (Shun Yan Cheung)
Newsgroups: comp.databases
Subject: Bug in distinct function in Unify
Message-ID: <7215@emory.mathcs.emory.edu>
Date: 20 Mar 91 16:14:52 GMT
Organization: Emory University, Dept of Math and CS
Lines: 42


I think there is a bug in Unify's distinct function.
I first tried this query:

	select pnum, jnum
	from   spj
	group  by pnum, jnum
	having avg(qty) > 200;

And get the result:

	recognized query!

	pnum ,jnum
	------------
	p1   ,j4   
	p3   ,j4   
	p3   ,j5   
	p3   ,j6   
	p3   ,j7   
	p4   ,j2   
	p4   ,j4   
	p5   ,j4   
	p5   ,j5   
	p6   ,j3   
	p6   ,j4   
	p6   ,j7   


Next:

	select distinct pnum, jnum
	from   spj
	group  by pnum, jnum
	having avg(qty) > 200;

And now it does not give me any tuples.
-- 
Shun Yan Cheung     |  cheung@mathcs.emory.edu                  Internet
Emory University    |  cheung@emory.bitnet			BITNET
Dept of Math and CS |  Voice: (404) 727-3823
Atlanta, GA 30322   |  Engineering: make it work. Research: make it work BETTER