ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tom Henricksen" <T...@A-t-g.com>
Subject RE: Group By and a Union, possible collision.
Date Tue, 10 Apr 2007 21:23:00 GMT
Would it be best to make the groupBy use two values one of the id and
one of the type?  We can make the groupBy use two values correct?



-----Original Message-----
From: Nathan Maves [mailto:nathan.maves@gmail.com] 
Sent: Tuesday, April 10, 2007 3:26 PM
To: user-java@ibatis.apache.org
Subject: Re: Group By and a Union, possible collision.


I would assume that it will not handle it in the way you would like.

How could it expect to know the difference.  They in-fact have the same

I could be wrong, so don't take my word for it.


On 4/10/07, Tom Henricksen <TomH@a-t-g.com> wrote:

We are using a groupBy in our query for a report.  In this query there
is a union.  The union is for two different tables and there is a
possibility of a collision of the dispensingId that we are grouping on.
So we could have dispensingId from table one of 50001 and a dispensingId
of 50001 from table two.  These shouldn't be grouped together.  Will
iBatis account for this?  And if not is there a remedy for this?


<resultMap class="RxReportDataRow" groupBy="dispensingId"
extends="rxReportDataRow" id="rxReportDataRowSigDisp">





View raw message