Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!wuarchive!uunet!fciva!dag
From: dag@fciva.FRANKCAP.COM (Daniel A. Graifer)
Newsgroups: comp.databases
Subject: Re: Problem with SQL join/group-by in Unify database (long)
Message-ID: <586@fciva.FRANKCAP.COM>
Date: 21 Jan 91 16:19:11 GMT
References: <584@fciva.FRANKCAP.COM> <1991Jan21.001428.21987@NCoast.ORG>
Reply-To: dag@fciva.UUCP (Daniel A. Graifer)
Distribution: na
Organization: Coastal Capital Funding Corp., McLean, VA
Lines: 20

In article <1991Jan21.001428.21987@NCoast.ORG> allbery@ncoast.ORG (Brandon S. Allbery KB8JRR) writes:
>There is indeed a bug here... but not the one you think.  A selection using
>GROUP BY must group by all the non-aggregates in the SELECT clause or the
>result is undefined.  Most ANSI SQL's catch this; Unify 4.0 SQL does not, and
>instead silently mis-groups things.  Try grouping by both rd_co_id and
>rd_co_name here.  
>
>++Brandon

This fixed it.  Thanks a million Brandon!  Gosh, I love the net :-)

Has this bug been submitted to the list (uug-old-bug@Transact.COM) that
Steven List is building for Unify?

Dan
-- 
Daniel A. Graifer			Coastal Capital Funding Corp.
Sr. Vice President, Financial Systems	7900 Westpark Dr. Suite A-130
(703)821-3244				McLean, VA  22102
uunet!fciva!dag				fciva.FRANKCAP.COM!dag@uunet.uu.net