[news.eclipse.dtp] Re: erroneous repeating row values in SQL Results vie

["Brian Fitzpatrick" <brianf@xxxxxxxxxx>]

Hi Chris...

The people who would typically respond to your question are on holiday at 
the moment. Please be patient and I'm sure they'll respond when they get 
back next week.

--Fitz

"Chris Giblin" <cgi@xxxxxxxxxxxxxx> wrote in message 
news:h0372v$96d$1@xxxxxxxxxxxxxxxxxxxx
> Hi,
> When I perform a join on two tables (each table has ~3400 rows), a number 
> of rows are copiously repeated towards the end of the displayed result 
> set. For example, there will be 12 "John Smith" rows followed by 7 "John 
> Doe" rows. I know that these rows really do not occur in duplicate in the 
> tables, I suspect something is wrong in the result set processing.
>
> The join statement is nothing crazy:
> select app.id.cn,app.hr.hrnum from app.id join app.hr on app.id.empnum = 
> app.hr.hrnum
>
> In the Data Management Preferences, I have set max row count and max 
> display row count both to 4000. It is as if the result view fills up the 
> empty rows at the end with duplicates from the result set. That is, fills 
> up all 4000 rows even though result set was some 3000 rows.
>
> I am using a ganymede birt build from eclipse.org with these versions:
>   BIRT 2.3.2
>   DTP 1.6.2
>   Eclipse 3.4.2
>   EMF 2.4.2
>
> Has anyone else also seen this behavior?
>
> Thanks, chris